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.