SSF - Incorrectly Prepending $ #2696

New Issue

2022-05-26T05:28:47Z

michaelm244 commented

2022-05-26 05:28:47 +00:00

(Migrated from github.com)

Hi, I have a cell with the contents:

{
  "t": "n",
  "v": 7,
  "z": "[$-10409]#,##0;\\-#,##0",
  "w": "$7"
}

Although the formatted value in Sheet JS (the w field) is $7, the value shown in Excel is just 7:

Let me know if it'd be helpful to provide the original Excel file. Thank you!

Hi, I have a cell with the contents: ``` { "t": "n", "v": 7, "z": "[$-10409]#,##0;\\-#,##0", "w": "$7" } ``` Although the formatted value in Sheet JS (the `w` field) is `$7`, the value shown in Excel is just 7: ![image](https://user-images.githubusercontent.com/4361223/170422410-cc84b3d9-aa7c-4fa6-8cfe-c71efee57820.png) Let me know if it'd be helpful to provide the original Excel file. Thank you!

Sign in to join this conversation.