0

NL-function changes in Design mode

Hi!

I'm fairly new to JetReports, I have searched the site but have not found anything to help me with this issue, so I'll try and explain it, perhaps there is a straight - forward solution.

I have the following NL-function in my spreadsheet (Excel 2007, not compatibilty mode)
=NL("Sum";"G/L Entry";"Amount";"Posting Date";E$5;"G/L Account No.";$C11;"Datakilde=";"OMD_LESSOR_PROD";"company=";"FK OMD.LØN";"Global Dimension 1 Code";$D$6;"Global Dimension 2 Code";$D$7)

The problem is, that everytime I change from Report-mode to Design mode, the formular changes!!! To this:
'=NL("Sum","G/L Entry","Amount","Posting Date",E$5,"G/L Account No.",$C11,"Datakilde=","OMD_LESSOR_PROD","company=","FK OMD.LØN","Global Dimension 1 Code",$D$6,"Global Dimension 2 Code",$D$7)

So it has changed the NL-function to a text-value and all semi-colons are changed to commas….very annoying. I have checke language settings is Danish in Win7 and in JR.
It does not change back, when going to Report-mode.

Any ideas?

Best regards
Busk

0 comments

Please sign in to leave a comment.