Quote:
Originally Posted by chaley
On topic: there is no format expression to display 0 as blank.
Solution 1: Use a composite column and a template that notices the value in the numeric column is zero.
Solution 2: since the goal seems to be to notice them, use column coloring or a column icon to flag a cell with a zero value.
|
Thanks
chaley, no surprise then that I couldn't find it.
The baggage of Algol weighs heavily on the shoulders of those who struggle under its legacy. For 2 score or more Christmas's all I've wished for is a %z in a printf
.
My observation is that composite columns and colouring have a negative impact on Calibre performance... Also I would have to interpret the meaning of the colour or icon; which would impact on my performance. Whereas an an empty cell is self explanatory.
So whilst ever it works, I'll use the '-1000000' solution
BR