Version: 6.4.3.2 (x64) opens all rows, and are USERS of MS Excel spreadsheets utilizing more columns beyond what is provided in LibreOffice Calc? LibreOffice appears to have 338 columns.
Likely not related (unless there are really more than 1024 columns used), see my answer.
I am using LibreOffice Calc version 6.3.4.2, my workbook (xlsx) has three sheets. (Sheet 1: 6 columns , 10000 rows.) (Sheet 2: 6 columns, 202 rows) (Sheet 3: 11 columns , 212 rows) -----> This problem still exists.
What are the actual experiences with sheets of more than 1024 cells in software allowing for that?
What should be expected if the maximum number one day will be 2048?
Someone will want 2050 columns, I suppose.
Did everybody consider how to address the 10000th column?
Well, let’s make “square” sheets with (as it currently is) 2^20 (=1048576) rows and the same number of columns. Of course, everybody here knows that the (still existing!) last column will be addressed by BGQCV. And 100 columns left of it?
Considering higher numbers of columns should include a new syntax for true absolute and relative addressing based on ordinary numbers. That is, in fact, the way references in tokenized formulas are represented.
The RC addressing anyway was much more logical and only suffered from its unhandiness in the relative case. Let’s introduce a more handy way then instead of trying to digest all that letter salad forever.
tdf#116274 and tdf#116939 will be fixed in 6.0.4 (and btw it’s always good to state the version number you use).
I agree to be clear we need to provide the version. I’m using latest 6.0.3 version. I will wait for the latest release 6.0.4. Is there some tentative time for the new release?
Released today.
I just installed 6.0.4.2 (x64) on a Windows 10 machine. Yet this problem persists. Any update? Thanks in advance.
Your document probably has applied custom widths to columns >1024, see tdf#116939#c22. It’s not a real problem, just a warning, albeit confusing, hence that check will be disabled for 6.0.5.
Same error. Version 6.0.5.2.
The file in question has 22 worksheets. There are references to other sheet. But they are at most N columns (14 columns).
So the error actually indicates something else is causing it.
Another xlsx has 17 worksheets. There are at most M columns (13). Got the same error.
Both file open correctly, though.
Upgrade to 6.1.0.3 . Both xlsx are seeing the same errors but still open fine.
Upgraded to 6.1.2 and still getting this warning on multiple xlsx’s, eventhough there’s not where near the 1024 column limit. Will this ever be fixed?
Where’s your document and how can you be sure that Excel doesn’t write something that tells that a column > 1024 is used? If it’s about one of the documents mentioned in tdf#116274 then see https://bugs.documentfoundation.org/show_bug.cgi?id=116274#c46 for why the warning is correct.
1 Like
I am using LibreOffice Calc version 6.3.4.2, my workbook (xlsx) has three sheets. (Sheet 1: 6 columns , 10000 rows.) (Sheet 2: 6 columns, 202 rows) (Sheet 3: 11 columns , 212 rows) -----> This problem still exists.
FYI - This appears to still be an issue in version 7.3.4.2 when opening both .xls, .xlsx, and .ods formats created in earlier versions. Using sample files with only one sheet and with only meaningful data in the first approx. 50 rows and approx. 15 columns, the error still shows up. I could not find any conditional formatting or other non-default formatting in other non-data cells, so I’m not sure where else I could look to try to help troubleshoot.
I hope this is helpful.
I have Calc 6.0.6.2 and still have the same problem:
Warning loading document
wookbook.xlsx: The data could not be
loaded completely because the maximum
number of columns per sheet was
exceeded.
Any update?
See my answer and comment by @erAck - so if you actually happen to have more than 1024 columns, it’s expected.
I am using LibreOffice Calc version 6.3.4.2, my workbook (xlsx) has three sheets.
(Sheet 1: 6 columns , 10000 rows.) (Sheet 2: 6 columns, 202 rows) (Sheet 3: 11 columns , 212 rows)
-----> This problem still exists.