https://bugs.documentfoundation.org/show_bug.cgi?id=167442
Bug ID: 167442
Summary: [Documentation] First row as header when sorting
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 201720
--> https://bugs.documentfoundation.org/attachment.cgi?id=201720&action=edit
Sample file to test.
Under sorting it is written:
"However, it also recognizes the first row as a header row and excludes it from
the sort."
Source:
Calc Guide 25.2, Chapter 15 - Calc as a Database
https://books.libreoffice.org/en/CG252/CG25215-CalcAsADatabase.html#toc24
To be true, there must be at least one column header that is text and the
column content must be numbers.
If the content of all cells are just text, or the content mix text and numbers,
the first row is sorted too.
Header recognition…
…works with:
a b
1 2
2 1
…works with:
a b
aaa 2
bbb 1
…don't works with:
1 2
a b
b a
…don't works with:
a 0
aaa 2
bbb 1
…don't works with:
a b
aaa bb
bbb aa
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
