| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can't read Dutch written equations in excel files. Could before..
I've recently upgraded from the previous USA Office XP 2002 to USA Office XP
2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
|
#3
|
|||
|
|||
|
Thank you, but this information is too sensitive to send. As you can see, If
is already used in the equations, not Als. These are Dutch words for things like sum, etc. that the US version is not recognzing. I'm looking to understand what makes 2002 read these equations and 2003 not. Are there language updates that may not be in the 2003 install? "Ron de Bruin" wrote: Hi MMS USA If = Als in Dutch You can send me the file private and I will test it for you -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... I've recently upgraded from the previous USA Office XP 2002 to USA Office XP 2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
|
#4
|
|||
|
|||
|
Hi
All normal Excel functions will translate(also in 2003) Only the ATP Add-in functions not. For a file with translations see (FuncRefXLv4-0 from Norman Harker) http://www.contextures.com/functions.html -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... Thank you, but this information is too sensitive to send. As you can see, If is already used in the equations, not Als. These are Dutch words for things like sum, etc. that the US version is not recognzing. I'm looking to understand what makes 2002 read these equations and 2003 not. Are there language updates that may not be in the 2003 install? "Ron de Bruin" wrote: Hi MMS USA If = Als in Dutch You can send me the file private and I will test it for you -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... I've recently upgraded from the previous USA Office XP 2002 to USA Office XP 2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
|
#5
|
|||
|
|||
|
Well, I would have to say they don't. Otherwise this would not be a problem.
Is anyone else seeing this issue? "Ron de Bruin" wrote: Hi All normal Excel functions will translate(also in 2003) Only the ATP Add-in functions not. For a file with translations see (FuncRefXLv4-0 from Norman Harker) http://www.contextures.com/functions.html -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... Thank you, but this information is too sensitive to send. As you can see, If is already used in the equations, not Als. These are Dutch words for things like sum, etc. that the US version is not recognzing. I'm looking to understand what makes 2002 read these equations and 2003 not. Are there language updates that may not be in the 2003 install? "Ron de Bruin" wrote: Hi MMS USA If = Als in Dutch You can send me the file private and I will test it for you -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... I've recently upgraded from the previous USA Office XP 2002 to USA Office XP 2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
|
#6
|
|||
|
|||
|
Well, I would say the only functions that did NOT translate in your formula were the ones belonging to the Analysis Toolpak (ATP). Which is exactly what Ron told you. The ALS() got translated to IF() the AFRONDEN.N.VEELVOUD() did NOT translate to MROUND() This is a known Excel shortcoming. Solutions: ========== 1. Have a name (Ctrl-F3) defining the langage (Lang="Dt" or "Eg" or whatever) and have your formulas containing ATP functions wrapped-written like this : IF(Lang="Dt", dutch_formula, english_formula) In this scenario, the name has to be set on the Workbook_Open event using Application.International(xlCountryCode) result 2. Use http://www.acoustics-noise.com/ATPtranslator.shtml 3. Bypass ATP functions (either by using other 'normal' functions or VBA code) For instance, MROUND(A1,A2) can be replaced by =ROUND(A1/A2,)*A2 Regards, Daniel M. "MMS USA" <MMS wrote in message ... Well, I would have to say they don't. Otherwise this would not be a problem. Is anyone else seeing this issue? "Ron de Bruin" wrote: Hi All normal Excel functions will translate(also in 2003) Only the ATP Add-in functions not. For a file with translations see (FuncRefXLv4-0 from Norman Harker) http://www.contextures.com/functions.html -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... Thank you, but this information is too sensitive to send. As you can see, If is already used in the equations, not Als. These are Dutch words for things like sum, etc. that the US version is not recognzing. I'm looking to understand what makes 2002 read these equations and 2003 not. Are there language updates that may not be in the 2003 install? "Ron de Bruin" wrote: Hi MMS USA If = Als in Dutch You can send me the file private and I will test it for you -- Regards Ron de Bruin http://www.rondebruin.nl "MMS USA" <MMS wrote in message ... I've recently upgraded from the previous USA Office XP 2002 to USA Office XP 2003. In office XP 2002 I was able to use our company's excel file that comes from Holland. All the equations in the excel file are written in Dutch. Here's an example: =IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN. N.VEELVOUD(+G21+2.49,5),IF(+G21<10000,AFRONDEN.N.V EELVOUD(+G21+4.99,10),IF(+G21< 20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25),AFRONDEN. N.VEELVOUD(+G21+24.99,50))))), "") Now, in Office XP 2003 the contents of this equation produces #NAME?. I can't seem to find any type of language setting or addon package that corrects this. Nor can I seem to find out what language changes have been made between the two versions. I've had multiple different installations of XP 2002 on different computers all able to "translate" these equations so that tells me it wasn't unique to just 1 install. How do I get XP 2003 to recognize these equations? Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I read Pocket Excel files from Excel | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Is there a converter to read Quattro pro files on Excel 2002? | Excel Worksheet Functions | |||
Hybrid Mode
