[Libreoffice-bugs] [Bug 99956] In formulas with circular references are not always showed the Error 522 with all calc functions. (Deactivated Iterations option)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #16 from b. <newbie-02 at gmx.de> ---
i'm lacking an instrument to inspect *.xls files, 

saving the file as *.ods unveils one thing, 

additional to the definitions of the named ranges: 

<table:named-range table:name="_Issues" table:base-cell-address="$Login.$A$1"
table:cell-range-address="$Login.$B$35"/>
<table:named-range table:name="_Items" table:base-cell-address="$Login.$A$1"
table:cell-range-address="$Login.$B$24:.$B$33"/>
<table:named-range table:name="_Non_Issues"
table:base-cell-address="$Login.$A$1" table:cell-range-address="$Login.$B$36"/>
<table:named-range table:name="_Rows" table:base-cell-address="$Login.$A$1"
table:cell-range-address="$Login.$B$37"/>

there are additional 'definitions'? style assignments? for '_Items' and
'_Rows': 

<text:p text:style-name="P1">
   <text:span text:style-name="T1">Named Range _Items =
$Login.$B$24:$B33</text:span>
   <text:span text:style-name="T1">
      <text:tab/>
   </text:span>
</text:p>

<text:p text:style-name="P1">
   <text:span text:style-name="T1">Named Range _Rows = $Login.$B37
</text:span></text:p>

in the file, observe that they are defined without the second $-absolute-marker
... 

i - assume - there's something with theese definitions affecting the correct
interpretation of the named references as soon as you change their range
address to the same ... 

maybe someone with more knowledge about the file and data structures can shed
some light?

-- 
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/20200522/48d9dc05/attachment.htm>