Hello all,
TLDR; excel cells in my worksheet resize themselves every time the documents is closed and opened. How to fix?
------------
I'm having a problem with some excel components I am trying to use in a worksheet I have setup.
The general idea is I have set this up as a template where the input values can be easily updated, and then the user can quickly see if the desired values pass or fail.
I wanted a quickly visibly colour check (red = fail, green = pass). To do this I passed the values into an excel component and used conditional formatting to change the colour of the cells depending on the value (ie if the check value that was passed in = "Pass" then the cells would be highlighted green, if it was = "Fail" then the cells would be highlight red). This works perfectly, and there's no built in functionality to change the colour of a math region based on the value of a result as far as I'm aware so this is my only option for doing this.
However, my problem arises whenever the document is closed and the reopened. All my excel cells are resized to about half the height they should be. Obviously it is not efficient to have to resize these cells every time the document is opened.
Attached is screenshot displaying the problem. Three excel components are shown. Numbers 1 & 3 are how every cell displays upon opening the worksheet. Number 2 has been resized to what it should be. Strangely enough, once you begin to resize the cells, this is the smallest height you can make them and they cannot be made any thinner. This occurs every time the document is closed and reopened.
Perhaps excel components are not meant to be used in this way, but does anyone have any ideas on how to prevent this, or a quick fix that will auto-resize all cells how they should be?
I have attached a worksheet that shows the problem as well.
I am running Mathcad Prime 7.0.0.0 for reference.
Any help much appreciated!
Stuart
