<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - "com.sun.star.sheet.GlobalSheetSettings" properties and "org.openoffice.Office.Calc/Input/" entries are not synchronized"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132145">132145</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>"com.sun.star.sheet.GlobalSheetSettings" properties and "org.openoffice.Office.Calc/Input/" entries are not synchronized
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mikekaganski@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Consider this code:
<span class="quote">> 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</span >
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]
<a href="https://help.libreoffice.org/6.4/en-US/text/shared/optionen/01060300.html#hd_id3148451">https://help.libreoffice.org/6.4/en-US/text/shared/optionen/01060300.html#hd_id3148451</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>