TMS Excel Toolbar
×
Menu
Index
Search
 
   
   
   
 
  (c) Data-Bond Oy, 2018

3.3 Report additional settings group

 
Report Additional Settings group.
 
Optimized update (use of this is recommended)
-          optimized update enables add on features for data import
o   file pattern
o   filtering
o   excel file import
o   xml file import
o   timestamp check
o   …
Remove headers (use of this is recommended)
-          defines whether importing header feature is on or off
-          enables the First row is header line … option in Data Sheet Special Settings – dialogue
Use Static Pivot Filters (use this with care)
-          if enabled it prevents the dynamic usage of Pivot
Date formats
-          general setting can be used if dates are not formatted correctly in import
Decimal format
-          general setting can be used if decimals are not handled correctly in import
The Data Sheet Special Settings dialogue, Figure 44, can be opened from the dialogue launcher shown in Figure 63. (The little arrow in the right lower corner of the Report additional setting menu area).
 
Dialogue launcher.
 

The contents of 3.3 Report additional settings group

3.3.1 About PivotTables