Description: Opening CALC by macro using "loadComponentFromURL" and using mode "hidden" unfixes a fixed row. Steps to Reproduce: Test A (not "hidden" mode) 1. Open CALC. 2. Fix first row of all 3 sheets, if not fixed. 3. Set: aCALCpropv(0).Value = FALSE 4. Save/Close CALC. 5. Start macro TestFixedRow. 6. Open CALC. 7. First row of all 3 sheets is still fixed. Test B ("hidden" mode) 1. Open CALC. 2. Fix first row of all 3 sheets, if not fixed. 3. Set: aCALCpropv(0).Value = TRUE 4. Save/Close CALC. 5. Start macro TestFixedRow. 6. Open CALC. 7. First row of all 3 sheets is not fixed anymore. Actual Results: 1. When opening CALC using mode "not hidden" fixed rows are still fixed. 2. When opening CALC using mode "hidden" all fixed rows are unfixed. Expected Results: When opening CALC using mode "hidden" all fixed rows should not be unfixed. Reproducible: Always User Profile Reset: No Additional Info: LO 6.4.7.2 + LO 7.0.4.2
Created attachment 168818 [details] CALC.ods
Created attachment 168819 [details] TestFixedRow.bas
Created attachment 169157 [details] TestFixedRow.bas
After some helpful discussion (users@de.libreoffice.org) some more detailed description of the bug: Test 1 - macro NOT "hidden mode" 1.1 Check attached "CALC.ods": First row should be fixed. 1.2 Unzip "CALC.ods". 1.3 "settings.xml" should contain entry: config:config-item-map-indexed config:name="Views"> <config:config-item-map-entry> : <config:config-item config:name="VerticalSplitMode" config:type="short">2</config:config-item> : </config:config-item-map-indexed> 1.4 Zip unzipped "CALC.ods". 1.5 Run attached macro "TestFixedRows.bas" NOT using "hidden mode" (aCALCpropv(0).Value = False). 1.6 Result: Fixed row and above mentioned entry are STILL EXISTING. Test 2 - macro "hidden mode" 2.1 Check attached "CALC.ods": First row should be fixed. 2.2 Run attached macro "TestFixedRows.bas" using "hidden mode" (aCALCpropv(0).Value = True). 2.3 Result. Fixed row and above mentioned entry are NOT EXISTING ANYMORE. Test 3 - macro "hidden mode" and "oCALC.Store()" commented 3.1 Check attached "CALC.ods": First row should be fixed. 3.2 Comment macro code line "oCALC.Store()". 3.3 Run attached macro "TestFixedRows.bas" using "hidden mode" (aCALCpropv(0).Value = True). 3.4 Result: Fixed row and above mentioned entry are STILL EXISTING. Summary It seems to be, that "oCALC.Store()" deletes above mentioned entry (unfixes fixed line) when running macro in "hidden mode".
Created attachment 169210 [details] CALC.ods
Created attachment 169211 [details] TestFixedRow.bas
I can confirm this behaviour. having a deeper look to the object with xray-tool: open the document per macro in normal mode (visible): - doc-object.currentController -> show the correct properties SplitRow/SpitColumn. - using the methode store() noting changed - open the Document again -> split is corret and visible. open the document per macro in invisible mode : - doc-object.currentController -> show the correct properties SplitRow/SpitColumn. - using the methode store() - inspecting again doc-object.currentController -> show the correct properties SplitRow/SpitColumn. Nothing has changed. - closing Document. - open the Document again -> no split any more. - inspecting again doc-object.currentController -> properties SplitRow/SpitColumn is 0 (zero) Next Test: Open a calc-Document via "loadComponentFromURL" - visible mode: setting per macro: -thisComponent.getCurrentController.freezeAtPosition(2,3) -> Rows and colums are fixed, properties are stored (SplitRow/SpitColumn). -storing and closing document -> still fixed. Open a calc-Document via "loadComponentFromURL" - invisible mode: setting per macro: -thisComponent.getCurrentController.freezeAtPosition(2,3) -> xray does not show any changes, still properties of SplitRow/SpitColumn remain to zero (0). Storing the document -> no split is stored. Version: 7.0.2.2 (x64) Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL Rows and colums are fixed, properties are stored (SplitRow/SpitColumn). -storing and closing document -> still fixed.
Dear Hans-Werner, 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
RESOLVED Version: 7.5.0.2 (X86_64) / LibreOffice Community Build ID: c0dd1bc3f1a385d110b88e26ece634da94921f58 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL threaded