[Libreoffice-bugs] [Bug 132488] filesave: fileopen: macro: xml: calc filtered ranges wrongly saved in .ods format? xml export / import buggy? affects filters in database ranges with offset to cell A1

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from b. <newbie-02 at gmx.de> ---
same happens to parameters for 'standard filter', 
- initial save: correct .field values, no 'orientation' tag, filter works, 
- re-load and then save: orientation "column", wrong .field values, 

(i don't know yet if .field values for standard filter are accessible for
users, thus can only check in the files)

see snippets from files, (had to edit tabs by "   ", between **[ and ]**:
comments
first save: 
<table:database-ranges>
   <table:database-range table:name="dataarea01"
table:target-range-address="Sheet1.B3:Sheet1.D6"
table:display-filter-buttons="true" table:on-update-keep-styles="true"
table:on-update-keep-size="false">**[comment: no 'orientation-tag' here]** 
      <table:filter>
         <table:filter-and>
            <table:filter-condition table:field-number="1"**[comment: correct
value to filter second column in range]** table:data-type="number"
table:value="2" table:operator="="/>
         </table:filter-and>
      </table:filter>
   </table:database-range>
</table:database-ranges>

save after re-load of above file: 
<table:database-ranges>
   <table:database-range table:name="dataarea01"
table:target-range-address="Sheet1.B3:Sheet1.D6"
table:display-filter-buttons="true" table:on-update-keep-styles="true"
table:on-update-keep-size="false" table:orientation="column">**[comment: now
with! 'orientation-tag']**
      <table:filter>
         <table:filter-and>
            <table:filter-condition table:field-number="0"**[comment:
miscalculated value for second column]** table:data-type="number"
table:value="2" table:operator="="/>
         </table:filter-and>
      </table:filter>
   </table:database-range>
</table:database-ranges>

reg. 

b.

-- 
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/20200509/15819e62/attachment.htm>