Which MS Excel version you are using, do you not using MS Excel English version?
I think you may try to specify your MS Excel settings, You may check and set the Options Settings in MS Excel ... e.g., select menu option....Tools |Options and select system separators (check box) in International tab in the options dialog box.
Ok, what type of data is stored in your source database, it is in the format like "1,0521" and stored as strings not numbers. Obviously the grid will as it is "string" where "," does not correspond to decimal point.
If this is not the case, could you create a complete test project, zip it and post it here to show the issue. We will check it soon.
I do not know Aspose.Grid at all (only Aspose.Cells). However, I can imagine that StringValue puts a string value into a cell. Even if the argument is a series of digits or a valid number, a string will be put into that cell.
You can do the same with MS Excel. Then there will be a small triangle in the cell telling you “number stored as string”.
When saving a number to a cell, you should use PutValue instead. There are overloaded functions, accepting different types of arguments.
Well in Aspose.Grid.Web if you use WebCell.StringValue property, e.g.,
WebCell.StringValue = "11077";..............When you export the the file from grid to MS Excel, small green triangle would be appeard with the value saying numbers stored as text.
And when you use WebCell.PutValue() method e.g.,
WebCell.PutValue(11077); ..............now Aspose.Grid.Web would export the file to MS Excel with the value stored as General format.
Which OS you are using, are you using some non-English OS? could you give us more details about your environment e.g., .NET Framework, IIS settings, Browser Type etc.