DataWindow has the following enhancements:
-
DataWindow SaveDisplayedDataAs method
Saves the display values of the DataWindow in the specified format: SaveDisplayedDataAs.
What's supported by this function:
-
Saving data in a Text, CSV, or Excel file.
-
Saving the display value of the Edit column according to the format setting.
-
Saving Text, Column and Computed Field objects.
-
Saving the display values of the DDLB, DDDW, RadioButton, and EditMask into the file.
-
Support Grid, Tabular, FreeForm, CrossTab, N-up, Group, TreeView DataWindows.
-
Saving data of the band layer (and does not support saving the data of the Foreground and Background layers.
Limitations:
-
Does not support Composite, Graph, OLE, RichText, and Label styles in DataWindow.
-
Does not support saving graphical objects such as Button, Picture, GroupBox, Line, etc.
-
Does not support saving Font attributes, including FaceName, Size, Color, Bold, etc.
-
The width of cells in Excel may not match the width of columns in the DataWindow.
-
Due to differences between Excel and DataWindow, for non-Grid style DataWindows, if objects are not aligned properly, the content may be misaligned when saved to Excel.
-
When object heights vary significantly, blank rows may appear in the data when saved to Excel.
-
If the visible property of the object is set via the expression, the visibility of the first row in that column will determine whether the data in the other rows is saved. Specifically, if the first row is set to visible, the subsequent rows will also be saved; if it is not visible, the other rows will not be saved either.
-
-
DataWindow update properties
The settings in the Specify Update Properties window may be removed if you change an updatable table via DataWindow SQLs for a multi-table DataWindow.
This behavior has been rectified in Version 2025, for example, if you change a table via SQLs (such as adding, deleting, or modifying a column which causes the update properties to change), the settings in the associated Specify Update Properties window will be retained and the column changes (as well as the key column changes, table name changes, if any) will also be reflected in the window.
