thscharler / spreadsheet-ods

Apache License 2.0
29 stars 6 forks source link

Formatting: negative numbers in red #34

Closed andreas-mausch closed 1 year ago

andreas-mausch commented 1 year ago

It would be great to have an option for a different formatting if a number value is negative.

image

Here is an example in Kotlin using odfdom: https://github.com/andreas-mausch/haspa-camt052-to-csv/blob/00097d577ec02b09020007a1cbcdb37374ce3d18/haspa-parser.kts#L234-L257

thscharler commented 1 year ago

I think it should be possible. Will look into it at the weekend.

thscharler commented 1 year ago

I add example/negative_number_red.rs with a solution.

I'm publishing 0.16 for this, because of course there still was a bug.

thscharler commented 1 year ago

done