Könnte eine Sache von Listentrennzeichen sein...
The ShapeSheet is supposed to use a "universal" language, which is U.S. English. That means list and thousands separators are commas and decimals are points. But when you make lists for the INDEX function, the default separator is a semi-colon.
German uses a list-separator of a semicolon, so this might be causing a problem, especially if there is some sort of bug involved.
So think about the basic set of formulas:
User.colorNames = “AliceBlue;AntiqueWhite;Aqua;…”
User.colorValues = “RGB(240,248,255);RGB(250,235,215);RGB(0,255,255);…”
User.color1 = INDEX( LOOKUP( Prop.color1, User.colorNames ), User.colorValues )
Try breaking User.color1 into two parts:
User.color1Index = LOOKUP( Prop.color1, User.colorNames )
User.color1Value = INDEX( User.color1Index, User.colorValues )
Try viewing the values in the ShapeSheet, and see if something looks wrong. If so, then try specifying your list-separator in the functions:
User.color1Index = LOOKUP( Prop.color1, User.colorNames, ";" )
User.color1Value = INDEX( User.color1Index, User.colorValues, ";" )
If that doesn't work, try a new list separator:
User.colorValues = “RGB(240,248,255)|RGB(250,235,215)|RGB(0,255,255)” // just three colors for testing!
User.color1Index = LOOKUP( Prop.color1, User.colorNames, "|" )
User.color1Value = INDEX( User.color1Index, User.colorValues, "|" )
Or, since there might be a problem with list-separators, change the RGB-function separators to semicolor, AND use the bar:
User.colorValues = “RGB(240;248;255)|RGB(250;235;215)|RGB(0;255;255)” // just three colors for testing!
User.color1Index = LOOKUP( Prop.color1, User.colorNames, "|" )
User.color1Value = INDEX( User.color1Index, User.colorValues, "|" )
I haven't tried setting the culture settings on my machine to German, but hopefully these examples will help you break down and find where the problem starts.