Issue 120802 - Failure to calculate formula in spreadsheet
Summary: Failure to calculate formula in spreadsheet
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-03 15:27 UTC by Nicolas Bellord
Modified: 2017-05-20 09:55 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Nicolas Bellord 2012-09-03 15:27:18 UTC 
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.
Comment 1 Nicolas Bellord 2012-09-04 17:51:58 UTC 
Sorry I see that this was not a bug after all.  An invisible non-numeric character in E924 caused this behaviour.
Comment 2 Rob Weir 2013-01-08 20:17:20 UTC 
Not a bug, per original reporter.