Issue 21973 - Data validation doesn't work when saving as Excel file (XLS).
Summary: Data validation doesn't work when saving as Excel file (XLS).
Status: CLOSED DUPLICATE of issue 20138
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-31 16:33 UTC by rodro
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Original SXC with validation (7.09 KB, application/octet-stream)
2003-10-31 16:34 UTC, rodro 		no flags Details
Saved as Excel file (XLS) (6.50 KB, application/octet-stream)
2003-10-31 16:35 UTC, rodro 		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 rodro 2003-10-31 16:33:43 UTC 
I have 4 columns

DATE	date
AMOUNT	numeric
INVOICE	text
CLIENT	text

I validate the first 2.

Valid dates >= 12/31/1899

Amount <> 0

When I save as Excel file (XLS), the validation rules are lost.

Thanks for your time.
Comment 1 rodro 2003-10-31 16:34:33 UTC 
Created attachment 10849 [details]
Original SXC with validation
Comment 2 rodro 2003-10-31 16:35:12 UTC 
Created attachment 10850 [details]
Saved as Excel file (XLS)
Comment 3 frank 2003-11-03 10:54:10 UTC 
Hi Daniel,

please have a look at it.

Frank
Comment 4 daniel.rentz 2003-11-03 15:05:44 UTC 
Problem is related to issue 20138. Data validation is handled 
internally as cell formatting attribute. The Excel export filter 
forgets to export all cell formatting below the last row that contains 
any data. In your case all rows starting from row 2 are not exported.
Workaround until fix: enter a number i.e. in cell E32000. This forces 
the export filter to export the formatting of all cells down to row 
32000.

*** This issue has been marked as a duplicate of 20138 ***
Comment 5 daniel.rentz 2003-11-03 15:06:10 UTC 
double->closed
Comment 6 rodro 2003-11-05 14:51:33 UTC 
Thanks for your reply, Mr. Rentz.