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: [email protected] 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
