Are you planning to add a cell formula?

Open psxbox opened this issue 3 years ago • 1 comments

Excel Type

[x] XLSX
[ ] XLSM
[ ] CSV
[ ] OTHER

Description

May 15 '22 13:05 psxbox

Yes, MiniExcel has plan to do it, but it needs to change the code style

May 16 '22 03:05 shps951023

To anyone who tries hard using formulas like I'm doing right now: The solution is to use more complex excel formulas (basically just referencing rows in-fly - i.e. 'sum of all rows above me') For example this formula works: =SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN()))) (from: https://superuser.com/questions/661847/in-excel-how-can-i-sum-all-the-numbers-above-the-current-cell)

Feb 21 '23 20:02 anteeek