Ask Your Question

How to save Data validations on Columns in XLS format

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

Libre_hunt 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 145 times

Last updated: Aug 23 '16