format integer cells as blank when 0

[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 :)

[BetterRed]

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

[readin]

Originally Posted by BetterRed

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.

Perfect!

Thanks BetterRed and chaley