Quote:
Originally Posted by readin
@BetterRed:
How did you implement your solution to display cells as blank when zero? Does it work for floating point number columns, e.g. formatted using {0:.1f} to display 1 decimal place?
Thx  |
@
readin - chaley added some easy-to-use 'keyboard special values' for numeric and date columns, I know they work when entering data directly into the book list, unsure if they work in Single & Bulk Metadata Edit, but I'd be surprised if they didn't.
A space in an integer or float will set the value to 'Undefined'
An '=' in a date will set it to current data and time, and a '-' will set it to 'Undefined'
'Undefined' always displays as blank.
BR