Description: When breaking links to external documents. Say another spreadsheet from which cells have been cut/pasted. It would be nice to have an option to keep formulas instead of values. Example: ='file:///C:/Users/XYZ/Desktop/Spreadsheet.ods'#$Sheet2.A10 becomes =$Sheet2.A10 The formula from the source spreadsheet cell instead of it's value. Steps to Reproduce: 1. Cut & Paste from other spreadsheet 2. 3. Actual Results: ='file:///C:/Users/XYZ/Desktop/Spreadsheet.ods'#$Sheet2.A10 Expected Results: =$Sheet2.A10 Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
You can use search and replace to remove the route instead. Search for: 'file:///C:/Users/XYZ/Desktop/Spreadsheet.ods'# Replace:
(In reply to m_a_riosv from comment #1) > You can use search and replace to remove the route instead. > Search for: 'file:///C:/Users/XYZ/Desktop/Spreadsheet.ods'# > Replace: I've done that. Would be nice though to have a selection in the break links dialog. Simpler and cleaner. Replace with source document: O Values O Formulas
We have to wait for a developer to take an interest in it. And there are many requests for improvement. But having a simple way to do it.
*** This bug has been marked as a duplicate of bug 160922 ***