![]() ![]() Is there a "universal" way to set the NumberFormat property? (using the default English locale?) My question is: Obviously, if I hardcode these values in my program there is going to be an exception when my program is used with an English or another differently localized version of Excel. So whenever setting the NumberFormat from my Delphi program I need specify it like "#0,00". In my locale, the thousands separator is " " and the decimal separator is ",". In reality, I'm using a localized version of Excel. That means the thousands separator is "," and the decimal separator is ".". Normally, when checking the formatting by recording a macro in Excel, Excel is expecting it like this: When automating Excel via OLE from my Delphi program and trying to set a cell's NumberFormat property, Excel is expecting the format string in a localized format. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |