Closed cschloer closed 4 years ago
There are issues with the preserve_formatting code for "multisections": https://support.microsoft.com/en-us/office/review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5?ui=en-us&rs=en-us&ad=us
An example code would look like 0.0_);[RED]\(0.000\).
0.0_);[RED]\(0.000\)
I've updated the code to properly split by semicolon, and use the second section for negative numbers.
Please preserve this line to notify @roll (lead of this repository)
Overview
There are issues with the preserve_formatting code for "multisections": https://support.microsoft.com/en-us/office/review-guidelines-for-customizing-a-number-format-c0a1d1fa-d3f4-4018-96b7-9c9354dd99f5?ui=en-us&rs=en-us&ad=us
An example code would look like
0.0_);[RED]\(0.000\)
.I've updated the code to properly split by semicolon, and use the second section for negative numbers.
Please preserve this line to notify @roll (lead of this repository)