[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 #7 from b. <newbie-02 at gmx.de> ---
Created attachment 161091
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161091&action=edit
list of calc file formats and their capabilities reg. autofilter to 'survive'
save-close-reload cycles

after some more investigation: 

quite sure that the initial fail is the reload of a previously correct saved
*.ods file, on which: 

1. wrongly a table-orientation "column" is applied, 
2. wrong numbers are calculated for the 'filterfields[2|3].field' values, 
3. wrong values and a wrong 'xml orientation tags' "column" are saved in
subsequent saves / copies of the file, 

thus corrected subject / title for not to loose interested people who do one
check and say 'ok', the first save is! ok, mess starts after reload, 

checked some other file formats, see attachement, 

as after three weeks no interest and no help i have to try other roads (a
solution in 8 years is of no help) ... thus 'user forum niveau': 

there are four formats working correct for this task, see attached file, i'll
try to use (oo)xlsx, if no other issues occur that's a viable workaround, 

i'm unsure what to do with this bug, from 'viable workaround' i tend to set
importance to minor, 

weighing the embarrassment that calc has been storing crap for many years in
its very own format and only works cleanly with the format of the competition
... and yet wants to 'look good' compared to the competition ... critical is
not high enough ... 

as this bug affects a fundamental functionality of the filtering system and has
the potential to screw up plenty other issues and can cause other problems as
well as block the fixing of other bugs I think critical is right ... 

an experienced QA member should decide ...

-- 
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/20200521/241f6cf3/attachment.htm>