Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?
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 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 subscriber to the users list. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?
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 Dependents (or Shift+F5). ...or should I raise a feature enhancement and if so where? Probably not. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?
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 subscriber to the users list. -- To unsubscribe e-mail to: users+unsubscr...@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