[Libreoffice-bugs] [Bug 132145] New: "com.sun.star.sheet.GlobalSheetSettings" properties and "org.openoffice.Office.Calc/Input/" entries are not synchronized

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132145
           Summary: "com.sun.star.sheet.GlobalSheetSettings" properties
                    and "org.openoffice.Office.Calc/Input/" entries are
                    not synchronized
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Consider this code:

> Sub Test
>   GlobalScope.BasicLibraries.LoadLibrary("Tools")
> 
>   oSet=createUnoService("com.sun.star.sheet.GlobalSheetSettings")
>   oSet.ExpandReferences=False
> 
>   MsgBox "oSet.ExpandReferences=" & oSet.ExpandReferences & chr(13) & "org.openoffice.Office.Calc/Input/ExpandReference=" & GetRegistryKeyContent("org.openoffice.Office.Calc/Input").getByName("ExpandReference")
> 
>   oSet.ExpandReferences=True
> 
>   MsgBox "oSet.ExpandReferences=" & oSet.ExpandReferences & chr(13) & "org.openoffice.Office.Calc/Input/ExpandReference=" & GetRegistryKeyContent("org.openoffice.Office.Calc/Input").getByName("ExpandReference")
> 
>   o = GetRegistryKeyContent("org.openoffice.Office.Calc/Input", True)
>   o.setPropertyValue("ExpandReference", False)
>   o.commitChanges()
> 
>   MsgBox "oSet.ExpandReferences=" & oSet.ExpandReferences & chr(13) & "org.openoffice.Office.Calc/Input/ExpandReference=" & GetRegistryKeyContent("org.openoffice.Office.Calc/Input").getByName("ExpandReference")
> 
>   o.setPropertyValue("ExpandReference", True)
>   o.commitChanges()
> 
>   MsgBox "oSet.ExpandReferences=" & oSet.ExpandReferences & chr(13) & "org.openoffice.Office.Calc/Input/ExpandReference=" & GetRegistryKeyContent("org.openoffice.Office.Calc/Input").getByName("ExpandReference")
> End Sub

This code shows that manipulating the same ExpandReference setting [1] via
registry and via com.sun.star.sheet.GlobalSheetSettings service is not
synchronized, as if the latter does not listen for the relevant registry
changes. The setting in com.sun.star.sheet.GlobalSheetSettings is actually used
in the following spreadsheet manipulations, and is reflected in the
Options/Calc/General; but the changes in it are not immediately reflected in
registrymodifications.xcu - until the program exits (or until the settings are
saved from the Options dialog). On the other hand, changes done using
"com.sun.star.configuration.ConfigurationUpdateAccess" (through
GetRegistryKeyContent) are written into registrymodifications.xcu immediately
on commit, but are not reflected in Options dialog, and will not be used until
soffice.bin restarts.

Although the state where there's more than one way to access the setting might
be confusing and redundant, having them also *behave* differently is confusing
even more. The two should be synchronized, and allow to be used
interchangeably: I can't see a reason to have current distinction in behaviour.

Tested with Version: 6.4.3.2 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

[1]
https://help.libreoffice.org/6.4/en-US/text/shared/optionen/01060300.html#hd_id3148451

-- 
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/20200416/062fccfb/attachment.htm>