I'm looking for some help in debugging an issue that I've had since LO
5.4 on Mac. (I've been using LO since it forked.) I'm now running LO
6.3alpha
When I attempt to link a cell in one spreadsheet to another, the linking
action using "=spreadsheet/cell location" transposes the link
I have all my spreadsheets set up the same way. They use about half the
vertical screen. Every time a new update comes along, the cell spacing
gets slightly changed. This means part of the next cell appears at the
bottom of the sheet or when I move to the bottom cell it spaces up one
when
On 19/10/13 16:46, Brian Barker wrote:
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 =
At 16:55 21/10/2013 +0200, Hylton Conacher wrote:
On 19/10/13 16:46, Brian Barker wrote:
To get the best help from others, you really do need to explain
your problem in detail - and that means words, not formulae or
values. Once you have defined your problem, it is very likely
someone can
At 23:45 19/10/2013 +0200, Paul Steyn wrote:
On Sat, 19 Oct 2013 15:46:56 +0100 Brian Barker wrote:
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
At 21:01 20/10/2013 +0200, Paul Steyn wrote:
http://en.wikipedia.org/wiki/Order_of_operations lists a couple of
exception cases.
Interesting! Thanks.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Le 20/10/2013 21:01, Paul a écrit :
On Sun, 20 Oct 2013 18:10:32 +0100
Brian Barker b.m.bar...@btinternet.com wrote:
Chacun à son goût, of course.
Exactly.
The actual expression is: des goûts et des couleurs [ça ne se discute pas]
literal EN: Tastes and colours [that's not debatable]
:-)
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
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
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,
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 units
K20 = I*J
L20 = 1.25
M20 = 250 i.e.
Hi,
Am 10.10.2013 19:11, schrieb Hylton Conacher (ZR1HPC):
Where am I making a mistake?
Don´t use multiple nested IF-functions. Use the VLOOKUP-function!
Get yourself Calc User Guide, Chapter 13:
https://wiki.documentfoundation.org/images/5/53/CG4013-CalcAsASimpleDatabase.pdf
and look for
Hi.
Brian Barker gave a very succint method to do this in a previous discussion.
You can search this list in Nabble
http://nabble.documentfoundation.org/Users-f1639498.html
Search VLOOKUP
Steve
On 2013-10-11 06:11, Hylton Conacher (ZR1HPC) wrote:
Hi,
I have a spreadsheet with four pricing
Hello
Not sure if I'm doing something wrong, if theres a setting I haven't set or
I've found a bug
Libreoffice Calc
Program settings are OptionsLanguage SettingsLanguages
User interface 'English (uk)'
Date acceptance patterns 'D/M/Y;D/M;D-M'
And the problem is
In a cell (CF3) I have the date
On 2013-08-20 11:20, IGraham wrote:
Hello
Not sure if I'm doing something wrong, if theres a setting I haven't set or
I've found a bug
Libreoffice Calc
Program settings are OptionsLanguage SettingsLanguages
User interface 'English (uk)'
Date acceptance patterns 'D/M/Y;D/M;D-M'
And the
At 16:20 19/08/2013 -0700, Graham Lovatt wrote:
Not sure if I'm doing something wrong, if there's a setting I
haven't set or I've found a bug
I fear you are doing something wrong!
Libreoffice Calc
Program settings are OptionsLanguage SettingsLanguages
User interface 'English (uk)'
Date
16 matches
Mail list logo