Download it now!
Bug 86427 - automatic label detection needs explanation
Summary: automatic label detection needs explanation
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-18 08:47 UTC by Winfried Donkers (retired)
Modified: 2017-01-04 09:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example of irregulatities with labeled ranges (10.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-18 08:47 UTC, Winfried Donkers (retired)
Details
label_range_irregularitiesV2 (32.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-18 13:30 UTC, pierre-yves samyn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Winfried Donkers (retired) 2014-11-18 08:47:45 UTC
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].
Comment 1 Winfried Donkers (retired) 2014-11-18 08:51:02 UTC
@Erack: Eike, you worked on this code to fix fdo#59583. Do you know how the behaviour should be?
Comment 2 Eike Rathke 2014-11-18 12:48:44 UTC
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?
Comment 3 pierre-yves samyn 2014-11-18 13:29:49 UTC
Hi

I reproduce & set status to New.

I add two cases of "mixed" data (text & number) in the attached file

Best Regards
Pierre-Yves
Comment 4 pierre-yves samyn 2014-11-18 13:30:40 UTC
Created attachment 109671 [details]
label_range_irregularitiesV2
Comment 5 Winfried Donkers (retired) 2014-11-18 15:18:00 UTC
(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 :-)
Comment 6 QA Administrators 2015-12-20 16:04:58 UTC Comment hidden (obsolete)
Comment 7 Winfried Donkers (retired) 2015-12-21 08:21:17 UTC
Bug report is still valid (LO 5.0.4).
Comment 8 QA Administrators 2017-01-03 19:54:36 UTC Comment hidden (obsolete)
Comment 9 Winfried Donkers (retired) 2017-01-04 09:40:19 UTC
Lack of information in Help still occurring with LO version 5.2.4.2 (Windows7).