Ask Your Question
0

Why cannot Calc 5.4.6.2 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

Comments

1

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
1

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

Stats

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

Seen: 23 times

Last updated: May 26 '18