How to disable subset header texts in Statistica spreadsheets?
Article ID: KB0075801
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.5 and higher |
Description
When running a subset analysis on a dataset in Statistica, the resulting Statistica spreadsheet's header can be displayed as a summary of these subset actions. See example header of a Statistica spreadsheet below which shows this summary displaying as the header of the spreadsheet:
Can this be disabled?
Can this be disabled?
Issue/Introduction
This article details how you can turn off the summary of actions that displays as a header for Statistica Spreadsheets
Resolution
Yes, changes can be made to the DefOpts.xml file which will remove this summary from the header of the Statistica spreadsheet. For more information on DefOpts.xml file and how to make changes to this file, see here: https://support.tibco.com/s/article/How-to-propagate-Statistica-options-with-StatOpts-xml-and-DefOpts-xml
The default DefOpts.xml file will appear similar to the following:
<?xml version="1.0" encoding="utf-8" ?> <StatOpts ActiveConfig="Initial"> <Initial> <Edit SubsetThreadScalar="2" SubsetThreading="0" DefaultMissingDataVaue="-9999" ID_ENTRY_EXPORTHTML_SHOW_WARN="0" ExportXLS_IncludeFormatting="1" MaxAutoFitRows="12" MaxAutoFitCols="12" AutofitOnUpdateView="0"> <FontsOpt /> <RUFonts /> </Edit> <General ID_ENTRY_MAIN_VERSIONNUMBER="13.0.0.0.1033" UseRibbonBar="0" AskSaveProject="0" LoadLastFile="2" SuppressReadOnlyWarning="0" WarningAppEvent="0" WarningDocEvent="0" /> <Server Enabled="1" /> <Graphics UseAdvancedDrawing="0" /> <Macros> <MacroReferences Archive="2,64,3,mATTTTOTTTTTtyrN7F9FWQ91WvWHARZHbNZFAS96WF9NvjWHdYkFA4KFR1jFZ79CRAxWTOIBgFKM7B9MmT9HbHZ1jK96nAZ1jjPME4AFbTZHZRZFE7AHA8ZFmjVTRhTT" /> </Macros> <Workbook WorkbookCompressGraphsAndReports="1" /> </Initial> </StatOpts> To remove the header summary from the spreadsheets, add the following (in red): <?xml version="1.0" encoding="utf-8" ?> <StatOpts ActiveConfig="Initial"> <Initial> <Edit SubsetThreadScalar="2" SubsetThreading="0" DefaultMissingDataVaue="-9999" ID_ENTRY_EXPORTHTML_SHOW_WARN="0" ExportXLS_IncludeFormatting="1" MaxAutoFitRows="12" MaxAutoFitCols="12" AutofitOnUpdateView="0" SubsetsIncludeSourceInfo="0"> <FontsOpt /> <RUFonts /> </Edit> <General ID_ENTRY_MAIN_VERSIONNUMBER="13.0.0.0.1033" UseRibbonBar="0" AskSaveProject="0" LoadLastFile="2" SuppressReadOnlyWarning="0" WarningAppEvent="0" WarningDocEvent="0" /> <Server Enabled="1" /> <Graphics UseAdvancedDrawing="0" /> <Macros> <MacroReferences Archive="2,64,3,mATTTTOTTTTTtyrN7F9FWQ91WvWHARZHbNZFAS96WF9NvjWHdYkFA4KFR1jFZ79CRAxWTOIBgFKM7B9MmT9HbHZ1jK96nAZ1jjPME4AFbTZHZRZFE7AHA8ZFmjVTRhTT" /> </Macros> <Workbook WorkbookCompressGraphsAndReports="1" /> </Initial> </StatOpts>
This addition to the DefOpts.xml file will remove summary as a header in Statistica Spreadsheets.
Additional Information
Feedback
Yes
No
Powered by
