Re: add formula to cell in openoffice spreadsheet

2020-08-09 Thread David Robley
A simple =D1*E1 placed in F1 should do what you want - assuming that D and E contain numbers, not text. You can check the type of content in cells using View | Value Highlighting or the keyboard shortcut Ctrl+F8. The formula can then be copied or dragged down as needed. Text cells are formatte

add formula to cell in openoffice spreadsheet

2020-08-09 Thread mick howe
been battling to use a simple formula in a spreadsheet to cause each cell 'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star Office on both OS/2 & various Linux versions and libreoffice until version 6

RE: tired of the crashes

2020-08-09 Thread Robert Funnell
On Sun, 9 Aug 2020, Brian Barker wrote: At 20:28 08/08/2020 -0400, Robert Funnell wrote: You should be able to set OpenOffice to save your document periodically. In LibreOffice this is under Tools > Options > Load/Save > General. I think it's similar in OpenOffice. As I mentioned only a few

RE: tired of the crashes

2020-08-09 Thread Brian Barker
At 20:28 08/08/2020 -0400, Robert Funnell wrote: You should be able to set OpenOffice to save your document periodically. In LibreOffice this is under Tools > Options > Load/Save > General. I think it's similar in OpenOffice. As I mentioned only a few weeks ago, useful though this facility is

Re: tired of the crashes

2020-08-09 Thread David Belina
Without knowing the detail of your system, it’s hard to tell but I suspect it is your memory settings.  On a Mac, open OO and check the memory setting under Preferences in the left-hand pane.  I have 20MB set for mine and I never crash.  Don’t know where the setting is on Windows/Linux. On Aug