At 15:43 26/05/2012 +0200, Miguel Angel wrote:
El 26/05/12 12:41, Brian Barker escribió:
At 17:14 25/05/2012 +0200, Miguel Angel wrote:
Maybe the mistake is in search for 0.000, it
can't be found, because a 0.000 is always
saved as 0, nonsignificant zeroes to the
right/left of decimal point a
El 26/05/12 12:41, Brian Barker escribió:
At 17:14 25/05/2012 +0200, MiguelAngel wrote:
Maybe the mistake is in search for 0.000, it can't be found, because a
0.000 is always saved as 0, nonsignificant zeroes to the right/left of
decimal point are never saved.
Computers store numbers in a fixe
At 17:14 25/05/2012 +0200, MiguelAngel wrote:
Maybe the mistake is in search for 0.000, it can't be found, because
a 0.000 is always saved as 0, nonsignificant zeroes to the
right/left of decimal point are never saved.
Computers store numbers in a fixed-length format - however-many
bytes. So
Am 25.05.2012 15:14, Rich Shepard wrote:
On Fri, 25 May 2012, Andreas Säger wrote:
Turn on menu:View>Highlight Values [Ctrl+F8]. What is the font color
of X99? A blue color proves that X99 is a number. Text appears black.
Other than column A (site names), every other cell is blue.
I'm going
Am 25.05.2012 16:31, Rich Shepard wrote:
On Fri, 25 May 2012, Mirosław Zalewski wrote:
Can you post your document somewhere on the web? I think that there are
users who are just curious what's so special about your data that neither
of tips have worked for you.
Mirosław,
It's client data so
gards from
Tom :)
--- On Fri, 25/5/12, Mirosław Zalewski wrote:
From: Mirosław Zalewski
Subject: Re: [libreoffice-users] Re: Calc: Search & Replace Within A Column
To: users@global.libreoffice.org
Date: Friday, 25 May, 2012, 15:18
On 25/05/2012 at 15:14, Rich Shepard wrote:
> I
El 25/05/12 16:52, Rich Shepard escribió:
On Fri, 25 May 2012, Mirosław Zalewski wrote:
Sorry we could not solve your problem, then.
That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-)
Thanks to all for the suggesions,
Rich
Maybe the mistake is in search for 0.000, it
On Fri, 25 May 2012, Mirosław Zalewski wrote:
Sorry we could not solve your problem, then.
That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-)
Thanks to all for the suggesions,
Rich
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? h
On 25/05/2012 at 16:31, Rich Shepard wrote:
> It's client data so I cannot distribute it.
I was afraid that's the case.
Sorry we could not solve your problem, then.
--
Best regards
Mirosław Zalewski
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http
On Fri, 25 May 2012, Mirosław Zalewski wrote:
Can you post your document somewhere on the web? I think that there are
users who are just curious what's so special about your data that neither
of tips have worked for you.
Mirosław,
It's client data so I cannot distribute it.
Rich
--
For
On 25/05/2012 at 15:14, Rich Shepard wrote:
> I'm going to write an awk script that will change the zeros to the
> appropriate reporting limit. That'll be quicker than my trying to
> understand what's happening in Calc.
It may be.
Can you post your document somewhere on the web? I think that th
On Fri, 25 May 2012, Andreas Säger wrote:
Turn on menu:View>Highlight Values [Ctrl+F8]. What is the font color of X99?
A blue color proves that X99 is a number. Text appears black.
Other than column A (site names), every other cell is blue.
I'm going to write an awk script that will chang
Say X99 displays 0.005.
Turn on menu:View>Highlight Values [Ctrl+F8]. What is the font color of
X99? A blue color proves that X99 is a number. Text appears black.
Get some unused cell and enter
=X99=0.005
What is the result? Should be either TRUE or FALSE.
If FALSE, what is the result of
=X99-
13 matches
Mail list logo