search

gustavnavar / Grid.Blazor

Grid component with CRUD for Blazor (client-side and server-side) and ASP.NET Core MVC
GNU Lesser General Public License v2.1
697 stars 135 forks source link

excel column output shows Infinity for string column #362

Closed tony-asu closed 1 year ago

tony-asu commented 1 year ago

Describe the bug

when the string that's displayed in a cell has an E it tries to do math, such as "9025058500E540" (this is a product number in my current data).

To Reproduce Steps to reproduce the behavior: add a column with the string value of 9025058500E540 than click download. see the word Infinity in the excel doc for the value.

Expected behavior I expected to see the text "9025058500E540". or more so.. when the value type for the column is a string, I'd expect the excel display type to be text.

also I love this grid!! thanks for all the hard work

gustavnavar commented 1 year ago

Package 3.4.1 fixes this issue