Re: [libreoffice-users] Re: Libre Icons in Ubuntu disappear after loading file

2014-01-04 Thread Tom Davies
Hi :) I think the best policy right now is to sitwait to see if anyone else reports this problem in the near future. If they do we might be able to get enough information to make a bug-report then. I have had a similar case on Windows 7 when attempting to install MS Office 2010. We had wanted

[libreoffice-users] Re: [tdf-discuss] Re: Start 2014 with Freedom, Adopt LibreOffice in your life!

2014-01-04 Thread Terrence Enger
On Sat, 2014-01-04 at 22:45 +0700, Urmas wrote: Vitorio Furusho - LibreOffice: Start 2014 with Freedom, Adopt LibreOffice in your life! Do you call the absolute dependence on developers' powertrips and their uncontestable decisions 'freedom'? I have bad news for you then. I do see freedom

Re: [libreoffice-users] Ask

2014-01-04 Thread e-letter
On 03/01/2014, Paweł Piliszek p...@poliamid.com.pl wrote: Hello everybody, Mr Florian Effenberger advice me to write on this e-mail address so here I am:) I have a question about possibility to improve into Libre Office something what is called waterfall plot (In QtiPlot program). It is a

Re: [libreoffice-users] Re: Start 2014 with Freedom, Adopt LibreOffice in your life!

2014-01-04 Thread yahoo-pier_andreit
On 01/04/2014 04:45 PM, Urmas wrote: Vitorio Furusho - LibreOffice: Start 2014 with Freedom, Adopt LibreOffice in your life! Do you call the absolute dependence on developers' powertrips and their uncontestable decisions 'freedom'? I have bad news for you then. do you call the absolute

Re: [libreoffice-users] Re: [tdf-discuss] Re: Start 2014 with Freedom, Adopt LibreOffice in your life!

2014-01-04 Thread Doug
On 01/04/2014 11:21 AM, Terrence Enger wrote: On Sat, 2014-01-04 at 22:45 +0700, Urmas wrote: Vitorio Furusho - LibreOffice: Start 2014 with Freedom, Adopt LibreOffice in your life! Do you call the absolute dependence on developers' powertrips and their uncontestable decisions 'freedom'? I

Re: [libreoffice-users] Re: [tdf-discuss] Re: Start 2014 with Freedom, Adopt LibreOffice in your life!

2014-01-04 Thread Don C. Myers
On 01/04/2014 04:48 PM, Doug wrote: On 01/04/2014 11:21 AM, Terrence Enger wrote: On Sat, 2014-01-04 at 22:45 +0700, Urmas wrote: Vitorio Furusho - LibreOffice: Start 2014 with Freedom, Adopt LibreOffice in your life! Do you call the absolute dependence on developers' powertrips and their

[libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Ryan Ashley
I have developed a spreadsheet which contains a sheet for the cover and basic information as well as one sheet for every month. There is a cell with a number on every sheet at location H35. I want the average of all of those which are not zero on the first sheet. I initially tried using

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Paul
One way would be to add a second cell to each sheet, say H36, that has a simple IF(H530,1,0), then on the cover sheet your formula could be something like =(January.H35+Fenruary.H35+...)/(January.H36+February.H36+...). Of course you would need to type in all the actual cell references instead of

Re: [libreoffice-users] Ask

2014-01-04 Thread Tom Davies
Hi :) I hadn't thought of that. Part of the advantage of using LibreOffice is that it's designed to be 1 part of a jigsaw puzzle rather than being a massively monstrous programs that tries to do everything but does it all badly. LibreOffice tends to co-operate with a wide range of other programs

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Ryan Ashley
Well I have designed the sheets to be printed at the end of each year, so extra cells would not work. I do know Basic (I started my coding career using Basic on an Atari 400 in 1986) but would much rather use the built-in functions of Calc. Is there a reason that AVERAGEIF and COUNTIF will not

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Paul
Well, I *think* the issue is with using the functions on a range that is across worksheets. I don't think you can do that, but then again, I don't think you can do this in MSO either, but you seem to think that MSO can do this, so my assumption appears to be wrong, and as such might be wrong for

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Brian Barker
At 19:10 04/01/2014 -0500, Ryan Ashley wrote: I have developed a spreadsheet which contains a sheet for the cover and basic information as well as one sheet for every month. There is a cell with a number on every sheet at location H35. I want the average of all of those which are not zero on

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Ryan Ashley
All functions I tried worked cross-sheet except AVERAGEIF and COUNTIF, so I am assuming this is a bug. If AVERAGEIF would work this would be so simple. I am away from home right now but will send the formula tomorrow. Sent from my Verizon Wireless 4G LTE smartphone Original message

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

2014-01-04 Thread Hylton Conacher (ZR1HPC)
On 05/01/14 02:10, Ryan Ashley wrote: I have developed a spreadsheet which contains a sheet for the cover and basic information as well as one sheet for every month. There is a cell with a number on every sheet at location H35. I want the average of all of those which are not zero on the first