This problem is very related to bug 32106 (https://bugs.freedesktop.org/show_bug.cgi?id=32106). For sure, I made this new bug report.
Problem: saving a spreadsheet in .xlsx (both Office Open XML as Microsoft Excel 2007 XML), containing more than 256, will result in data loss (data in column 265 to 1024 will be lost).
How to reproduce?:
- Open a new spreadsheet
- Go to column 256 (this is column 'IV').
- Enter some text in column 'IU', 'IV' and 'IW'.
- Safe as .xlsx format (OOXML or MEXML doesn't matter).
- Reopen file in LibreOffice
Result: text in column 'IW' (row 257) will be lost.
This bug is as far as I know non OS related. (I've done this test with Mac OSX)
I've chosen 'Severity' normal, but I suggest to rate this as 'Major'. (Users, not familiar with this problem shall lose (maybe) important data).
kohei for you I think
Actually xlsx export is for Katarina.
>I've done this test with Mac OSX
Reproduced on LO RC4 Ubuntu 10.04 x86.
Afaik there has been an EXCEL limitation to 256 columns, what might have been a reason to limitate Export to 256 columns:
No idea whether that limitation also exists for xlsx, the bug might be a hangover?
Xlsx supports up to 16,384 columns and 1,048,576 rows. A lot more than 256 columns and 65,536 rows supported by xls. Source: http://documentation.devexpress.com/#XtraReports/CustomDocument6284
I believe this problem will be hdled / fixed together with
Bug 34152 - FILESAVE: Saving Calc as .xlsx limited to 65536 records
So 34152 might be marked as a DUP of this one?
Tested under LO 3.4.1 Mac OS X. Bug solved.