Issue 17918

Summary: Problems exporting to MS Excel.
Product: Calc Reporter: Unknown <non-migrated>
Component: uiAssignee: oc
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Files to reproduce the bug.
none
proposed patch to fix this
none
Simply use the default case to assign the value of the Formula none

Description Unknown 2003-08-06 10:33:47 UTC 
I've saved an SXC file to an XLS file. When I try to open it with the "Microsoft
Excel Viewer Version 8.0" (I've not the full Excel) it loops indefinitely (the
viewer uses 100% CPU and don't solve some cells). I don't know if this bug works
also with the full MS-Excel. The attachment contains the source SXC and the
converted XLS files.
Comment 1 Unknown 2003-08-06 10:35:30 UTC 
Created attachment 8266 [details]
Files to reproduce the bug.
Comment 2 john.marmion 2003-08-06 11:38:28 UTC 
Yes, It appears that this version of Excel Viewer uses 99% of CPU load
time regardless of the Document that it opens. I have tried it with
simple Excel created docs and found the exact same behaviour. So this
appears unrelated to the Calc export. But I do notice that the Column
'Ore' is not calculated and set to zero. I will investigate that.
Comment 3 john.marmion 2003-08-06 11:40:03 UTC 
accepting
Comment 4 john.marmion 2003-08-07 10:33:21 UTC 
Calc is only writing the results of Formula if they are formatted as
numbers, text or logical categories. All other categories are set to
zero. This doc is using categories of Time. Thus the remaining
categories: time, date, currency, percent etc will set be set to zero.
Calc and Excel will calculate the formula result at run-time but Excel
Viewer will simply display the stored result. I will fix this.
Comment 5 john.marmion 2003-08-07 14:46:01 UTC 
Created attachment 8304 [details]
proposed patch to fix this
Comment 6 john.marmion 2003-08-08 10:42:45 UTC 
Created attachment 8331 [details]
Simply use the default case to assign the value of the Formula
Comment 7 john.marmion 2003-08-08 11:12:49 UTC 
checked in latest patch into CWS calc16 today
Comment 8 john.marmion 2003-08-13 12:09:41 UTC 
set the correct target
Comment 9 john.marmion 2003-08-13 12:18:31 UTC 
re-open to assign to QA
Comment 10 john.marmion 2003-08-13 12:19:02 UTC 
Assign to QA
Comment 11 john.marmion 2003-08-13 12:19:27 UTC 
re-set status to fixed
Comment 12 oc 2003-09-11 14:33:37 UTC 
verified in internal build calc16
Comment 13 frank 2004-10-05 13:53:11 UTC 
Found fixed on Master src680m54 using Linux and Windows build