With the Tabel builder I build one single table with Flow fields.
Without the flow fields: no problem
With the flow fields: Error, see image in attachement.
The result is a table with 810 records filled and 15000 records empty
Anyone a clue?
Date
Votes
5 comments
-
Jet Reports Historic Posts Could you provide steps for duplicating this? (e.g., 1-Create new workbook, 2-Click Table Builder on the Jet Ribbon, …)
What version of Excel are you using?
-HP -
Jet Reports Historic Posts @HP thanks for your interest.
I found the problem. The Navision field contained the string: = week 8
For Excel it would mean a reference to a named range containing a space which is not allowed.
Is there a way to enforce reading the field as text without harrassing the NAV users? -
Jet Reports Historic Posts I found the problem. The Navision field contained the string: = week 8
Could you provide some more information about the Navision field? Are you saying that the value of the field itself contains "= week 8"?
The problem seems to be occurring when Excel is expanding the table. If the value of the cell is "= week 8", Excel would interpret this as an invalid Excel formula and throw the error you are seeing. -
Jet Reports Historic Posts I found the problem. The Navision field contained the string: = week 8
Could you provide some more information about the Navision field? Are you saying that the value of the field itself contains "= week 8"?
ELMO: that is correct
The problem seems to be occurring when Excel is expanding the table. If the value of the cell is "= week 8", Excel would interpret this as an invalid Excel formula and throw the error you are seeing.
ELMO: I came to the same conclusion.
If I copy/paste directly from a NAV table, the content of the filed is regarded as text which is fine for Excel.
However when I use JetExpress the content of the NAV filed is regarded as Standard format. The result is a invalid formula.
For us it is mandatory that, before import, the format could be forced to Text.
If this is not possible than that's a showstopper for Jet Reports -
Jet Reports Historic Posts If I copy/paste directly from a NAV table, the content of the filed is regarded as text which is fine for Excel.
However when I use JetExpress the content of the NAV filed is regarded as Standard format. The result is a invalid formula.
For us it is mandatory that, before import, the format could be forced to Text.
If this is not possible than that's a showstopper for Jet Reports
Our full product Jet Essentials contains additional functions that would allow you to convert the offending field into a CalcField, instructing Excel to not interpret the data as an Excel function.
Outside of that, the only way around this problem is to modify your data in NAV so that the data does not begin with "=".
Please sign in to leave a comment.