Excel export with percentage formatted summary.

[Tamás Réti-Nagy]

Hi there!
I have a problem with exporting my grid into an xlsx file. At my summary row definition I have my Summary column's format like this: 

.Format("{0:n2}%")

This is a column with Custom summary value. I have my JS function to calculate it's value, and it calculates it right. In my browser it appears right, like

98.75%

In my controller, in the function which I give into the "QueryCustomSummaryInfo" property for the exporting, I have the same logic like in my JS function. I do not add any '%' symbols or anything, just calculating with numbers. It returns a float.

After this, I still got my cell value wrong in the Excel export. It has 2 % symbols, like this:

 98.75%%

[Manivannan Padmanaban]

Hi Tamás, 

Thanks for contacting syncfusion support. We are happy to assist you.  

We are able to reproduce the reported issue at our end and we have confirmed this as defect the fix will be included in our Volume 3 service pack 1, 2018 release which is scheduled to be rolled out at the month of October 2018.  

Until then, we appreciate your patience. 

Regards, 

Manivannan Padmanaban. 

[Tamás Réti-Nagy]

Hi Manivannan,

Thanks for your response. I guess I found another glitch too, but I am not sure about that. If I give a title to the Summary Row with the Title command:

.Title("Total: ")

It shows okay in the MVC's View: https://imgur.com/uo6yQ76

But it is not okay in the exported files (Excel, Word, Pdf). It puts the title into the last column of the summary row, replacing the summary value in it. Please see the images below:

Excel: https://imgur.com/VLdWkzk

Word: https://imgur.com/5WgPY5e

Pdf: https://imgur.com/tphlqLX

FYI. The %% problem is present in the Word and Pdf exports too.

[Vignesh Natarajan]

Hi Tamás, 

 

 

Thanks for the update. 

 

 

Query1:  “ I guess I found another glitch too, but I am not sure about that. If I give a title to the Summary Row with the Title command:” 

 

 

Before proceeding with you query, we need the following details which will be helpful for us to validate the query. 

 

1. Share your essential studio version (XX.X.X.XX).
2. You have mentioned that Summary title is replacing the last summary column. can you please confirm whether the value is replaced by title or title value is preponed in the last summary value.
3. Also in exported word document, summary title is placed after the summary value. Can you please share the code example how you have defined the summary values?.
4. Share the grid rendering code.   

  

 

Query2: “The %% problem is present in the Word and Pdf exports too.”  

 

 

As informed earlier, we will fix the reported issue for Excel along with the PDF and Word exports also. The fix will be included in our upcoming release 2018 Volume 3 Service Pack 1 which is scheduled to be rolled out by the month of October 2018. 

 

 

Regards, 

Vignesh Natarajan