https://bugs.documentfoundation.org/show_bug.cgi?id=115493
Bug ID: 115493
Summary: matrix formula wrong calculation from names, also
wrong saving of names
Product: LibreOffice
Version: 6.0.0.3 release
Hardware: x86 (IA32)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
open attached spreadsheet and use steps there:
fill cells with constants
name start is defined as A6
name end is defined as A10
name count is defined as ROW(end)-ROW(start)-1
name aaa is defined as OFFSET(start,1,0):OFFSET(start,count,0)
name bbb is defined as OFFSET(start,1,1):OFFSET(start,count,1)
cell B1 is defined as matrix formula =SUM(IF(EXACT(aaa,A$1),bbb,0))
-------> wrong also B2 is used to create matrix formula
-------> wrong result in B1: is 6, should be 4
-------> wrong result in B2: is 6, should be 2
-------> wrong saving of file - names are damaged
FILESAVE, CALCULATION
Steps to Reproduce:
1. open attached spreadsheet
2. fill cells with constants
3. name start is defined as A6
4. name end is defined as A10
5. name count is defined as ROW(end)-ROW(start)-1
6. name aaa is defined as OFFSET(start,1,0):OFFSET(start,count,0)
7. name bbb is defined as OFFSET(start,1,1):OFFSET(start,count,1)
8. cell B1 is defined as matrix formula =SUM(IF(EXACT(aaa,A$1),bbb,0))
Actual Results:
B2 is used to create matrix formula
result in B1: is 6
result in B2: is 6
names are damaged when saving and reopening file
Expected Results:
only B1 is used to create matrix formula
result in B1 should be 4
result in B2 should be 2
names are preserved when saving and reopening file
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
