Dear forum members,
We would like to get rid of the jet formules in the final output of jet reports but we've no clue how to achieve that.
When using Jet I use already "Hide+Values" in the collums with the formula's and in the output itself the formula's are not visible.
However they are still there. When I e.g. copy the file and paste it in another Excel sheet then I get the message below:
Get an error message of Excel 2010 "Het bereik dat u wilt plakken bevat formules die niet in dit exemplaar van Excel kunnen worden geplakt. De formules worden echter geplakt als weaarden. Dit probleem doet zich voor, omdat er mogelijk formules zijn geplakt vanuit de beveiligde weergave, vanuit een ander exemplaar van Excel of vanuit een andere toepassing.
After it, we get collums with values like this below, back again:
"MyDataSource","MyCompany","27","1","036385"
This are colums which the normal users have no clue what to do with, they've to delete them manually. Even when I try to copy only the visible values with using F5, and then pressing special and selecting "visible values only" I have this problem.
Are there solutions to get rid of the Jet formula collums in the Jet reports output without having them to delete manually?
Thanks in advance,
Frederik
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Frederik,
First I should say that you don't need the "+Values" anywhere except in cell A1. In cell A1, you should use "Auto+Hide+Values" or "Auto+Hide+Lock". The +Values or +Lock don't need to be anywhere else in the worksheet.
Can I ask why you would want to copy the report and paste it into other Excel sheets? After you run a report that has Auto+Hide+Values, you can distribute it to users who don't have Jet installed as is. There is no need to copy it to a new Excel file. The values you are seeing are not actually Jet formulas. They are record keys, which are the output of Jet formulas. Since you are using "Hide" in row 1 of the column before running the report, these columns get hidden when the report is run. If you really want to copy the results into a new workbook, in Excel you can do a "Paste Special -> Keep Source Column Widths" which will keep the hidden columns hidden when copying. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Frederik,
An option to get rid of Jet formulas is to use the scheduler:
Make your report, go to "Scheduler", "Output" and select Values Only Workbook + Check the box at "Remove Hidden rows, columns, and sheets".
Caution: Make sure you keep your original report because in your scheduled report you can't go to Design mode!
Regards,
Bert
Please sign in to leave a comment.