Change Data Type of Key Cell
Auto Numbering for Key Cell of Date or Number
Select "@@" from tblDummy
Default Value of Date and Time
Today – Displays the current date, e.g. : 2017/4/19;
Today1, Today2, … Today1 – display the next day’s date, Today2 display the next next day’s and so on …;
Now – Displays the current date and time, e.g. : 2017/4/19 PM 05:57:04;
FullTime – Displays the current time in full format, e.g : PM 05:57:04;
Time – Displays the current time with hours and minutes only, e.g. : 17:57
Tabs for Label Cells
Working with Decimal Comma
Improvements of User Interface
Previously, when a cell has not defined with any Input Box, cell focus cannot be stayed on the cell no matter you are mouse clicking it or using keyboard “Enter” to shift to the cell. The focus will always jump to the next available cell. Now, you can stay on a cell with no definition of Input Box. Although you cannot edit the cell data when no input box is defined, you can add display formula to the cell for related data referencing. If you really want to jump across the cell without stopping by, select “Jump” in Input Box of the cell.
In “Column” of Input Pane’s Properties of Worksheet Setting, input text box can now scroll normally as its whole grid is scrolling.
The width of input text box changes and follows its column’s width as the column width is changed by mouse dragging.
In the previous version, when a record entry is saved and the cell value of a filtering field is different from the current value in the filter box, the filter box value will be replaced by the cell value. This action is not appropriate and is removed now.
Previously, when a value is being entered in a multiple value cell and the cell being entered is scrolled out of its grid, and the record entry is then saved, the value cannot be updated to the saved record entry. It is now corrected.
Before that, if the word “Select” appears in the description portion of a display formula, it will be mistook as the start of the formula portion. It is rectified now and you can freely write any words in the description portion.
Two short-names are added in worksheet setting making it more convenient when calling these settings:
Validation – Rule Checking Before Saving Record Entry
Previously, a record entry displayed in Input Pane but not shown in List View cannot be deleted. Now, you can do so.
Disintegration of Records
Insert into f2 (DocNo, A, B) Select "TxtSearch", 'f1.A', "Item A" from tblWeekD where Diff>0 and Diff< =val('f1.B')
Delete * from f2 where DocNo="TxtSearch"