Re: [libreoffice-users] changing currency in a spreadsheet

Den sön 24 apr. 2022 kl 23:35 skrev Dave Howorth <dave@howorth.org.uk>:

> I have a financial spreadsheet that was designed in the USA but I live
> in the UK. Is there any way in LO to change all the cells that are
> formatted as numeric $ amounts to be the same format but using the
> equivalent numeric £ format instead?
>
> I don't think there's any logic in the spreadsheet that depends on the
> currency, it's just doing numerical calculations on the values. But it
> would be easier to look at if it was in £ rather than $ everywhere!
>
> Cheers, Dave

If you are lucky (probably not, but let's give it a go, at least), your
spreadsheet was done properly to begin with. That means that styles were
used properly, so in every cell where a currency is used, they used the
same style. If so, then just find out which style that is and change the
currency format in that style, and BAM, all of your currency cells are
corrected at once!

THIS is why you should use styles. If you don't, start doing it now. It's
maybe a bit slower in the beginning, but you don't have to setup your
styles that thoroughly immediately, you can do that later, just make sure
that every cell that is formatted differently is using a style for that.
Then you can always modify that style later and affect thousands of cells
spread over a whole lot of sheets (within that file, of course) at once.
Very, very useful, I can't stress that enough.

So, let's say that the creator of your document didn't care about styles,
which probably is the case. Then highlight all cells with currency (you can
highlight whole columns with just one click and you can highlight more than
one column at a time using the shift key while clicking a column and so
on), hit Ctrl+m to strip all those cells from any kind of formatting
(except conditional formatting, I think, but not sure about that) and then
apply a style to them. Don't forget to name that style properly if you
create a new one, making it easier for you in the future to figure out what
the heck you were doing all those years ago.

Then you can easily modify that style as you wish and you can play with
that forever if you want to. Maybe tomorrow you want all currencies to be
in a smaller font. Well, edit that style again, pick a smaller font, and
BAM, thousands of cells are immediately affected. If you want to apply that
style to more cells, just select those cells and click that style.


Kind regards

Johnny Rosenberg


> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy