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 messag
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 (inst
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 "-"):
http://nabble.documentfoundation.org/file/n3023141/%23VALUE
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
c
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
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-B227>0,C227-B227,0), 0)
=IF(ISNUMBER(F227),IF(ISNUMBER(E227),IF(ISNUMBER(G227),IF(F227-E227-G227>0,F227-E227-G227,0),IF(F227-E227>0,F227-E227,0
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
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, th
Hi Jack
Jack wrote:
>
> See the formula in cell C2. Let me know whether or not you succeed.
>
It does work perfectly. In fact the formula was already working on my
spreadsheet (after I used your array trick).
I thought something was wrong because when I replaced all the text cells
with values
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
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 sho
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
rmat cells dialogue box in 3.3.2.
Regards from
Tom :)
- Original Message
> From: PLO
> 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 prholl
On 4 Jun 2011 at 6:26, prholland wrote:
Date sent: Sat, 4 Jun 2011 06:26:56 -0700 (PDT)
From: prholland
To: users@libreoffice.org
Subject:[libreoffice-users] Re: Calc: Has anyone tested
the backward-compatibility of
On 4 Jun 2011 at 6:06, plino wrote:
Date sent: Sat, 4 Jun 2011 06:06:55 -0700 (PDT)
From: plino
To: users@libreoffice.org
Subject:[libreoffice-users] Re: Calc: Has anyone tested
the backward-compatibility of
LibreOffice
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 "-"):
http://nabble.documen
2011/6/4 Regina Henschel :
> 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 "tex
Hi Johnny,
Johnny Rosenberg schrieb:
2011/6/4 Regina Henschel:
[..]
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 although the help saws it
w
2011/6/4 Regina Henschel :
> Hi Johnny,
>
> Johnny Rosenberg schrieb:
>>
>> 2011/6/4 Regina Henschel:
>
> [..]
>>>
>>> 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
- Original Message
> From: Johnny Rosenberg
> 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 :
> >
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 wo
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 ans
On Mon, Jun 6, 2011 at 3:40 PM, plino 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 before in OO
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
To
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 th
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 900
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
I
Stephan wrote:
> To get a more user friendly result, use the following formula:
>
> = IF(MIN(ISNUMBER(G4:H7)), "All values are numeric",
> ADDRESS(MIN(IF(ISNUMBER($G$4:$H$7), "All good", ROW($G$4:$H$7))),
> MIN(IF(ISNUMBER(OFFSET($G$4:$H$7,MIN(IF(ISNUMBER($G$4:$H$7), "All
> good", ROW($G$4:$H$7)))
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
To
0
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
33 matches
Mail list logo
