[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 #3 from b. <newbie-02 at gmx.de> ---
after some more investigation: 

the initial save (new file - define dataarea - apply autofilter - filter -
save) works correct, the values for 'table:field-number' in the .ods -
content.xml file are relative to the data range as expected, 

on load of the saved file the filtering conditons accessible from the header
row (dotted triangle buttons) are applied correctly, but the structures
'filterdescriptor', 'getfilterfields' accessible from macros deal with wrong
numbers, mostly off from what it should be by +col-offset (not subtracted),
-row-offset (wrongly subtracted), but not everytime, imho somebody stopped
values too far off by 'saturating_add', just be aware to get irritating
results, 

on a re-save of the file messed up on load also the values saved to the file
get messed up, 

similar happens to 'sort', 

once you had introduced an 'anonymus_dataarea' - at any time? - by applying
autofilter without first defining a dataarea / data range things work somewhat
different, making analysis even more tricky, 

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/20200505/58400b4a/attachment-0001.htm>