Bug 44909 - EDITING: #Name and Err:520 calculation errors
Summary: EDITING: #Name and Err:520 calculation errors
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.5 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-18 11:32 UTC by Spiral
Modified: 2013-11-27 16:02 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
An excel spreadsheet which produces the Err:520 error (436.50 KB, application/vnd.ms-excel)
2012-01-18 11:32 UTC, Spiral 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Spiral 2012-01-18 11:32:18 UTC 
Created attachment 55748 [details]
An excel spreadsheet which produces the Err:520 error

Problem description: 

Steps to reproduce:
1. down load a template from http://www.vertex42.com/Calculators/financial-calculators.html

2. Open each the xls and the ods version to get the errors.

Current behavior:

There seems to be an error in formula calculation in the native spreadsheet format and the xls format.  The first versions of Libreoffice did not produce these errors, and the current versions of OpenOffice do not produce these errors either.  

The 3.5 beta seems to have fixed the native format #Name errors, but the xls sheets still produce the Err:520 error.

Expected behavior:

Open spreadsheet and formula calculates without error.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 5.1; rv:10.0) Gecko/20100101 Firefox/10.0
Comment 1 Markus Mohrhard 2012-01-18 22:49:28 UTC 
All these errors are fixed in LibO 3.5 RC1. They will not be backported to 3.4 because they required major rework in the formula handling.