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.