Hello,
we have some heavily customized data entry schedules, with dynamic ranges for rows (columns are static tho).
We use the EVCOM function for comments: the user sees a "yellow cell" where he must input his comments, all the while the real EVCOM function is hosted on a "grey cell" hidden from view.
The Comment is always present on the hidden grey cell, where the EVCOM function is found. After we run the Expand command, the comment is seen also on the Yellow Cell. However after a Refresh command the yellow cell is always found empty, even if the Grey Cell still shows the comment.
In sum: "Refresh" seems to empty the Input Cell for comments using the EVCOM function. Is this a known bug or am I doing it wrong? Thanks.