- New feature: Added function XLS FORMULAPREFIX, DESCRIBE DATABASE.
- New feature: Basic formula support in XLS export.
Example usage of the FORMULAPREFIX function
- Code: Select all
XLS FORMULAPREFIX ==;
XLS CREATE "C:\Output.xls";
SELECT Sum(UsedItems) Used_Items, Sum(NewItems) New_Items, '=="A%row%+B%row%","0"' Total_Items, '=="A%row%/C%row%","0%"' Percentage_Used
FROM Stock;
XLS CLOSE;
Download from the Mattic website.
