https://issues.apache.org/ooo/show_bug.cgi?id=120802
Priority: P3
Bug ID: 120802
Assignee: [email protected]
Summary: Failure to calculate formula in spreadsheet
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: Windows 7
Reporter: [email protected]
Hardware: PC
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: editing
Product: spreadsheet
I am using the spreadsheet to keep accounts. Items are in column E and a
running new balance is kept in column F.
So the standard formula entered in column F is to add the previous balance in
the cell immediately above to the new item in column E. e.g. in cell F5 the
formula is F4+E5.
This works fine until you get to cell F924 where the formula is F923+E924 and
it fails, displaying #VALUE!
It all worked fine under the previous release and the bug has only appeared in
3.4.1. I had already entered data on row 924 and onwards in the previous
release and only after loading the new release did things go wrong.
It seems to be a fault that happens all along row 924 onwards i.e. is not
peculiar to any particular column.
--
You are receiving this mail because:
You are the assignee for the bug.