I’ve seen a few mentions recently about being able to say SUM by colour, or AVERAGE if bold etc.
Currently I don’t think format is part of the calculation chain of any spreadsheet app. So any format based function would have to be volatile. Such functions are fairly trivial to write in VBA, a bit (but not much) harder in xlls.
But I have a more fundamental question:
Should we be able to base functions on formats?
Is it reasonable that changing the look of one cell would change the value in another?
I know these requests are popular on-line, but so was a million rows.
I have had a bit of a think about it and I think we should preserve the clear separation of the value and presentation of that value. (I know that got a bit muddied by Excel percentages but still).
I think having values dependent on formats would make verifying the correctness of a model even harder.
What do you think?