[Libreoffice-bugs] [Bug 139539] New: Makro Basic - CALC - loadComponentFromURL - mode "hidden" unfixes fixed rows, mode "not hidden" doesn't

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139539

            Bug ID: 139539
           Summary: Makro Basic - CALC - loadComponentFromURL - mode
                    "hidden" unfixes fixed rows, mode "not hidden" doesn't
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: HansWernerHerold at t-online.de

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210111/94d610cd/attachment.htm>