[libreoffice-users] Calc link problem on Mac

2019-05-22 Thread bunk3m
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

[libreoffice-users] calc/update problem

2015-08-22 Thread Robert Peirce
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

Re: [libreoffice-users] Calc IF problem

2013-10-21 Thread Hylton Conacher (ZR1HPC)
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 =

Re: [libreoffice-users] Calc IF problem

2013-10-21 Thread Brian Barker
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

Re: [libreoffice-users] Calc IF problem

2013-10-20 Thread Brian Barker
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

Re: [libreoffice-users] Calc IF problem

2013-10-20 Thread Brian Barker
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?

Re: [libreoffice-users] Calc IF problem

2013-10-20 Thread Jean-Francois Nifenecker
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] :-)

Re: [libreoffice-users] Calc IF problem

2013-10-19 Thread Brian Barker
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

Re: [libreoffice-users] Calc IF problem

2013-10-19 Thread Brian Barker
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

Re: [libreoffice-users] Calc IF problem

2013-10-19 Thread Paul
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

[libreoffice-users] Calc IF problem

2013-10-10 Thread Hylton Conacher (ZR1HPC)
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.

Re: [libreoffice-users] Calc IF problem

2013-10-10 Thread Stefan Weigel
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

Re: [libreoffice-users] Calc IF problem

2013-10-10 Thread Steve Edmonds
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

[libreoffice-users] Calc =MONTH problem

2013-08-19 Thread IGraham
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

Re: [libreoffice-users] Calc =MONTH problem

2013-08-19 Thread Steve Edmonds
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

Re: [libreoffice-users] Calc =MONTH problem

2013-08-19 Thread Brian Barker
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