Exporting data to XLS / XLSX
When exporting data from Planon to Excel, the data is exported mapping the system 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 mask |
Dates/date-time/time | Custom | Taking into account the 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 mask will be exported with the java mask. This could differ from the Excel mask.
• Separators (date, decimal, thousand) are derived from the Excel user locale.