| View previous topic :: View next topic |
| Author |
Message |
andrew
Sentinel
Joined: Mar 15, 2005
Posts: 20
|
 Posted: Thu Apr 21, 2005 11:11 pm Post subject: NeoOffice J 1.1 release and spreadsheet |
|
Dear All,
Trying to use the spread sheet to calculate a number of figures.
Unable to show the currency of the figures and to show the result of the addition/subtraction etc. The cell only shows the formula.
Am I missing something. Looked the defaults and options.
Andrew
lost in china [/img] |
|
| Back to top |
|
 |
ovvldc
Captain Naiobi
Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH
|
| Posted: Fri Apr 22, 2005 12:18 am Post subject: Re: NeoOffice J 1.1 release and spreadsheet |
|
| andrew wrote: | Dear All,
Trying to use the spread sheet to calculate a number of figures.
Unable to show the currency of the figures and to show the result of the addition/subtraction etc. The cell only shows the formula.
Am I missing something. Looked the defaults and options.
Andrew
lost in china |
Have you tried looking at cell formatting? if that is on text, the formula will not be evaluated. Same for setting the currency.
_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi |
|
| Back to top |
|
|
jjmckenzie51
The Anomaly
Joined: Apr 01, 2005
Posts: 1055
Location: Southeastern Arizona
|
| Posted: Fri Apr 22, 2005 7:28 pm Post subject: Re: NeoOffice J 1.1 release and spreadsheet |
|
| andrew wrote: | Dear All,
Trying to use the spread sheet to calculate a number of figures.
Unable to show the currency of the figures and to show the result of the addition/subtraction etc. The cell only shows the formula.
Am I missing something. Looked the defaults and options.
Andrew
lost in china |
| ovvldc wrote: |
Have you tried looking at cell formatting? if that is on text, the formula will not be evaluated. Same for setting the currency. |
Actually, if you put a formula in a General formatted field, it will be evaluated. However, I recommend setting the cell's format to the desired type of data, be it numeric, currency or percentage. If you still see the formula and not data after changing the format, check the formula for errors such as '\' characters in the formula.
James |
|
| Back to top |
|
|
Sue
Agent
Joined: May 21, 2004
Posts: 19
Location: New Zealand
|
| Posted: Sat Apr 23, 2005 12:51 pm Post subject: |
|
If the Spreadsheet is still just showing the formulas rather than the result.
Go to Tools > Options > Spreadsheet > View > untick Formulas 
To change formatting go to Format > cells
Hope that helps.
_________________
Retired Mobile Kiwi.
G4. iBook with OSX Tiger & Neo Office. |
|
| Back to top |
|
|
andrew
Sentinel
Joined: Mar 15, 2005
Posts: 20
|
| Posted: Sun Apr 24, 2005 4:44 pm Post subject: |
|
Thank you for your replies.
I think I was not clear in my first entry.
Formatting the cells I clearly understand, whether date of currency, it is the sum function that appears to have me beat.
Yes I can show currency and dates however the sum function shows
"=SUM(E11:E12)"
rather than the total of the figures, when I save the document on the desktop,
however when I save the file as a pdf it shows the total rather than the formula.
Any ideas ?
Andrew
Lost in China |
|
| Back to top |
|
|
jjmckenzie51
The Anomaly
Joined: Apr 01, 2005
Posts: 1055
Location: Southeastern Arizona
|
| Posted: Sun Apr 24, 2005 5:21 pm Post subject: |
|
| andrew wrote: | Thank you for your replies.
I think I was not clear in my first entry.
Formatting the cells I clearly understand, whether date of currency, it is the sum function that appears to have me beat.
Yes I can show currency and dates however the sum function shows
"=SUM(E11:E12)"
rather than the total of the figures, when I save the document on the desktop,
however when I save the file as a pdf it shows the total rather than the formula.
Any ideas ?
Andrew
Lost in China |
Interesting as I use this for several reasons and I have not run into this to add rows containing currency, numeral and percentage. I save as both .sxc and .xls file formats and I don't get this result. Are you trying to print out the file? This I have not tried, yet, but can do if that is where you experience this problem.
James |
|
| Back to top |
|
|
|
