Ask Your Question

How to save Data validations on Columns in XLS format [closed]

asked 2016-08-22 09:09:46 +0200

Libre_hunt gravatar image

updated 2020-09-10 20:53:28 +0200

Alex Kemp gravatar image

I am using a .xls format file and have been trying put simple validation on currency column and when i close and reopen the file ,the changes are lost. Please help if this is a bug or how to do it.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 20:53:59.598051

1 Answer

Sort by » oldest newest most voted

answered 2016-08-23 17:21:05 +0200

mark_t gravatar image

If you are using Data, Validity... for the validation and saving as an xls file then you need to be carefull that you are only using data validity options that are available in Excel for an xls file.

If you could give more details of the validation you are trying to perform then I can test with Calc and Excel 2010 and perhaps give an alternate method.

edit flag offensive delete link more


Hi i want to save data validation for various fileds but 1) I cant save in xls format which is mandatory for me 2) I cant apply data validation for whole columns pls help me

sneha gravatar imagesneha ( 2017-02-20 16:52:49 +0200 )edit

Question Tools

1 follower


Asked: 2016-08-22 09:09:46 +0200

Seen: 148 times

Last updated: Aug 23 '16