Issue 13948 - Errors loading and saving Excel 97 file
Summary: Errors loading and saving Excel 97 file
Status: CLOSED DUPLICATE of issue 12188
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-30 06:19 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
test case (51.00 KB, application/octet-stream)
2003-04-30 06:24 UTC, Unknown
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-04-30 06:19:34 UTC
The attached file is a simple form in Excel 97 format. When loaded into Calc the
following errors occur:

1. Fit to # of pages is not set. % reduction (which is correct) is active
instead. File cannot be printed correctly without this setting.

2. The autoshape box at the top loses the text alignment. It goes from centered
to left.

3. The font size in the autoshape box goes from 14 to 13.9

When the above file is saved as Excel 97 from Calc and reloaded, the following
further errors appear:

1. The font size in the autoshape box goes from 13.9 to 9.9. This occurs even if
the font size if set to 14 (which is what it should be) prior to saving.

2. The autoshape box at the top loses the text alignment. It goes to left even
if corrected back to center prior to saving.

3. The columns shrink by ~18% or so completely trashing the formatting.

If the column widths are corrected in Calc and the file resaved as Excel 97, the
column widths do not shrink. The text in the autoshape box, however, will always
 revert to left justified, arial 9.9pt, even if the font is changed to something
other than arial.
Comment 1 Unknown 2003-04-30 06:24:21 UTC
Created attachment 5968 [details]
test case
Comment 2 daniel.rentz 2003-05-07 07:01:42 UTC
Tested in OOo 1.1 Beta 2 (srx644m13):

Import
1) Fixed with issue 3693.
2) Known. Double to issue 12188.
3) Also issue 12188.

Export
1) Confirmed (formatting export not implemented at all).
2) same as 1)
3) Fixed in Beta 2 (no issue ID).

-> This issue remains for export of text box formatting.
Comment 3 daniel.rentz 2003-05-07 07:02:04 UTC
changed owner
Comment 4 daniel.rentz 2003-05-07 07:02:15 UTC
started
Comment 5 daniel.rentz 2003-09-16 10:09:18 UTC
fixed with issue 12188

*** This issue has been marked as a duplicate of 12188 ***
Comment 6 daniel.rentz 2003-09-16 10:09:50 UTC
double->closed