Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a language independent formula
Hi all...
I am using Excel COM component to transform a CSV file into an XLS file. After converting it, I need to summarize a column that contains numbers. I am using FormulaR1C1 property of a Cell object. In order to know what value I need to place in that property, I used Excel by recording a new macro and make the sum. When I saw the generated code, FormulaR1C1 property was assigned this value : "=SUM(R[-488]C:R[-1]C)". I have Microsoft Excel in Spanish, so I thought that formula was writen in a standard way. Well.. when I used the same code from my component I got an exception. After some tests, I discovered that I should assign "=SUMA(F(-488)C:F(-1)C)" to FormulaR1C1 property (that is, the formula written in spanish). By using this formula would work for users that have Excel in Spanish, but not for users that have Excel in English. Is there any way to solve this problem? Thanks a lot in advance Jaime |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
Can someone write this formula for me in Excel 2003 Language | Excel Worksheet Functions | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) | |||
how to write other language in text file from VBA | Excel Programming |