Issue 17918 - Problems exporting to MS Excel.
Summary: Problems exporting to MS Excel.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-06 10:33 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Files to reproduce the bug. (8.88 KB, application/octet-stream)
2003-08-06 10:35 UTC, Unknown 		no flags Details
proposed patch to fix this (969 bytes, patch)
2003-08-07 14:46 UTC, john.marmion 		no flags Details | Diff
Simply use the default case to assign the value of the Formula (560 bytes, patch)
2003-08-08 10:42 UTC, john.marmion 		no flags Details | Diff
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 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