Issue 991 - loses formatting for optimal width, freeze panes when saving to *.xls
Summary: loses formatting for optimal width, freeze panes when saving to *.xls
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 627
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
: 1153 (view as issue list)
Depends on:
Blocks:
 
Reported: 2001-06-03 18:50 UTC by issues@www
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
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 issues@www 2001-06-03 18:50:14 UTC 
1 Save *.scx file to *.xls(97/2000)
2 Loses sheet formatting for optimal width, freeze panes removed,
3 Used Print_Area as name/label in macro that Excel said was an internal name.
4 Must Rename variable before Excel would load the sheet.
5 Default Properties/Description of "D:\web\dolar\211dc.htm"
Comment 1 frank 2001-06-05 08:45:47 UTC 
Please provide a bugdoc and be a little more precise for Points 4 and 5.
Comment 2 issues@www 2001-06-06 19:11:33 UTC 
updated 06jun01
1. Open "bal-interbk.xls" in OOo627win32
2. Sheet formating / freeze panes OK.  Date column squeezed, reset with Optimal Column Width.
3. Filename on title bar as "bal-interbk"
4. Save to "bal-interbk .xls"
5. After save, Check properties, OK & name on title bar changes to "d:\web\dolar\211dc.htm"
6. Close same in OOo
7. Open in Excel
8. Name Conflict Dialog box: "Name can not be the same as a built-in name".
    Old name: Print_Area        New Name: ___________
    a. Give new name of "PrintArea"
	i. Sheet opens and sheet loses formatting, freeze panes, et al.
    b. Give new name of "Print-Area"
	i. Invalid name
    c. Give new name of "Printing_Area"
	i. Sheet opens and sheet loses formatting, freeze panes, et al.
Comment 3 frank 2001-06-18 07:40:25 UTC 
.
Comment 4 frank 2001-06-19 08:23:26 UTC 
.
Comment 5 oc 2001-06-19 08:54:55 UTC 
Optimal width is not a file attribute, so im-/export is not possible.
Freeze is imported wrong and has to be fixed. In this case additional problems 
with the repaint.
Comment 6 gunnar.timm 2001-06-19 09:12:10 UTC 
.
Comment 7 oc 2001-07-02 14:22:27 UTC 
*** Issue 1153 has been marked as a duplicate of this issue. ***
Comment 8 ooo 2001-10-19 14:53:59 UTC 
reassigned to DR
Comment 9 daniel.rentz 2001-10-23 10:28:29 UTC 
.
Comment 10 Unknown 2001-11-08 23:05:52 UTC 
changing QA contact from bugs@ to issues@
Comment 11 john.marmion 2002-12-23 16:04:02 UTC 
I have tested the "freeze panes" import/export with OOo 1.0.1 and it
works fine. I would like to close this as now fixed.
Comment 12 john.marmion 2002-12-24 09:16:53 UTC 
taking ownership of this bug
Comment 13 john.marmion 2002-12-24 09:18:38 UTC 
marking this as started. I will wait to see if the submitter wishes to
comment on this before marking this as fixed
Comment 14 richard.holt 2002-12-24 11:07:06 UTC 
Thanks for all your efforts. 
I didn't see this in OOo101 either, nor in OO643c. 
Consider it fixed.
regards,
Richard.
Comment 15 john.marmion 2003-01-02 10:19:49 UTC 
marking this as fixed
Comment 16 daniel.rentz 2003-01-30 10:45:02 UTC 
reopened to change owner
Comment 17 daniel.rentz 2003-01-30 10:45:25 UTC 
works in OOo1.0.1 and OOo643
Comment 18 daniel.rentz 2003-01-30 10:45:37 UTC 
fixed
Comment 19 john.marmion 2003-02-19 15:29:45 UTC 
marked fixed in milestone OOo 1.0.2
Comment 20 oc 2003-03-06 08:53:51 UTC 
Closed because fixed and verified