Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-29 Thread Steve Edmonds
On 29/01/2021 09:13, Johnny Rosenberg wrote: Den tors 28 jan. 2021 kl 01:05 skrev Steve Edmonds < steve.edmo...@ptglobal.com>: Hi Hylton. If you use find/replace you can search for a reference (i.e.B4) and search all sheets with the find next. Remember to search for B$4 also in case any

Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-28 Thread Johnny Rosenberg
Den tors 28 jan. 2021 kl 01:05 skrev Steve Edmonds < steve.edmo...@ptglobal.com>: > Hi Hylton. > If you use find/replace you can search for a reference (i.e.B4) and > search all sheets with the find next. Remember to search for B$4 also in > case any formulae contain this reference format. >

Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-27 Thread Steve Edmonds
Hi Hylton. If you use find/replace you can search for a reference (i.e.B4) and search all sheets with the find next. Remember to search for B$4 also in case any formulae contain this reference format. Steve On 28/01/2021 08:16, Hylton Conacher (ZR1HPC) wrote: Hi, I have a 134 column

Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-27 Thread Brian Barker
At 21:16 27/01/2021 +0200, Hylton Conacher wrote: I have a 134 column spreadsheet I am tidying up. An issue has arisen where if I delete a cell's content I do not know what other cell is referencing the deleted cell's content? How can I determine this ... Use Tools | Detective > | Trace

[libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-27 Thread Hylton Conacher (ZR1HPC)
Hi, I have a 134 column spreadsheet I am tidying up. An issue has arisen where if I delete a cell's content I do not know what other cell is referencing the deleted cell's content? How can I determine this or should I raise a feature enhancement and if so where? Regards Hylton I am a