Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Re:Problems with german excel version (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Problems with german excel version
#45
andro67 ()
User Offline Click here to see the profile of this user
Problems with german excel version 1 Year, 8 Months ago Karma: 1  
The UND() function collides with the logigal AND() operator. The german version of excel translates every standard function in german language. Unfortunalety the german word for 'and' is 'und' which means the logical AND() operator in the german excel version is UND(). So I can't use the UND() function.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#46
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Problems with german excel version 1 Year, 8 Months ago Karma: 470  
This is a very interesting.
Do you get any errors when the excel starts up due to duplication of functions?
If you are inserting a cell formula and select insert>function is the UND() function listed once or twice?
Is the OVD() function listed?

I am thinking about a work around by providing another function will behave as the UND function but call it UDI().
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#47
andro67 ()
User Offline Click here to see the profile of this user
Re:Problems with german excel version 1 Year, 8 Months ago Karma: 1  
BoJosley wrote:
QUOTE:
This is a very interesting.
Do you get any errors when the excel starts up due to duplication of functions?

No

If you are inserting a cell formula and select insert>function is the UND() function listed once or twice?
Twice, first the logical operator and then the xlc function

Is the OVD() function listed?

Yes

I am thinking about a work around by providing another function will behave as the UND function but call it UDI().


I also tried to select the correct UND() function via 'insert function' but it still doesn't work. The error I get is "#OVD()/UND() function misuse. Check that OVD() occurs immediately before / and UND() occurs immediately after /.#"
It looks like the XLC UND() is automatically converted to the logical UND().
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#48
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Problems with german excel version 1 Year, 8 Months ago Karma: 470  
Can you give me a few days to work on this? I'll have a look at it over the weekend.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#49
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Problems with german excel version 1 Year, 8 Months ago Karma: 470  
Download XLC again - I have modified the program so that:
UND() is used as the logical AND() function in German versions of MS Excel. To prevent conflicts:

UDI() can be optionally used in place of UND().

and for the sake of consistency ODI() can be optionally used in place of OVD().

I have also updated the help files http://www.excelcalcs.com/content/view/57/132/

Everything appears to be working fine, please let me know if you have any problems.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#50
andro67 ()
User Offline Click here to see the profile of this user
Re:Problems with german excel version 1 Year, 8 Months ago Karma: 1  
BoJosley wrote:
QUOTE:
Download XLC again - I have modified the program so that:
UND() is used as the logical AND() function in German versions of MS Excel. To prevent conflicts:

UDI() can be optionally used in place of UND().

and for the sake of consistency ODI() can be optionally used in place of OVD().

I have also updated the help files http://www.excelcalcs.com/content/view/57/132/

Everything appears to be working fine, please let me know if you have any problems.


Thanks! Now it works fine.

However, I discovered another problem:

I defined the following:

r=67,5 (using a ',' as decimal sign)
and
d=pi()*r^2/4

When I now display the formulae using the showworking=1 option the value for r is displayed as 675 instead of 67.5 or 67,5.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop