Issue 104057 - Document of Excel doesn't open up well in openoffice
Summary: Document of Excel doesn't open up well in openoffice
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0 RC4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks: 99999
  Show dependency tree
 
Reported: 2009-08-06 16:22 UTC by jorgefm
Modified: 2017-05-20 11:41 UTC (History)
3 users (show)

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

Attachments
Fire example (26.50 KB, text/plain)
2009-08-06 16:23 UTC, jorgefm 		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 jorgefm 2009-08-06 16:22:15 UTC 
An excel file that is generated with a metadato process doesn't do well with 
openoffice.  
if we modify something the document it already works. It is well in the two 
applications  
  
the process is simple, alone it is necessary to open it with openoffice
Comment 1 jorgefm 2009-08-06 16:23:16 UTC 
Created attachment 63989 [details]
Fire example
Comment 2 amy2008 2009-08-10 04:34:11 UTC 
Would you like giving us step-by-step descriptions?
Because when I download your attachment for this issue, OOo can open this file
well in DEV300m54 and OOo3.0
Comment 3 fusero 2009-08-26 10:27:26 UTC 
Amy2008, when the file is open with Calc it shows 11 rows in "Sociedad" sheet.
When it is open with MS Excel, the file shows much more rows and a chart.

The only step needed to reproduce the problem is to open the file.

Hope this helps.
Comment 4 amy2008 2009-08-27 02:36:31 UTC 
jorgefm,
Sorry for my mistaking.
If I open the attachment file 'fire example.xls' with OOo3.1.1, indeed there 
are only 11 rows in the file.
But if open the attachment with MS office 2003, there are 62 rows and a chart.
Can reproduce it.

Li Meiying
Comment 5 amy2008 2009-08-27 02:57:22 UTC 
Oliver,
Would you like checking it?
If I save the attachment as 'fire example 1.xls', then open it with MS office 
2003, then an odd problem appears, contents in sheet _Hidden2 and sheet 
Sociedad exchange. IMO, maybe this is the real reason for this issue.
Comment 6 oc 2009-09-15 08:23:37 UTC 
Hi Daniel, please have a look
Comment 7 daniel.rentz 2009-09-15 09:14:24 UTC 
Oh my... I have neverever seen that in a BIFF8 Excel file. The second sheet is
stored *before* the first sheet. Excel recognizes this with the stream indexes
stored in the SHEET records and reorders them on loading, but we always load the
sheets in order of appearence in the file. Therefore the contents of the hidden
second sheet are loaded into the first visible sheet, and vice versa.
Comment 8 daniel.rentz 2009-09-15 09:17:02 UTC 
next question: why is it not possible to make the hidden sheet visible after
loading? This may be caused by trying to make the hidden sheet "active".
Comment 9 daniel.rentz 2009-09-15 12:05:55 UTC 
playing with this doc in Calc may lead to crash -> raising prio
Comment 10 daniel.rentz 2009-09-21 17:32:04 UTC 
fixed in CWS DEV300/calc32stopper2
Comment 11 fusero 2009-09-22 15:31:59 UTC 
Hi dr, what does "fixed in CWS DEV300/calc32stopper2" mean? When will this fix
be avaialble? Next OO.org release maybe?
Comment 12 daniel.rentz 2009-09-22 15:56:49 UTC 
yes, should be next release (3.2)
Comment 13 daniel.rentz 2009-09-28 16:51:20 UTC 
back to QA
Comment 14 oc 2009-10-05 12:23:37 UTC 
verified in internal build cws_calc32stopper2