Currently, when you display an Excel document with a date and time format on it that contains an asterisk (*) symbol, prizmDoc uses the settings that are on the Server to display it. This is because Excel specifies that any cell that has a date and time formats with the asterisk (*) symbol, it responds to changes in regional date and time settings that are specified in your server.
Formats without an asterisk (literals) are not affected by the server settings, and currently, PrizmDoc cannot override this.
For example, if my Server's settings are in the format dd/mm/yyy and I have an excel document that has a format setting with the asterisk (*), prizmDoc opens the document with my Server's format (dd/mm/yyy).
Otherwise, if I have a document that is in the format mm/dd/yyy and I open it in prizmDoc with my Server's settings dd/mm/yyy, it will open the document with the format (mm/dd/yyy)
It would be nice if I can use any time format, not only the ones that have asterisks, and display the documents in prizmDoc with my regional settings.