add formula to cell in openoffice spreadsheet

[mick howe <mi...@gmail.com>]

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.
When I try to do this, either on Linux or win10 I get either no result or
messages along the lines of #error=NAME?, #NAME=#508? or just no result.
I can't see any explanation when I search for the meaning of the error
messages
Even when I tried to open a sheet I did a couple of years ago with very
similar calculations in LibreOffice I experienced the same problems.
Please help, it is doing my head in.

mick in glen innes 2370

Re: add formula to cell in openoffice spreadsheet

[David Robley <ro...@gmail.com>]

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 formatted in black, formulas in green, and number cells 
in blue, no matter how their display is formatted.

Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html

As a courtesy I have sent a copy of this reply to you as well as to the 
mailing list. Do Not reply to me personally but just to the list at 
<us...@openoffice.apache.org> - replies to my personal email address 
will be ignored.

On 10/8/20 3:04 pm, mick howe wrote:
> 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.
> When I try to do this, either on Linux or win10 I get either no result or
> messages along the lines of #error=NAME?, #NAME=#508? or just no result.
> I can't see any explanation when I search for the meaning of the error
> messages
> Even when I tried to open a sheet I did a couple of years ago with very
> similar calculations in LibreOffice I experienced the same problems.
> Please help, it is doing my head in.
>
> mick in glen innes 2370
>

Cheers
-- 
David Robley

Remember, UNIX spelled backwards is XINU.