06-13-2023 12:07 PM
Hi
Is it possible to show a message box in excel?
I am currently writing a SpreadsheetFunctionType.SaveTableView rule and I would like to display a message box to the user with any data validation errors when trying to save.
I have tried :
Throw New XFUserMsgException(si, Nothing, Nothing, "My error message")
However, this doesn't seem to work.
Regards,
Mark
06-13-2023 01:38 PM
Nope, there is none. I'm not sure if I logged an enhancement request for this. Please log one or ask to get added to that one.
06-13-2023 01:39 PM
The exception will log only to the log file. Admins can check it. But not users. The main pain point is, if something fails, it will behave as if everything was good.
06-15-2023 10:17 AM
Hi,
As an alternative, you can have a "Results" or "Comments" column in your table view and display that column to have "SUCCESS"/"FAILURE" or any relevant message with color coding. And user training can be provided for correcting errors as per different validation errors.
Hope this helps.
06-15-2023 11:52 AM
You can do anything in OneStream. That will work if you return a tableview for every try-catch block.
06-15-2023 11:56 AM
Thanks, this is a good shout!
I will try it