plino wrote:
I thought something was wrong because when I replaced all the text cells
with values I got a 0 (zero). I incorrectly assumed it would show All Good
but that was not possible since the final function was MIN :)
Yeah, sorry about that. After I posted the formula, I realised that
Michael D. Setzer II wrote:
Was interested if it could be modified for multi-column searches.
Did a same test using H2:I5 and used this formula.
= SMALL((IF(ISNUMBER($H$2:$I$5), ALL
GOOD,COLUMN($H$2:$I$5)*1000+ROW($H$2:$I$5))), 1)
That returns the number 8004 and 2nd one returns 9005.
Then
plino wrote:
I hope this will also contribute for the array bug to be fixed since I
reported it on the bug tracker...
Just for reference (if anyone is curious), the bug is:
https://bugs.freedesktop.org/show_bug.cgi?id=38014
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In
Hi Stephan
I will test this one later. With don't you simply name the range Jack?
It's much easier to use and modify ;)
I think that there is no need to know the second, third, etc text celss. You
only need to know the first error to go there and fix it. One error at a
time :)
Thanks!
--
View
On 8 Jun 2011 at 10:37, Stephan Zietsman wrote:
Date sent: Wed, 8 Jun 2011 10:37:07 +0200
Subject:Re: [libreoffice-users] Re: Calc: Has anyone
tested the
backward-compatibility of LibreOffice 3.4?
From: Stephan Zietsman szi...@gmail.com
Subject:Re: [libreoffice-users] Re: Calc: Has anyone
tested the
backward-compatibility of LibreOffice 3.4?
Priority: normal
Send reply to: users@libreoffice.org
On 8 Jun 2011 at 10:37, Stephan Zietsman wrote:
Date sent:Wed, 8 Jun 2011 10
plino wrote:
I couldn't make it work. In fact I just found out that array functions
don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta)
Hey plino,
array formulas in LibO/OOo are a little tricky (little more so than in
Excel). If you've entered the formula correctly and pressed ENTER
Jack wrote:
array formulas in LibO/OOo are a little tricky (little more so than in
Excel). If you've entered the formula correctly and pressed ENTER
(instead of CTRL+SHIFT+ENTER), then obviously it does not work. If you
then select the cell/formula again and press CTRL+SHIFT+ENTER, then
plino wrote:
Even with the array working it's not detecting non-numeric cells properly.
Can you upload your spreadsheet somewhere so I can see what I'm doing wrong?
Hi plino,
sure, the upload link is:
http://www.2shared.com/file/WuzUYsyS/FindNonNumeric.html
See the formula in cell C2. Let me
On 7 Jun 2011 at 11:47, Stephan Zietsman wrote:
Date sent: Tue, 7 Jun 2011 11:47:25 +0200
Subject:Re: [libreoffice-users] Re: Calc: Has anyone
tested the
backward-compatibility of LibreOffice 3.4?
From: Stephan Zietsman szi...@gmail.com
plino wrote:
But as you said, I really don't want to browse 300.000 lines to spot
errors ;)
Hi plino,
for your specific case I might have a possible workaround. The following
formula (place it in any cell) would give you the row number for the first
non-numeric value in the range A1:A3.
Hi Jack
I couldn't make it work. In fact I just found out that array functions don't
work in Lib (3.3 or 3.4) nor in OOo (3.4 beta)
I don't know if it ever worked (I use it every now and then, so I couldn't
say if I used it before in OOo/LO) but if it did, someone broke it :)
Another bug to fix
On Mon, Jun 6, 2011 at 3:40 PM, plino pedl...@gmail.com wrote:
Hi Jack
I couldn't make it work. In fact I just found out that array functions
don't
work in Lib (3.3 or 3.4) nor in OOo (3.4 beta)
I don't know if it ever worked (I use it every now and then, so I couldn't
say if I used it
Hello Tom,
On Sat, 4 Jun 2011 15:22:50 +0100 (BST) (your time) you said:
... i played around with Format Cells. I couldn't get an ideal answer
that shows a - even when the cell is empty but i could get one when the
cell has 0 value.
Well, too much time later and I haven't been able to work
:01
Subject: Re: [libreoffice-users] Re: Calc: Has anyone tested the
backward-compatibility of LibreOffice 3.4?
Hello Tom,
On Sat, 4 Jun 2011 15:22:50 +0100 (BST) (your time) you said:
... i played around with Format Cells. I couldn't get an ideal answer
that shows a - even when
I have a solution to the specific problem, based on Michael D. Setzer II's
suggestion (see below):
=IF(AND(ISNUMBER(C227), ISNUMBER(B227)),IF(C227-B2270,C227-B227,0), 0)
It must be a new feature :)
I advise you to test 3.3 RC1 and update to 3.3 when it is released. Version
3.4 is not ready for real work as stated in the release announcement
http://nabble.documentfoundation.org/The-Document-Foundation-announces-LibreOffice-3-4-0-tt3019206.html
--
View this
Actually I had never noticed that spreadsheets (all including Excel) ignore
text values mixed with numbers. This worries me a lot!
I work with 300.000+ line spreadsheets and if one line has a text value
(because of a typo) I wouldn't notice that.
Is there any setting that triggers a warning
The following screenshot is taken from a spreadsheet that previously showed
00:00 in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
#VALUE! (NB: all the cells are formatted as Time values, and the text
cells contain -):
, 2011 14:26:56
Subject: [libreoffice-users] Re: Calc: Has anyone tested the
backward-compatibility of LibreOffice 3.4?
The following screenshot is taken from a spreadsheet that previously showed
00:00 in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
#VALUE! (NB: all the cells
Hello prholland,
On Sat, 4 Jun 2011 06:26:56 -0700 (PDT) (your time) you said:
The following screenshot is taken from a spreadsheet that previously showed
00:00 in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
#VALUE! (NB: all the cells are formatted as Time values, and the text
:)
- Original Message
From: PLO protect.libreoff...@inboxshield.co.uk
To: users@libreoffice.org
Sent: Sat, 4 June, 2011 14:58:49
Subject: Re: [libreoffice-users] Re: Calc: Has anyone tested the
backward-compatibility of LibreOffice 3.4?
Hello prholland,
On Sat, 4 Jun 2011 06:26:56 -0700 (PDT
On 4 Jun 2011 at 6:06, plino wrote:
Date sent: Sat, 4 Jun 2011 06:06:55 -0700 (PDT)
From: plino pedl...@gmail.com
To: users@libreoffice.org
Subject:[libreoffice-users] Re: Calc: Has anyone tested
the backward-compatibility
Hi prholland,
prholland schrieb:
The following screenshot is taken from a spreadsheet that previously showed
00:00 in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
#VALUE! (NB: all the cells are formatted as Time values, and the text
cells contain -):
Michael D. Setzer II wrote:
If you use count on a range it only counts numeric cells, but
counta counts numeric and non-empty cells, so if they don't give
the same results for the same range, there is an error?
Yes, that would work but it forces me to do this verification for each
Brian Barker wrote:
One useful facility in this case is Value Highlighting. Go to View |
Value Highlighting or press Ctrl+F8. The font colour for text
(temporarily) becomes black, for numbers and other values blue, and
for formulae green. (Formulae should be no problem, since it's
2011/6/4 Regina Henschel rb.hensc...@t-online.de:
Hi prholland,
prholland schrieb:
The following screenshot is taken from a spreadsheet that previously
showed
00:00 in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
#VALUE! (NB: all the cells are formatted as Time values, and the
Hi Johnny,
Johnny Rosenberg schrieb:
2011/6/4 Regina Henschelrb.hensc...@t-online.de:
[..]
In OOo this can be done by the function N. Unfortunately the spec makes it
implemention defined what N does with text. In OOo N returns 0 for text,
which I think is useful. In LO it returns #VALUE
2011/6/4 Regina Henschel rb.hensc...@t-online.de:
Hi Johnny,
Johnny Rosenberg schrieb:
2011/6/4 Regina Henschelrb.hensc...@t-online.de:
[..]
In OOo this can be done by the function N. Unfortunately the spec makes
it
implemention defined what N does with text. In OOo N returns 0 for
- Original Message
From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@libreoffice.org
Sent: Sat, 4 June, 2011 20:27:51
Subject: Re: [libreoffice-users] Re: Calc: Has anyone tested the
backward-compatibility of LibreOffice 3.4?
2011/6/4 Regina Henschel rb.hensc...@t
30 matches
Mail list logo