Created attachment 164462 [details] Picture with and without JumboSheets activation A big XLSX file looks near identical in Excel an LibreOffice. It just comes up with the warning that the maximum number of columns was exceeded. If I activate the support for this JumboSheets, this warning message disappears - but graphics looks ugly. Lines are moved, buttons disappeared. This makes the JumboSheets support useless. Tested on different PC's (different hardware), Linux and Windows. Always the same result.
It's disabled and experimental for a reason.. It's surely not to functional. The release notes shouldn't have mentioned it at all, IMHO. However the pressure releasing something is pretty high. Anyhow, is it possible to share an example file, illustrating the problem. So people (developers) can reproduce (and eventually) fix it?
Created attachment 164496 [details] Example file I removed a lot from the example, so it's not longer a JumboSheet. But you can still see the format difference if you activate the JumboSheet support.
To me, it looks like a screen-refreshing problem. 1. I first load the document with JumboSheets the result: looked messy as reported by the reporter 2. I scrolled down on the sheet, and scrolled up on the sheet, and the yellow area with "Lieferspezifikation TL 12.0" and "Anwendungsgebiet: Bitumen" looks larger. 3. I can trigger partial-refresh if I press f2 on the cell and then I press enter soon. 4. the refresh is just partial, and would still look badly. 5. note: if I export the sheet to pdf, unrefreshed, messy page is produced.
Created attachment 169690 [details] smaller example doc seems my previous guess on comment 3 was wrong. At least, with the smaller testdoc I attached exposes at least one of the original problems. Steps to reproduce: A-1. Launch Calc A-2. [Tools]-[Options] A-3. [LibreOffice]-[Defaults] A-4. Make sure that [Enable very large spreadheets] is unchecked. it would be better if you restart LibreOffice, but this MAY not be necessary A-5. Open the attached file in Calc A-6. you will be able to find a diagonal line. A-7. if Navigator window is shown, follow [View]-[Navigator] A-8. you will find "Line 4" under [Drawing objects] in the navigator. A-9. check [Enable very large spreadheets] and restart LibreOffice B-1. Open the file again in Calc B-2. No drawing objects displayed in the navigator.
I didn't removed the superfluous styles in the original file, as I wasn't sure on how it's used, but the file might have been smaller.
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: e0843b1fe6e39d3e5f14c8f13476008f17c8ed2e CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: en-US Calc: CL -- typo: didn't removed -> didn't remove
Created attachment 169691 [details] smaller example doc
with my own local build, if I load the document I attached, with the jumbosheet option turned on, the following messages was left to the log file ---- info:sax.fastparser:43968:35240:sax/source/fastparser/fastparser.cxx:1303: startElement line 2 column 1025 xdr:clientData warn:legacy.osl:43968:35240:sc/source/filter/oox/worksheethelper.cxx:530: WorksheetGlobals::getDrawPageSize - called too early, size invalid --- while with the option turned off, the message was --- info:sax.fastparser:40436:39884:sax/source/fastparser/fastparser.cxx:1303: startElement line 2 column 1025 xdr:clientData info:oox.drawingml:40436:39884:oox/source/drawingml/shape.cxx:275: Shape::addShape: id='2' info:oox.drawingml:40436:39884:oox/source/drawingml/shape.cxx:667: Shape::createAndInsert: id='2' service='com.sun.star.drawing.LineShape' ---- please note that the line number in the above log of the source code may different than the one from official nightlies, as I added some extra SAL_INFOs for my own personal purpose.
the line number in the above log of the source code ->the line number of the source code in the above log
This seems to be a problem with awt::Size etc. being 32bit and thus not being large enough to handle page size with 16m rows.
https://opengrok.libreoffice.org/xref/core/sc/source/core/data/documen3.cxx?r=1e990a5a&fi=GetMMRect#1995
Dear GEli, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
JumboSheets are working well with 24.2