https://bugs.documentfoundation.org/show_bug.cgi?id=94149
Bug ID: 94149
Summary: formula in spreadsheet returns inconsistent results in
same row. A formula using if ... then works in early
parts of spreadsheet and then fails.
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In a full width spreadsheet with about 50 rows, in sheet number 9, the formula
"if(count(range-ONE ROW)> 20, "", if(sum(range-ONE ROW)>0,sum(range-ONE
ROW),""))". The array is C4:AMC47.
The range is from the column of interest to the end of the row: c3:amc3, then
d3:amc3, for example.
Results within a row are good for a while and then the sum(range) is displayed.
In the 41th row of calculations (Row 44), the if(sum(range)> 20,"" ... fails in
column C from the beginning.
The next instance of failure is in column BH, rows 29 and 46. The test
continues to work in the other rows until column BX when row 22 fails. The
next failure is in column CC row 37, then column CF row 39. And column CO row
31, etc.
In tabular form:
Column Row
C 44
BH 29, 46
CC 37
CF 39
CO 31
CP 36
CQ 4, 47
CR 15
CV 27
CW 41
CX 12, 16, 23, 25
CY 17, 19, 40
CZ 10
DB 38
DC 8, 32
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
