Issue 41783 - Scenario data lost while export/import to xls
Summary: Scenario data lost while export/import to xls
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 680m75
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-02-01 10:55 UTC by oc
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
bugdoc (25.33 KB, application/vnd.sun.xml.calc)
2005-02-01 10:58 UTC, oc 		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 oc 2005-02-01 10:55:56 UTC 
Load attached bugdoc, save to xls and reload => the scenario in H8 has lost its data
Comment 1 oc 2005-02-01 10:58:08 UTC 
Created attachment 22082 [details]
bugdoc
Comment 2 john.marmion 2005-02-01 15:02:35 UTC 
reassign
Comment 3 john.marmion 2005-02-01 18:34:03 UTC 
accept
Comment 4 john.marmion 2005-02-17 10:37:58 UTC 
Thanks to nn, I now understand this. The problem here is that the scenario cell
data in the sxc doc is derived from a formula. When exporting to Excel, the
scenario sheet cell data resulting values are used and so Excel will display 0.
Excel scenario data is expected to be a constant value. It does not look like we
can do a lot about this in the short term. The workaround would be to use
constant cell values  so that scenario data will be exported correctly between
Calc and Excel.
Comment 5 daniel.rentz 2007-07-12 12:30:51 UTC 
taking this