| Re: Macro questions: preserving columnProperty and setting date filter [message #1224 is a reply to message #1217] |
Thu, 11 February 2021 11:37   |
thomas
Messages: 715
Registered: June 2014
|
Senior Member |
|
|
Hi Andrew,
column properties are considered to belong to the data and not to the definition of how to display the data.
Therefore, they are not part of the template. However, you may use the macro task 'Set Column Properties'
to add (or replace) column properties to a column.
When DataWarrior analyses a column, then it is rather flexible concerning data formats. It basically checks, whether it can find three different values per cell and whether they fit in the range of what could be interpreted as data value. If cell entries are plausible dates, then these are converted into float values representing the number of milliseconds since Jan 1st, 1970. This value is used internally for filtering, axis assignment, etc. And it end up in the template filter section.
(https://currentmillis.com/)
Thomas
[Updated on: Thu, 11 February 2021 11:37] Report message to a moderator |
|
|
|
Search
Help
Members
Register
Login
Home
