@Petr I'm not asking for it to be able to save to Excel file formats, but the core functionality of a programmable data grid that supports the clipboard functions, formulas with basic math operations (add, subtract, multiply, divide) and concatenate string data, Excel-like cell references like A1 or $A$1, ability to format a cell (# of decimal places for numbers, choose date format, etc.), and for anything more complex, call a built in or custom QB64PE function, which could receive a value or a cell address (or range of cell addresses) to operate on. For example a SUM function such as =SUM(A2:A5). Bonus if you can define named ranges and double bonus if you can define a dropdown control in a cell that pulls its values from a given range of cells on a given sheet.
I get that it's a tall order but beyond being a poor man's spreadsheet, there is value in this being a reusable programmable datagrid type control in your own QB64 programs.
I get that it's a tall order but beyond being a poor man's spreadsheet, there is value in this being a reusable programmable datagrid type control in your own QB64 programs.
