Bug 33493 - Saving to xlsx format truncates sheet data at column 256 ('IV')
Summary: Saving to xlsx format truncates sheet data at column 256 ('IV')
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Katarina Behrens
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 34152
  Show dependency treegraph
 
Reported: 2011-01-25 12:03 UTC by Jorendc
Modified: 2011-07-02 03:33 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jorendc 2011-01-25 12:03:11 UTC
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).
Comment 1 Noel Power 2011-01-25 12:26:33 UTC
kohei for you I think
Comment 2 Kohei Yoshida 2011-01-25 12:39:51 UTC
Actually xlsx export is for Katarina.
Comment 3 tester8 2011-01-25 14:21:31 UTC
>I've done this test with Mac OSX

Reproduced on LO RC4 Ubuntu 10.04 x86.
Comment 4 Rainer Bielefeld Retired 2011-01-25 21:23:02 UTC
Afaik there has been an EXCEL limitation to 256 columns, what might have been a reason to limitate Export to 256 columns:
<http://www.openoffice.org/issues/show_bug.cgi?id=111843>
<http://www.openoffice.org/issues/show_bug.cgi?id=85945>

No idea whether that limitation also exists for xlsx, the bug might be a hangover?
Comment 5 Jorendc 2011-01-26 01:19:01 UTC
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

Kind regards
Comment 6 Rainer Bielefeld Retired 2011-02-10 21:28:58 UTC
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?
Comment 7 Jorendc 2011-07-02 03:33:20 UTC
Tested under LO 3.4.1 Mac OS X. Bug solved.