[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 #6 from b. <newbie-02 at gmx.de> ---
from 

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1418550_253892949

i read: 

------------ 
19.686.3<table:database-range>

The table:orientation attribute specifies whether data fields are organized in
row or columns.

The defined values for the table:orientation attribute are:

    ●column: organization is by columns 

    ●row: organization is by rows 

For a <table:database-range> 9.4.15 element the default value for this
attribute is row.

The table:orientation attribute is usable with the following element:
<table:database-range> 9.4.15.

The values of the table:orientation attribute are column or row.
------------

apart from the fact that it is not self-explanatory (what is the meaning of
'organization is by ...'? the different fields (attributes) of one record are
next to each other in a row - 'by row'? or corresponding fields of the
different records are in columns one below each other - 'by column', or vice
versa (oriental / asian notation?) records are from top to bottom or bottom to
top, per record 'by column', or their comparison and key fields are next to
each other accordingly - 'by row', 

i'll just guess that 'by row' means records row by row, accordingly filter
criteria by column!, 

in no case should for one file with kept data and structure 'by column' - being
defined as an exception to the default value - should be accounted sometimes
and sometimes not, because that changes the evaluation in a nonsensical way -
by chance - 

thus it's neccessary to find which module in which circumstances writes this to
the files, 

but the 'bug before' is that on read in of a correctly written? file from
initial save the .field value is assigned or calculated wrongly, 

if any of the pros would like to point me to a module or code sequence ... open
file, read in values, create data structure, create data range structure,
create filter structure, assign filter values, acess by ui (buttons), make
available for basic, access by macro, from where to take values for save, which
module calculates .field values and 'table orientation' for save ... i would be
very grateful and continue with efforts to find the root cause ...

-- 
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/20200514/d327ee47/attachment.htm>