Created attachment 109660 [details] Example of irregulatities with labeled ranges The automatic detection of ranges when a label is used works counter-intuitive. cell references refer to the attachment. -a label for numeric data works for vertical ranges [A2, A21 and A22], but not for horizontal ranges [A3], unless the data is also in vertical ranges [A23 and A24]; -a label for textual data works for horizontal ranges [A5] but not for vertical ranges [A4]. -When both horizontal and vertical ranges are possible, the choice of the ranges seems to depend on the range being numeric [a6] or textual [A5].
@Erack: Eike, you worked on this code to fix fdo#59583. Do you know how the behaviour should be?
Automatic detection of labels is a mess anyway and counter-intuitive by definition ;-) I wish we never followed MS-Excel onto the dark path there, which in the mean time has that feature deprecated by the way.. How I understood the lookup we implemented is described in ODF http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017956_715980110 I think the magic sentence here for this case is "If the resulting cell is below or above another cell containing Text a row lable is assumed, else a column label is assumed." Does that fit your observation?
Hi I reproduce & set status to New. I add two cases of "mixed" data (text & number) in the attached file Best Regards Pierre-Yves
Created attachment 109671 [details] label_range_irregularitiesV2
(In reply to Eike Rathke from comment #2) > I think the magic sentence here for this case is "If the resulting cell is > below or above another cell containing Text a row lable is assumed, else a > column label is assumed." Does that fit your observation? Yes, it does. For both attachments, actually. So, the gist is that the above magic sentence should be added to the help text of LibreOffice (preferably less cryptic). I changed the subject and the component of this report. Eike, thank you for your lightning-fast reply and link :-)
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.