https://bugs.documentfoundation.org/show_bug.cgi?id=151046
Bug ID: 151046
Summary: Formulas fail for named ranges with less than 8
characters
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After upgrading from LO7.3.6 to LO7.4.1 two spreadsheets I use on a regular
basis failed to calculate correctly. The files consist of several sheet and an
overview page that uses formulas with INDIRECT() in combination with several
named ranges.
Several hours of debugging later, it boils down to named ranges having a
minimum name length of 8 characters now. So named ranges already defined, using
a shorter name, are failing more or less silently. The formula just results in
"#VALUE!".
Renaming the ranges and using longer names resolved the issue.
Steps to Reproduce:
1. Create a calc file with LO7.3 (or earlier).
2. Define a named range (e.g. "MINI").
3. Use the named range for some calculations and confirm it works.
4. Open the file with LO7.4. Results break.
Actual Results:
The formulas failed and faulty results where calculated.
Expected Results:
If a minimum name length for named ranges is required, Calc should warn users
when opening files using named ranges with shorter names.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.1.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-AT (de_AT.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
