Ask Your Question

Why cannot Calc SaveAs Excel when "Validity" commands are involved?

asked 2018-05-10 18:38:03 +0100

Lew Merrick gravatar image

I use "Validity" extensively. When "Validity" is used, the spreadsheet fails saving into Excel formats. A friend of mine who is a programmer at Microsoft for their Office product set telss me that the Range Nasme is not being properly converted to Excel format. Is there a "fix" on the horizon?

edit retag flag offensive close merge delete



Supposedly you should check the bug report that you've filed from time to time to find it out?

Mike Kaganski gravatar imageMike Kaganski ( 2018-05-10 18:49:52 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-26 15:06:40 +0100

Lew Merrick gravatar image

updated 2018-05-26 15:07:52 +0100

OK, after more effort than I had imagined, it turns out that using Cell Ranges rather than Range Names solved my problem. It seems somewhat strange, but it worked!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-10 18:38:03 +0100

Seen: 21 times

Last updated: May 26 '18