This has been a most enlightening discussion.
I am a big fan of open source software. That said, this discussion has shined a
bright light on one of the most problematic areas of the concept.
I might be totally off base here but as I view it, without a central management
structure to _enforce_
Peter West
Where is he who has been born king of the Jews?
On 6 Jan 2014, at 6:11 pm, James E Lang jim+...@lang.hm wrote:
This has been a most enlightening discussion.
I am a big fan of open source software. That said, this discussion has shined
a bright light on one of the most
Hi :)
You guys are over-complicating it. Just post a feature request via
the bug-reporting system
Similar problems occur in proprietary systems too but with less chance
of reporting the problem. Also the bosses need to understand the
problem and give it more attention than their golf handicap
I wanted to reply and let everybody know that the workaround using
FREQUENCY works fine. The sheet is now out for users to test and will be
going through a few cosmetic changes, but it works. If you are curious,
the sheet is a vehicle mileage sheet for company vehicles, but I will be
using it
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
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
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
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
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
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
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
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
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
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
From: Brian Barker b.m.bar...@btinternet.com
Date:2014/01/04 23:12 (GMT-05:00)
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF
and AVERAGEIF...
At 19:10 04/01/2014 -0500, Ryan Ashley wrote:
I have developed a spreadsheet which
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
16 matches
Mail list logo