search

microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
113 stars 11 forks source link

Hidden Sheet - needs to make clearer that comments & formatting will be lost #9

Closed dreamstar-enterprises closed 1 year ago

dreamstar-enterprises commented 2 years ago

Hi,

I think if you turn the Hidden Sheet option off, there should be a warning that says all the comments and formula formatting will be lost. In my case even some of the formulas broke when I turned this option off (and closed and opened Excel), but then I had to upgrade to the latest version of Excel. Then only the comments and formula formatting were lost.

If users rely on the Hidden Sheet, and then it's turned off by accident, it can easily break the whole workbook. Whilst I know you do not consider Hidden Sheet as a long term solution, there should be a clearer warning of what will happen when this option is turned off, so the user properly understands its affect.

jack-williams commented 2 years ago

Thanks for the feedback @StarTech-Enterprises. Can I ask, are you using Windows/Web/Mac?

dreamstar-enterprises commented 2 years ago

Hi Jack, I am using the latest Excel Build 16.59 (22020901) on Mac

I'm thinking from the perspective of sharing a workbook with other users who (i) might not have the latest Excel build (ii) might have the hidden sheet setting turned off.... and they use it wrongly, turn the hidden sheet option, on, and then off, or something similar...it would break the whole workbook, especially if they are using an old build.... : (

Hope you Supersmart people and Supersmart engineers can solve it!

Sachin

jack-williams commented 1 year ago

Closing this because hidden sheets are now deprecated in the new version of AFE. The code files are always stored with the document and are manager separately from names defining using the name manager. As a result, there is no hidden-sheet option.