https://bugs.documentfoundation.org/show_bug.cgi?id=161948
Bug ID: 161948
Summary: natural sort of data range is not written to file
although a suitable attribute exists
Product: LibreOffice
Version: unspecified
Hardware: All
URL: https://docs.oasis-open.org/office/OpenDocument/v1.3/o
s/part3-schema/OpenDocument-v1.3-os-part3-schema.html#
attribute-table_embedded-number-behavior
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 195166
--> https://bugs.documentfoundation.org/attachment.cgi?id=195166&action=edit
Material for natural sort test
Open attached file.
Data > Select Range > choose 'naturalSort'
Data > Sort... > Tab Options, check 'Enable natural sort' > OK
Data > Select Range > choose 'alphanumericSort'
Data > Sort... > Tab Options, make sure 'Enable natural sort' is not checked >
OK
Save file.
Reopen saved file.
Data > Select Range > choose 'naturalSort'
Data > Sort... > Tab Options.
Error: 'Enable natural sort' is not checked.
Open saved file in editor and inspect element <table:database-ranges> in
content.xml. You will find two <table:database-range> elements, one for
database range 'naturalSort' the other for database range 'alphanumericalSort'.
Compare their child elements <table:sort>. Besides the cell addresses they are
identical.
The element for database range 'naturalSort' should have an attribute
table:embedded-number-behavior (19.628, part 3, ODF 1.3) with value 'double' or
'integer'. This attribute is needed to specify, that natural sort has to be
used. If you add it manually, it is not read. Support for this attribute is
missing and thus the setting 'Enable natural sort' is lost on save/load.
--
You are receiving this mail because:
You are the assignee for the bug.
