Floating EUR number

[Alessio]

Hello, this is my code:

<script>

    document.addEventListener('DOMContentLoaded', function () {

        ej.base.enableRipple(window.ripple);

        var spreadsheet = new ej.spreadsheet.Spreadsheet({

            locale: "it-IT",

            openUrl: 'Home/Open',

            saveUrl: 'Home/Save',

            created: function (args) {

                var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');

                var request = new XMLHttpRequest();

                request.responseType = "blob";

                request.onload = () => {

                    var file = new File([request.response], "Budget mensile personale1.xlsx");

                    spreadsheetObj.open({ file: file });

                }

                request.open("GET", "/Files/" + "Budget mensile personale1.xlsx");

                request.send();

            },

            dataBound: function () {

                if (!spreadsheet.isOpen && spreadsheet.activeSheetTab === 1) {

                    spreadsheet.cellFormat({ fontWeight: 'bold', textAlign: 'center', verticalAlign: 'middle' }, 'A1:F1');

                    spreadsheet.numberFormat('$#,##0.00', 'F2:F31');

                }

            }

        });

        ej.base.setCurrencyCode('EUR');

        setLocale();

        //Render initialized Spreadsheet component.

        spreadsheet.appendTo('#spreadsheet');

    });

</script>

I have set ej.base.setCurrencyCode('EUR'); tryng to get right formatted number values.

This is the currently result:

But, i need this result: €4.300,00 
So, the point for 1K+ and floating for decimals.

What is wrong or missing?

Thanks.

P.S: Do you confirm that the 20 May will be the day of some fixes release?

[Alessio]

Hello??

[Saranya Dhayalan]

Hi Alessio, 

 

Thank you for contacting Syncfusion support 

 

We have checked your reported issue, resolve this issue you need to set the culture by using setCulture method. Please find the below code snippet: 

 

ej.base.setCurrencyCode('EUR'); 

 ej.base.setCulture("It"); 

 

 

If still issue persist please provide the issue reproducible sample. Please share If you loaded with excel, based on that we will provide better solution quickly. 

 

Documentation link: https://ej2.syncfusion.com/documentation/common/internationalization/?no-cache=1#setting-global-culture 

 

Regards, 

Saranya D 

[Alessio]

Hello.

I send you my project, maybe you will understand better what I want and how can I do it.

Row 28: Read comments.

With the option: spreadsheet.numberFormat('$#.##0,00', 'A1:AZ999');

I am not getting the desired result.. also I have noticed a bug, while scrolling on bottom or somewhere on the sheet, the formatted number goes to error.

FIRST LOAD:

LATER: 

Thanks,

Alessio

Attachment: SpreadsheetSaveBacktoServerAR11_e0c8f84c.zip

[Unknown]

Hi Saranya,

please let me know the resolution status of the requested fix.

Your indications generates however other bugs (as you can see by the images).

if I'm not mistaken, this fix had to be closed on May 20th, but it's still open.

I hope for a quick resolutive answer.

Alessio

[Saranya Dhayalan]

Hi Alessio,  

 

Sorry for the inconvenience caused. 

 

Query: while scrolling on bottom or somewhere on the sheet, the formatted number goes to error. 

 

We have checked your attached excel in the project. you have used the table formulas in the excel file. We would like to let you know that currently table formula support is not available. we have logged this as a feature request. This feature will be available in any of our upcoming release. You can track the status of this feature by using the following feedback report link. 

 

Feedback – https://www.syncfusion.com/feedback/14801/table-formula-support 

Regards, 

Saranya D 

[Alessio]

Hello.

Any news about this request? How long do you think it will be necessary to implement?

Thanks,

Alessio

[Saranya Dhayalan]

Hi Alessio, 

 

We would like to let you know that table formula feature will be available in our Essential studio 2020 volume 4 release. Until then appreciate your patience. 

 

Regards, 

Saranya D