Does SpreadsheetConverter handle the error values #N/A #ERROR #VALUE?
Yes, all error values will be seen as the single value NaN (Not-a-Number). All error values are mapped to the same value, so you cannot distinguish between #VALUE and #N/A for example. Since not all users of web pages are used to using Excel, they may not be used to Excel’s error values. Therefore, it is better to make sure that the error values are not shown to the user in order to avoid confusion.
Related Questions
- When trying to import a .dxp table into D-List, I get the following error: Number of query values and destination field not the same. What does this mean?
- Why am I receiving an Invalid UPC value error message if Im including valid UPC values?
- Error message "Maximum number of cookie values has been reached." What does this mean?
