Custom cell format not applying #2565

New Issue

2019-06-04T18:48:12Z

lefthandedgoat commented

2019-06-04 18:48:12 +00:00

(Migrated from github.com)

I have found a custom format that is not applying correctly.

#,##0.0000 %

If I remove the space it works correctly, but the files I am processing are from a third party and I can not modify them.

I will also send an email with a excel sheet to reproduce.

Please let me know if there is anything else I can do to help. Thanks!

I have found a custom format that is not applying correctly. ```#,##0.0000 %``` If I remove the space it works correctly, but the files I am processing are from a third party and I can not modify them. ![image](https://user-images.githubusercontent.com/725225/58905393-42e27380-86cf-11e9-88fb-78a0c4efdfc0.png) I will also send an email with a excel sheet to reproduce. Please let me know if there is anything else I can do to help. Thanks!

snoopyjc commented

2020-10-03 20:47:51 +00:00

(Migrated from github.com)

The '%' character needs to be treated as any other escaped character in the format in that it appears unchanged in the output in the same place it appears in the format, and then the value is multiplied by 100 for each '%' found before being formatted.

Sign in to join this conversation.