Ask Your Question
0

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
0

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

Comments

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

Stats

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

Seen: 128 times

Last updated: Aug 23 '16