I have a LibreOffice Calc spreadsheet that's basically like below. In Foxpro I can say sum Amount for Category = a to Income Then sum Amount for Category = b to Expense Then I say Balance = Income - Expense And lastly I say ? Balance and that shows the balance The ? means print to screen. Is there a simple way to achieve the same thing in LibreOffice Calc? In Foxpro I can create a text file with those commands exactly as I've written them and then just run the file anytime I want the balance. Foxpro doesn't run on Windows 10, it's a 16 bit program and I've experimented extensively trying to make it run without success. |