Bug 80407 - FILESAVE: Validity check on a column for list of values is lost on saving as .xlsx
Summary: FILESAVE: Validity check on a column for list of values is lost on saving as ...
Status: RESOLVED DUPLICATE of bug 67146
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.0.alpha1
Hardware: x86 (IA32) All
: highest major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: possibleRegression
Depends on:
Blocks:
 
Reported: 2014-06-23 14:40 UTC by Riq
Modified: 2015-12-15 22:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
test ods file with vadility list in column A. (12.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-06-24 05:45 UTC, Kevin Suo 		Details
Column with two cells and validity check (4.50 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-06-24 13:47 UTC, Riq 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Riq 2014-06-23 14:40:51 UTC 
Validity check on a column for list of values is lost on saving as .xlsx
Comment 1 tommy27 2014-06-23 15:50:13 UTC 
edited summary notes.
please upload test file so we can try reproducing the issue.
Comment 2 Kevin Suo 2014-06-24 05:45:07 UTC 
I can confirm in Windows XP SP3, version 4.3.0.1.

Steps to reproduce:
1. Open my following test ods file. Observe that column A has validity list in each cells.
2. Save as xlsx and reopen. Obverve that validity is retained only in cell A1 (validity for all other cells are gone).

Set to NEW.
OS: -> ALL
Importance: Highest major. Should belong to MAB list.
This is a PossibleRegression.
Comment 3 Kevin Suo 2014-06-24 05:45:45 UTC 
Created attachment 101635 [details]
test ods file with vadility list in column A.
Comment 4 ign_christian 2014-06-24 06:09:43 UTC 
Suokunlong, it looks duplicate to Bug 67146. It's been broken since old time.

*** This bug has been marked as a duplicate of bug 67146 ***
Comment 5 Yousuf Philips (jay) (retired) 2014-06-24 06:13:43 UTC 
(In reply to comment #3)
> Created attachment 101635 [details]
> test ods file with vadility list in column A.

Tested the file in 3.3.0, 4.1.6 and 4.2.5 and all loose the validity in column A. Saving as xls also has the same effect, but saving as MSO 2003 xml looses it even in A1.

I believe that this example file might not be what Riq was referring to, as i added number values in A1 to A10 and the validity check remained after saving it to xlsx. So Riq please send us a sample file to test against.
Comment 6 Riq 2014-06-24 13:47:54 UTC 
Created attachment 101669 [details]
Column with two cells and validity check

Testing on vers 4.3.0.0 alpha1
Created file LOTest.xlsx with one column containing two cells. Set up validity check for the whole column to allow only these two values ('bank' and 'cash').
Saved as .xlsx file. Loaded back into LibrOffice. Validation works fine on attempts to change either of the existing cells. No validation occurs on entering data into any other cells in the column.
Comment 7 Kevin Suo 2014-06-24 13:53:11 UTC 
(In reply to comment #6)
Exactly the same issue as bug 67146.
Comment 8 Robinson Tryon (qubit) 2015-12-15 22:05:14 UTC 
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]