https://bugs.documentfoundation.org/show_bug.cgi?id=90653

            Bug ID: 90653
           Summary: Opening .csv : Problem with rows
           Product: LibreOffice
           Version: 4.2.7.2 release
          Hardware: Other
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: nefil...@yahoo.com

Created attachment 114824
  --> https://bugs.documentfoundation.org/attachment.cgi?id=114824&action=edit
The .csv file to open

Hello.

I am trying to import a .csv file (see attachment). The file has 16069 rows and
is not especially large (3.3 Mb).
But when I open it with LO, it says "The data could not be loaded completely
because the maximum number of characters per cell was exceeded."

First problem : Calc should not have any problem loading a file with this
number of rows.

Second problem : 
After looking twice, I noticed that the last line of the Calc sheet does match
the last line of the .csv file ( i.e. " La Taille de la Vente;37350;LA
CELLE-GUENAND;INDRE-ET-LOIRE;CENTRE;491439.0;2217742.0;3811Z;Collecte des
déchets non dangereux;;") but the row number does not match the one of the .csv
file :
 - in the Calc sheet, the last row is number 15405 
 - in the .csv file, the last row is number 16069

So I suppose that some rows have been skipped during import.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to