I had the same problem and I found that if you changed the Text delimiter to a single quote you will get all your rows imported.
-- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1091898 Title: LibreOffice Calc only import 49 lines of CSV file Status in “libreoffice” package in Ubuntu: Expired Bug description: I have a CSV file when when I use LibreOffice Calc to open it - it only imports the first 49 lines. Use MS Excel 2010 I can open the whole file normally. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1091898/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp