Issue 31407

Summary: On import of a large XL sheet the calculations stops in the middle of the sheet
Product: Calc Reporter: carrera2 <jean-claude.lamblin>
Component: codeAssignee: ooo
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: frank, issues
Version: OOo 1.1.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Test file to import and export back to XL to test the issue none

Description carrera2 2004-07-13 11:22:41 UTC 
At import of a XL file the calculated values stop being calculated

On saving of the imported file to a native XL file format the calculated values
are OK

I can send you a file which demonstrates the problem

I've also downloaded the StarOffice ver 7 and had the same problem

Regards

Carrera2
Comment 1 carrera2 2004-07-13 11:31:31 UTC 
Created attachment 16434 [details]
Test file to import and export back to XL to test the issue
Comment 2 frank 2004-07-13 12:16:13 UTC 
Hi Eike,

if you load the document, calculation gives wrong results starting at the second
calculated value in Cell c18.

Frank
Comment 3 ooo 2004-07-13 14:22:31 UTC 
This is because the column headers' values in row 17 (+0, +1, +2, ...) are not
numbers but text. Calc always evaluates textual values as zero. To get this
straight first format cells B17:K17, B62:K62, and B118:K118 with number format code
+0;-0
and then re-enter the values. Same with the row headers in column A, A18:A48,
A63:A104, A119:A151
Use Edit.Fill.Series to not have to manually enter all values, e.g. mark A18:A48
and open menu Edit.Fill.Series, choose linear series type, start value -200,
increment 10.

Eike


*** This issue has been marked as a duplicate of 5658 ***
Comment 4 ooo 2004-07-13 14:34:54 UTC 
Close dupe.
Comment 5 frank 2004-07-13 14:52:11 UTC 
Auuuttttsscchhhhhhh

Frank