We have designed a JET report to facilitate an Excel upload back into NAV. The issue is JET is adding "Auto+Hide+Values" into cell A1 and then hiding the first row and column, even though this tab does not have any JET formulas. I've noticed this even happens to blank sheets once JET is run. Is there any way to prevent this? NAV is expecting the template exactly as it was exported, not with these hidden cells.
Thanks in advance,
Chris
Date
Votes
3 comments
-
Bryan Robinson This is expected behavior with Jet since row 1 and column A are used/reserved for Jet Keywords https://support.jetglobal.com/hc/en-us/articles/219402947-Jet-Excel-add-in-Keywords-
In order for Jet to work, it has to add Auto+Hide (and to some extend +Values) to run the report, you cannot disable this.
If you need to import the data back into NAV, the easiest way is to copy the visible cells in the report and paste them as values into a new workbook starting in cell A1. Import that new workbook into NAV.
-
Chris M Thanks Bryan. I was hoping since there are no JET functions within the worksheet, that there would be a way for JET to just leave it as is. I completely understand for tabs that use JET, but why change unrelated ones as well.
-
Bryan Robinson Jet cannot distinguish between sheets, meaning, when you run a Jet report, it will look through all worksheets. In order to do that, it has to have those keywords and hide those regions.
You can always submit ideas/requests on the Jet ideas portal: https://jetideas.ideas.aha.io/
Please sign in to leave a comment.