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

(all said here please to be re-checked, i'm on the limit of my knowledge and
analytical talents)

on the first save of a file the defined data-ranges are saved !!! without !!!
the following tag: 

table:orientation="column"

on subsequent saves after re-loading the file the data-ranges get this tag in
their xml definition, 

despite one may think this tag is ok or 'not required' as it's the default? it
does! affect the evaluation of filtering conditions on load, 

on load of a file with a defined filter condition two (or more) properties must
be implemented in the representation: 

1. - the column being filtered, and from that marking the right buttons
'blue-triangle-dotted' to access the filtering from the UI, imho internally
working with absolute values for the column number, 

2. - the value used for .field in the sc...filterdescriptor...filterfields
struct, imho values relative to the defined database area, 

problem: having the tag - table:orientation="column" - set in the file toggles
which of 1.) or 2.) is correctly applied, the other will be 'glitched', 

thus: 

- while initial saving and subsequent saving produces different format - with
effect! on import of filtering conditions - it's impossible to construct a
stable and consistent solution, 

-- either first and subsequent saves should produce the same output, or 

-- the evaluation should be in a manner that the parameter 'column' is
optional, 

once that is solved and if the deviating evaluation of filtered column and
.field stay alive one can dig for the reason ... 

code-tag: sc/source/filter/xml/xmlfilti.cxx and everything 'around', 

i'd be very! thankful if someone with knowledge how it should be could step in
and give some help ...

-- 
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/20200506/0994f332/attachment-0001.htm>