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