Hallo Thomas,
ich hab' mal was formuliert (s.u.). Wenn das für Dich okay ist, würde ich es so im BUG-Report einbringen. Verbesserungsvorschläge sind natürlich willkommen.
Viele Grüße
Hans-Werner :-))
Bug 139539 - Makro Basic - CALC - makro mode "hidden" - method store() unfixes fixed rows
COMMENT
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).
3.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".