[libreoffice-users] Re: Calc: Search & Replace Within A Column

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 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.
>
> Thanks, Andreas,
>
> Rich

So you don't have any spreadsheet document. You are talking about a 
plain text file. Right?
Loading plain text tables (csv) into spreadsheet is a very common, 
nevertheless bad idea, particularly when you do not know anything about 
spreadsheets.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted