Issue 31407 - On import of a large XL sheet the calculations stops in the middle of the sheet
Summary: On import of a large XL sheet the calculations stops in the middle of the sheet
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-13 11:22 UTC by carrera2
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
Test file to import and export back to XL to test the issue (170.50 KB, application/vnd.ms-excel)
2004-07-13 11:31 UTC, carrera2 		no flags Details
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 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