I am almost able to use a pivot table. The problem is that when JETT executes the sheet with my pivot table (it refs other tabs with data and the data has jett tags until that tab is processed).
This causes my pivot tab to pull in the jett tags in to the pivot tab and JETT tries to process these tags (which are cell refs to other tabs). I tried to surround the pit with <jt:null> .. </jt:null> but this is not stopping jett from thinking the pivot table is additional jett tags. Is there a wat i can make jett leave the picot table alone as it will be populated by data after jett is finished processing tags in other tabs?
*UPDATE: Ok it works but you have to manually edit the text in the pivot table to remove jett tags (which is ok because the table updates with real data anyways).
**NOTE: it would be nice to have a new tag that tells jett to ignore all tags and expressions (like jt:null but applies to tags too)
Last edit: Mark Vejvoda 2014-06-12
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As part of Ticket #21, in code I just checked in, you can now register a SheetListener that has the ability to prevent an entire sheet from being transformed. This should allow you to create a class that implements SheetListener that recognizes your pivot table sheet and returns false in beforeSheetProcessed to prevent the sheet from being transformed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am almost able to use a pivot table. The problem is that when JETT executes the sheet with my pivot table (it refs other tabs with data and the data has jett tags until that tab is processed).
This causes my pivot tab to pull in the jett tags in to the pivot tab and JETT tries to process these tags (which are cell refs to other tabs). I tried to surround the pit with <jt:null> .. </jt:null> but this is not stopping jett from thinking the pivot table is additional jett tags. Is there a wat i can make jett leave the picot table alone as it will be populated by data after jett is finished processing tags in other tabs?
*UPDATE: Ok it works but you have to manually edit the text in the pivot table to remove jett tags (which is ok because the table updates with real data anyways).
**NOTE: it would be nice to have a new tag that tells jett to ignore all tags and expressions (like jt:null but applies to tags too)
Last edit: Mark Vejvoda 2014-06-12
As part of Ticket #21, in code I just checked in, you can now register a
SheetListenerthat has the ability to prevent an entire sheet from being transformed. This should allow you to create a class that implementsSheetListenerthat recognizes your pivot table sheet and returnsfalseinbeforeSheetProcessedto prevent the sheet from being transformed.