Bug 160928

Summary:	Breaking links keep formulas option
Product:	LibreOffice	Reporter:	NOYB <JunkYardMail1>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	enhancement	CC:	miguelangelrv
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description NOYB 2024-05-03 22:39:33 UTC

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

Comment 1 m_a_riosv 2024-05-03 22:57:42 UTC

You can use search and replace to remove the route instead.
Search for: 'file:///C:/Users/XYZ/Desktop/Spreadsheet.ods'#
Replace:

Comment 2 NOYB 2024-05-03 23:12:02 UTC

(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

Comment 3 m_a_riosv 2024-05-03 23:37:48 UTC

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.

Comment 4 ady 2024-05-04 02:05:07 UTC


*** This bug has been marked as a duplicate of bug 160922 ***