https://bugs.documentfoundation.org/show_bug.cgi?id=146722
Bug ID: 146722
Summary: Calc using labels shows errors or wrong results
Product: LibreOffice
Version: 7.2.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In Calc, Options/Calc>Calculate set to automatically find labels
Open LabelBad.ods. Cell B3 (='aa'+2) shows error.
insert row above ‘aa’; error remains, even after editing.
Enter string, eg ‘**’ in cell A1; error remains; edit formula: error vanishes!
Strange. Apparently, there must be something above ‘aa’ to make it useable.
Open LabelBaf.ods. Cell B3 (='Rz'+1) shows wrong value, 1 instead of 3.
(Who can trust Calc if it gives wrong values without warning?)
Now, enter label ‘cc’ in cell A3. Cell B3 shows error!
Enter ‘**’ in cell A1; error remains; edit formula: error vanishes!
Steps to Reproduce:
1.Open LabelBad.ods.
2.Open LabelBaf.ods.
3.
Actual Results:
1. Cell B3 shows error.
2. Cell B3 shows wrong value
Expected Results:
correct values!
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.2.4.1 (x64) / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
