Re: [libreoffice-users] Re: Calc method to change whole column cell content

Hi :)
Yes, as it happens.  It would sweep up negatives in other columns and that
might be a bonus.  With a text-editor it's easier to remove the "s from
around numbers too.  A whole load of tidying-up can be done to convert
non-standardised Csv files into something that works better in Calc or
Excel or whatever.

Each of us has a different way of doing things and it's good to have such a
wide range of choices so that we can do things in a fairly comfortable,
or/and in a fairly familiar way or choose to learn new skills while doing
something.  OpenSource generally gives people freedom to choose their own
way of doing things, and that can be seen as a negative or a positive.
Regards from
Tom :)

On 14 Apr 2016 00:29, "Andreas Säger" <villeroy@t-online.de> wrote:

> Am 13.04.2016 um 12:32 schrieb Tom Davies:
> > Hi :)
> > CSV format can be easily edited in normal text-editors before opening in
> > Calc.  Sometimes its easier to use a simpler tool to do a part of the job
> > rather than use a complicated route in a heavier tool such as Calc.
> > Regards from
> > Tom :)
>
> Really? And how do you convert (£1,234.98) into -1234.98 in columns 3,
> 17 and 23 across thousands of rows using a text editor? Are YOU able to
> do this actually?
> Don't you think that checking "English(UK)" and "Interprete Special
> Numbers" is by far easier?
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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