https://bugs.documentfoundation.org/show_bug.cgi?id=164870
Bug ID: 164870
Summary: Calculation with relative reference in named range
incorrect
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 109178
Created attachment 198783
--> https://bugs.documentfoundation.org/attachment.cgi?id=198783&action=edit
Example file from Calc
This is a followup to bug 164843
When the attached example file is opened in Excel then the calculation with the
named range with relative reference seems to be correct - but in Calc, the
result is 0 even after fixing the current #REF! error in the Manage Names
dialog.
1. Open attached document in Excel and Calc
-> Observe in Excel that the "testrange" named range is handled correctly in
the Name Manager dialog, and calculation in the AD column is correct
2. In Calc, there is currently a #REF! error visible in the Manage Names
dialog. Fix that manually for the "testrange" named range
-> After a bit of wait, the results in the AD column are all 0.
For comparison the AE column contains the same formula but with an absolute
range, which always gives 2000 as result in both Calc and Excel - so the only
difference is in the handling of the "testrange" named range.
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 43fc662520e5488cbeadd6eb60a24374a837dca4
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=109178
[Bug 109178] [META] Named Cell Ranges and Formula Expressions bugs and
enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
