Giving LO another chance, and experimenting with toolbar placement on
the screen, basically moving them from the default horizontal position
at the top, to a vertical position the side.
Anyone know the reason(s) for replacing the actual field boxes that give
you the name of the style, font,
Hi,
Entering a formula into the Function Wizard in Calc shows up two
different answers in the 'Result' and 'Function Result' answer box.
If the editing cursor is placed in a certain section of the formula,
only the 'Function Result' answer box holds the correct answer i.e.
751.52004.
At 19:11 10/10/2013 +0200, Hylton Conacher wrote:
I have a spreadsheet with four pricing ranges for a certain number of units.
G4 = 601
H4 = calculated by below formula = 751.25 but should be 751.52
.
F20 = 1.25
G20 = 150 i.e. 0-150 units
h20 = F*G
I20 = 1.25
J20 = 200 i.e. 150.0001 - 350
Hylton,
If you can breakup the formula into smaller units you might find the
problem.
Often when I have had a similar problem I found the my problem
was I reversed test in an IF clause.
On Sat, 2013-10-19 at 14:36 +0200, Hylton Conacher (ZR1HPC) wrote:
Hi,
Entering a formula into the
Hi,
Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit :
The initial formula is:
At 19:11 10/10/2013 +0200, Hylton Conacher wrote:
The below formula calculates H4
=IF(0G4=$G$20, ...
Just to add to what I wrote before, if you want to test a condition
that you would write mathematically as ABC, you need to use
AND(AB;BC) instead.
Brian Barker
--
To unsubscribe e-mail
At 14:36 19/10/2013 +0200, Hylton Conacher wrote:
Entering a formula into the Function Wizard in Calc shows up two
different answers in the 'Result' and 'Function Result' answer box.
Certainly: there would otherwise be no point in having two
boxes. Suppose you use the Function Wizard to
Hi All,
These 10 bugs are the oldest bugs that are lingering for triaging,
please take a moment and see if you have the skills/setup required to
triage them. Please triage directly on the bug (not via email), mark as
NEW and leave a comment if you can confirm, if you cannot confirm
(behavior
On Sat, 19 Oct 2013 15:46:56 +0100
Brian Barker b.m.bar...@btinternet.com wrote:
o Remember that multiplication precedes addition and subtraction in
evaluation, so many of your parenthesis pairs are unnecessary. You
may think they clarify things, but in my experience they obfuscate
the
Hi snowshed
snowshed wrote
Giving LO another chance, and experimenting with toolbar placement on
the screen, basically moving them from the default horizontal position
at the top, to a vertical position the side.
Since you are running a 4.1 version why don't you try the Sidebar?
Go to
As I noticed you're practically around the corner from me, I got
interested, and had a look at your spreadsheet :)
[tl;dr: I got solutions, but need some help uploading the file. Also,
it may be that you could work it out in a *much* simpler way, using
what you already have, but a) something is
Hello,
I've received this .rtf file (attachment) with a little picture on the left
side that i can't see with Libre Office. I'm using Ubuntu because I hate
Microsoft and all their products :) ... So, in conclusion, my friend (on
Microsoft Office Word) opened this file and the picture was here.
On 10/19/2013 04:43 AM, Patrick wrote:
Hello,
I've received this .rtf file (attachment) with a little picture on the left
side that i can't see with Libre Office. I'm using Ubuntu because I hate
Microsoft and all their products :) ... So, in conclusion, my friend (on
Microsoft Office
13 matches
Mail list logo