https://bugs.freedesktop.org/show_bug.cgi?id=74637
Priority: medium
Bug ID: 74637
Assignee: [email protected]
Summary: Spreadsheets silently truncated to 65536 rows when
converting to XLS format
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.4.2 release
Component: Spreadsheet
Product: LibreOffice
I'm using LibreOffice 4.0.4.2 on Scientific Linux 6.5 (based on RHEL6), so I
don't know if this has been fixed in a newer version. Sorry about the noise if
so.
When a spreadsheet with a huge number of rows is saved as an XLS file,
everything after the first 65536 rows appears to be discarded.
(I'm guessing there's a similar problem with huge numbers of columns, but that
I haven't tested.)
Steps to reproduce:
- 'seq 1 100000 > numbers.csv'
- open numbers.csv in libreoffice
- select "save as", format "Microsoft Excel 97/2000/XP/2003 (.xls)"
- there is a general warning about using a non-OpenDocument format, but no
specific mention about a loss of data
- close libreoffice
- open the resulting .xls file
- it only has 65536 rows
I guess this is a limitation of the XLS file format?
In any case, it is a serious bug for libreoffice to silently discard data.
It's true that it shows a warning dialog before saving in XLS format, but:
(a) That dialog is shown *every* time I save a file in a non-OpenDocument
format, regardless of whether the file actually contains any information that
can't be preserved in that format. Therefore, the dialog provides no useful
information in this circumstance.
(b) Silently truncating the table is a much more serious loss of information
than losing some formatting.
(c) The dialog has a checkbox allowing me to prevent it from being shown in
the future. (Moreover, I expect that anyone who regularly needs to work with
MS Office files will have done so.) If the file I'm saving is going to be
truncated, that is always a problem, and *that* warning message should never be
disabled.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
