Issue 17440 - Printing Spreadsheets converted to MS Excel 2000 Format
Summary: Printing Spreadsheets converted to MS Excel 2000 Format
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (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:
: 16303 17726 21143 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-07-26 18:10 UTC by peterhb
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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

Attachments
Test file with just enough content to exhibit the problem (5.23 KB, application/octet-stream)
2003-07-26 18:13 UTC, peterhb 		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 peterhb 2003-07-26 18:10:36 UTC 
Any OpenOffice.org natively created spreadsheets that include the current time
in the Header, or Footer, and are subsequently saved in MS Excel 2000 format,
cannot be usefully printed in Excel due to the appearance of large (288 pt),
apparently random digits that are superimposed on all pages, obscuring the
original content. These digits appear to be time related as they seem to
correspond to the 'minutes' value at the time of saving.
Comment 1 peterhb 2003-07-26 18:13:10 UTC 
Created attachment 8041 [details]
Test file with just enough content to exhibit the problem
Comment 2 oc 2003-07-28 09:54:02 UTC 
Hi Daniel,
one4you
Comment 3 daniel.rentz 2003-07-28 10:42:44 UTC 
The header is exported as "&C&1011:00:00" which should mean center 
part (&C), font height 10 (&10), and following text "11:00:00" (if it 
is now 11:00:00 of course). Problem: Excel interprets this as font 
height 1011 and following text ":00:00". Excel itself would add a 
space in this case: "&10 11:00:00". But even more serious here: the 
time field is converted to text, correct export would be "&C&T" which 
means center part with time field.

Major problem: all text fields are converted to plain text
Minor problem: no space between font height and text starting with a 
number.
Minor problem: default font height can be omitted ( "&C&T" instead of 
"&C&10&T").

@submitter:
A quick workaround for you is to add a space character before the text 
field: " [TIME]".
Comment 4 daniel.rentz 2003-07-28 13:42:14 UTC 
First problem (text fields) fixed in OOo 1.1. Remaining problems to be
fixed in OOo 1.1.1.
Comment 5 peterhb 2003-07-29 18:31:03 UTC 
Thanks for the workaround which solves my immediate problem.

I assume that ALL fields in headers and footers will be subject to the
fix? Page Numbers, Number of Pages and Filename are all wrong on
export to Excel format, indeed the Filename disappears in my case!
Apologies that I didn't diagnose the issue to this depth innitially.

Regards

Peter HB
Comment 6 daniel.rentz 2003-07-30 09:05:57 UTC 
Yes, all fields are broken, and the fix repairs all of them.
Comment 7 daniel.rentz 2003-08-01 08:05:27 UTC 
*** Issue 17726 has been marked as a duplicate of this issue. ***
Comment 8 oc 2003-08-25 08:52:58 UTC 
*** Issue 16303 has been marked as a duplicate of this issue. ***
Comment 9 daniel.rentz 2003-08-26 12:25:34 UTC 
fixed in OOo 1.1.1
Comment 10 daniel.rentz 2003-09-29 14:10:24 UTC 
owner->QA
Comment 11 oc 2003-10-01 09:34:42 UTC 
Reset resolution
Comment 12 oc 2003-10-01 09:35:52 UTC 
Verified in internal build cws_so7...
Comment 13 daniel.rentz 2003-10-14 10:27:05 UTC 
*** Issue 21143 has been marked as a duplicate of this issue. ***
Comment 14 oc 2003-11-05 09:54:44 UTC 
OC: Reassigned to development for integration
Comment 15 daniel.rentz 2003-11-05 10:44:01 UTC 
back to QA
Comment 16 oc 2003-11-11 16:16:23 UTC 
Reset resolution to fixed
Comment 17 oc 2003-11-11 16:19:33 UTC 
Verified in internal build comboboxlink
Comment 18 oc 2004-01-30 10:34:55 UTC 
Fix will be available in the forthcoming OOo1.1.1