Re: [libreoffice-users] Range names

2020-05-10 Thread Johnny Rosenberg
Den tis 5 maj 2020 kl 02:07 skrev Steve Edmonds : > > > On 04/05/2020 09:09, Johnny Rosenberg wrote: > > Den sön 3 maj 2020 kl 22:39 skrev Steve Edmonds < > steve.edmo...@ptglobal.com>: > >> >> >> On 04/05/2020 08:24, Johnny Rosenberg wrote: >> >> Den sön 3 maj 2020 kl 21:39 skrev Steve Edmonds <

Fwd: [libreoffice-users] Range names

2020-05-10 Thread Johnny Rosenberg
Once again I accidentally sent something in private rather than to the list. When will I learn? Anyway, apologies to Dave and here it is for the list: -- Forwarded message - Från: Johnny Rosenberg Date: sön 10 maj 2020 kl 09:07 Subject: Re: [libreoffice-users] Range names To

Re: [libreoffice-users] Range names

2020-05-05 Thread Dave Howorth
On Tue, 5 May 2020 21:20:24 +0200 Johnny Rosenberg wrote: > Den tis 5 maj 2020 kl 08:38 skrev Luuk : > > > > > On 4-5-2020 09:43, Brian Barker wrote: > > > At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote: > > >> Let's say I have a spreadsheet (I actually have several…) with a > > >> lot of

Re: [libreoffice-users] Range names

2020-05-05 Thread Johnny Rosenberg
Den tis 5 maj 2020 kl 08:38 skrev Luuk : > > On 4-5-2020 09:43, Brian Barker wrote: > > At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote: > >> 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 > >> discov

Re: [libreoffice-users] Range names

2020-05-04 Thread Luuk
On 4-5-2020 09:43, Brian Barker wrote: At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote: 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. S

Re: [libreoffice-users] Range names

2020-05-04 Thread Brian Barker
At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote: 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 repl

Re: [libreoffice-users] Range names

2020-05-03 Thread Steve Edmonds
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 Rosenber

[libreoffice-users] Range names

2020-05-03 Thread Johnny Rosenberg
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 eve