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 |
Note | ![]() • 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. |