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

2014-01-05 Thread John R. Sowden
On 01/04/2014 08:12 PM, Brian Barker wrote: 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

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

2014-01-05 Thread Italo Vignoli
Do you call the absolute dependence on developers' powertrips and their uncontestable decisions 'freedom'? I have bad news for you then. In my opinion they have not done anything new, better, more elegant, than rebuilding things that already exist, and even doing so was not always a success.

[libreoffice-users] Calc: chart sent to background, how to select it?

2014-01-05 Thread Lorenzo
Dear all, I sent a chart to the background in calc and now there’s no way to select it to bring it back to front. I tried to select it with the navigator but I don’t get to select it anyway (maybe I did something wrong). Any help would be appreciated Thanks Lorenzo -- To unsubscribe e-mail

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

2014-01-05 Thread Regina Henschel
Hi, Paul schrieb: 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 the specification allows a cuboid reference. Therefore it is a bug, or at least a missing feature. For AOO the issue is

Re: [libreoffice-users] Calc: chart sent to background, how to select it?

2014-01-05 Thread Regina Henschel
Hi Lorenzo, Lorenzo schrieb: Dear all, I sent a chart to the background in calc and now there’s no way to select it to bring it back to front. I tried to select it with the navigator but I don’t get to select it anyway (maybe I did something wrong). Any help would be appreciated You have to

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

2014-01-05 Thread t...@weberpafrica.com
Hi Luuk, You state that there are more than 59000 bugs in the bugzilla, but you do not state how many open bugs there are on Microsoft office. The reason is that neither of us know how many there are as MS office is not developed in the open as LibreOffice is. This is not just an insignificant

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

2014-01-05 Thread Ryan Ashley
Exactly. All of the functions that I use seem to work across sheets, except AVERAGEIF and COUNTIF. I will look into filing a bug report. For now, is there any way to get the average of cell H35 across all of my sheets without adding other sheets or modifying my layout? I will have people using

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

2014-01-05 Thread P NIKOLIC
On Sat, 4 Jan 2014 22:45:57 +0700 Urmas davian...@gmail.com 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

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

2014-01-05 Thread Tom Davies
Hi :) Don't worry! We have known and intermittent Trolls here. I think pretty much everyone else knows the score and just follows the mantra don't feed the Trolls! I think almost everyone can see how hollow and brittle their arguments are = so we mostly just sit back and laugh at them. On the

[libreoffice-users] [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-05 Thread Larry Evans
In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data... the OK button remains disabled. How can I link to an existing database which was created with Libreoffice? My os infor is:

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

2014-01-05 Thread Brian Barker
At 11:35 05/01/2014 -0500, Ryan Ashley wrote: On 01/04/2014 08:12 PM, Brian Barker wrote: At 19:10 04/01/2014 -0500, Ryan Ashley wrote: Maybe someone else knows a way to do it using existing functions, ... Keep watching. At 21:38 04/01/2014 -0500, Ryan Ashley wrote: ... is there any

Re: [libreoffice-users] [calc] when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-05 Thread Brian Barker
At 11:32 05/01/2014 -0600, Larry Evans wrote: In calc, when I try to insert a link to: [...].odb from the InsertLink to external Data... the OK button remains disabled. The help text says you can link to a named range in an HTML, Calc, or Excel file - so apparently not to a database file.

[libreoffice-users] Re: Problem when copying to another sheet

2014-01-05 Thread TomD
Hi :) I got an email off-list and warped the data in the images just in case it's confidential. It gave me a chance to try out some of the weird filter effects in Gimps defaults. The op's problem is that the images inside the spreadsheet got displaced when he copied the worksheet to another

[libreoffice-users] Re: Problem when copying to another sheet

2014-01-05 Thread mariosv
Have you tried copying through right-click on the sheet tab: Move/Copy Sheet? Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Problem-when-copying-to-another-sheet-tp4089533p4090940.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-05 Thread mariosv
Please take a look to documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 10 Linking Calc Data Linking to registered data sources..18 Viewing data

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

2014-01-05 Thread Ryan Ashley
I read your solution, but do not want to alter any cells or add new ones as the spreadsheets are formatted to fit onto a single sheet of paper. I am going to test the solution using frequency right now. It looks perfect to me, but I won't know until I put some data into the sheets and see what