Break Link [in edit menu] turn cell into #Ref except first cell. Expected behavior - Retain the cell values Step to reproduce 1. copy some cell from any saved spreadsheet. 2. paste special as Link 3. go to edit -> Link -> Break link 4. All cell turned to turned # ref except first cell, irrespective reference file available or not. So we cannot send the file without link.
Jaise, it unref the link for me just fine in 3.6rc1 on linux. Could you check with this version?
Created attachment 64261 [details] screenshot screen shot
see the screen shot what I am getting in while unlinking cells. it is happening in both Linux & windows versions.
Created attachment 68598 [details] Test doc Test Doc
Created attachment 68599 [details] Test doc Test Doc
Sample test doc attached
Note: While breaking, all data is shown. If double click, data turn to #ref. After breaking all cell show data, but for all cell, cell formula point to the first cell of linked array. & any further operation turn cells into #ref. Example : E7 to G12 is linked array. After breaking, all cells show the formula ={E7} pointing to first cell of linked array. Any further operation turn cells into #ref.
I'm being affected also by this bug. I'm using 4.0.3 in windows xp, I have seen it happenning also in 3.6.6 in windows xp regards
Created attachment 79280 [details] Document to test the problem The problem still exsist for version 4.0.3
Confirmed using LO 4.0.3.3 (Win7 Home Premium 32bit) Break Link function not working as expected
Breaks the link between the source file and the current document still not working for libre office 4.2 alpha builb.
rechanging Version to: 3.6.2.2 release -> we only set this version with oldest version when such problem known
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eb38796f83f86e07ea0a0b7030eb86ef228a13f0 that just looks wrong, related fdo#51935 It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.