Re: [libreoffice-users] Range names

Hi Johnny.
I came up against this issue last year after needing to open an excel
sheet in Calc.
Excel allows range names that Calc doesn't so the sheet wouldn't work. I
wanted to rename the offending excel ranges.
I couldn't find a solution like you seek.
steve

On 03/05/2020 19:35, Johnny Rosenberg wrote:
> Hi!
>
> I'm just wondering if I'm missing something.
> Let's say I have a spreadsheet (I actually have several…) with a lot of
> cells and ranges already filled with data and formulas. One day I discover
> the range naming feature, so I name a few cell ranges. Shouldn't there be
> some easy way to replace every occurrence of those cell ranges in all my
> formulas? And when I say easy, I mean easier than doing search and replace
> on each one of them one by one. I can't find such a feature. Is there an
> extension for it?
>
> I'm going to write a macro for it, but I find it meaningless to write a
> macro for something that's already there, so that's why I ask this question
> in the first place.
>
>
> 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