https://bugs.documentfoundation.org/show_bug.cgi?id=165402
Bug ID: 165402
Summary: Formula MATCH in Calc works ok, but is crappy after
the sheet copy into a new document
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a table making alphabetic list of an array of songs.
It works ok in original document, but is crappy after a copy of the whole sheet
into a new document.
Very strange bug.
Steps to Reproduce:
See the file attattached: Atleast the pictures.
http://klimes.mysteria.cz/libreoffice_bug/libreoffice_automatic_list_bug.zip
http://klimes.mysteria.cz/libreoffice_bug/automatic_list_crappy_copy.ods
http://klimes.mysteria.cz/libreoffice_bug/automatic_list_crappy_copy.png
http://klimes.mysteria.cz/libreoffice_bug/automatic_list_ok.ods
http://klimes.mysteria.cz/libreoffice_bug/automatic_list_ok.png
I made list of songs
order them
=COUNTIF($A$11:$A$18;"<="&A11)
computed offsets
=MATCH(".*"&C11&".*";$B$11:$B$18;0)
and made offsets
=OFFSET($A$10;D11;0)
I had an automatic alphabetical list of song.
I tried to copy whole sheet into a new document and it does not works.
Actual Results:
I do not have an automatic alphabetic list of songs and I am saddy.
Expected Results:
I need an automatic alphabetical list of an array of songs and i will be happy
Reproducible: Always
User Profile Reset: No
Additional Info:
Produce N/A indstead of songs
my email: [email protected]
Version: 7.4.7.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: x11
Locale: cs-CZ (en_US.UTF-8); UI: en-US
Debian package version: 4:7.4.7-1+deb12u6
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
