Exporting data to XLS / XLSX
When exporting data from Planon to Excel, the data is exported mapping the Planon format to Excel. This enables users to perform calculations in Excel without having to first reapply formatting.
The mapping between Planon and Excel is as follows:
Planon field type | Excel cell format | Remark |
|---|---|---|
Numbers | General | Not taking into account the Planon mask |
Dates/date-time/time | Custom | Taking into account the Planon mask |
• There is a difference in the way times are treated in Planon and Excel. Times are stored in numbers in Planon and the '0' is defined differently. This may cause unexpected results when comparing times in Planon and in Excel.• Expressions, if the result is a number, date, date-time or time, will be formatted as specified above.
• Totals and group totals will be formatted as specified above.
• Group headers will not be formatted.
• Expressions, if the result is a number, date, date-time or time, without a Planon mask will be exported with the Planon java mask. This could differ from the Excel mask.
• Separators (date, decimal, thousand) are derived from the Excel user locale.