Spreadsheet Editor join string and numeric cause formula decimal places incorrect

[mymbrooks]

This issue is unique.

• [X] I have used the search tool and did not find an issue describing my bug.

Operating System of DocumentServer

Docker

Version information

8.0.1.31

Expected Behavior

formula decimal places correct

Actual Behavior

formula decimal places incorrect

Reproduction Steps

1、set formula with =IF(D8="","",D8*E6/100) ---- correct

2、set formula with =IF(D8="","","±"&D8*E6/100) ---- incorrect

Additional information

No response

[rsnegirev]

Hi @mymbrooks

Can you please attach a file example?

[mymbrooks]

压力表.xlsx @rsnegirev E19 is incorrect E20 is correct

[rsnegirev]

Hi @mymbrooks

I can confirm, this is the bug number 66942. When some fixes will be done we'll text you here in this issue.

Thank you for the report!

[mymbrooks]

@rsnegirev Hi rsnegirev, Any progress for this bug? It's a big problem for my customer, is there a fix plan for this?

[rsnegirev]

Hi @mymbrooks

Unfortunately, not yet. It will probably be fixed in the next major version. I will remind the developers.

[mymbrooks]

@rsnegirev OK thanks