Hi Experts,
i have a browser enabled InfoPath 2007 form with following settings:
Formlanguage is german
No-Code-Behind, just Rules
MOSS installation is german
Site collection is german
Fields:
PositionsTotal (Number: Formatting is Currency EUR)
VAT (Number: Formatting is Currency EUR)
Total (Number: Formatting is Currency EUR)
How values will be set:
PositionsTotal default is sum(Repeating table: posvalue)
VAT will be set through a rule (PositionsTotal * @Value[@Key = "CurrentVAT"] / 100) @Value is a dataconnection determining a configurable VAT
Total will be set through a rule (PositionsTotal + VAT)
If i open the preview when designing the form and play around everything is working fine.
If i fill out the form in my SharePoint-Library everythings seems ok.
If i then send the form to SharePoint it gives me an error. VAT is not a number
Fieldtypes in the SharePoint library are number
Does anybody knows whats going on here?
Thx
Ronny
The view1.xsl has the correct formatting information for the mentioned fields: xd:boundProp="xd:num" xd:datafmt=""number","numDigits:2;negativeOrder:1;""
What i did in the meanwhile:
Restartet MOSS
Adding function translate to the calculation rules, e.g. translate(PositionsTotal + VAT;",";".")
Then sending to MOSS did work, BUT: The Fields in the SharePoint-Library are showing 3 digits after the decimal (e.g. 1.525,375)
Any hints?