Bug 67146

Summary: FILESAVE: Validation is removed in XLSX
Product: LibreOffice Reporter: mraetsen <mraetsen>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: gracz, mariosv, riq
Version: 3.5.4 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=41425
Whiteboard: BSA
i915 platform: i915 features:
Attachments: Sheet with validation on column A1

Description mraetsen 2013-07-21 20:06:06 UTC
Created attachment 82786 [details]
Sheet with validation on column A1

Problem description: 
Trying to move to using libreOffice Clac but need to support Excel as well. If you have an XLSX file that has validation on the entire column, when you save (as xlsx), only the last cell that has data retains the validation. Cells below that remove the validation.

Steps to reproduce:
1. Attached xlsx has cell validation from A1:A200
2. Modify any cell (say A10)
3. Save as xlsx
4. When re-opened, cells below A10 have no validation.

Current behavior:

Expected behavior:

              
Operating System: Windows 7
Version: 4.2.0.0.alpha0+ Master
Comment 1 m.a.riosv 2013-07-22 01:03:53 UTC
Reproducible.
Win7x64i3Ultimate
Version: 4.2.0.0.alpha0+ Build ID: 2cce78137bbf9810421b9fdedd45127b019b1188
TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-07-18_23:43:36
Comment 2 hesth 2013-09-13 15:47:57 UTC
Bug reproduced using Ubuntu 13.04 with two Calc versions -  4.0.2.2 and 4.1.1.2
Comment 3 ign_christian 2014-06-24 06:09:43 UTC
*** Bug 80407 has been marked as a duplicate of this bug. ***
Comment 4 ign_christian 2014-06-24 06:17:50 UTC
Change Version to 3.5.4 -> based on Bug 56823
Platform All

For XLS : Bug 41425
Comment 5 raal 2015-01-21 10:23:47 UTC
*** Bug 88494 has been marked as a duplicate of this bug. ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.