In CSV import a leading ' apostrophe is stripped if the field content continues with a numeric value, e.g. '3 This is related to https://issues.apache.org/ooo/show_bug.cgi?id=60110 but the LibreOffice implementation already does not remove the apostrophe anymore from textual values, only from otherwise numeric values. See test case https://issues.apache.org/ooo/attachment.cgi?id=37545
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5a560e4300295629592716697f13bc803bdeba3c resolved fdo#48731 in CSV import do not strip leading apostrophe
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6ba33f724986752ceffa27b4928d140a4b948ca7 tdf#48731: sc_subsequent_filters: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.