Created attachment 94482 [details] Original spreadsheet file for which I am getting the error Problem description: Cells with Links referring to other spreadsheet which have 'Text' shows #REF! error. But similar cells which have 'Numbers' shows up well. Steps to reproduce: 1. Using Libreoffice 4.2.1; Open the attached file - sales view file - Test 2. Do not Update the Links 3. Still you will see #REF! error in the cells which are having 'Text' in reference links, but the cells fields having numbers shows up perfectly (in spite of having similar reference links) If the same file is opened (without updating links) using gnumeric or Libreoffice 4.1.5 ; This error is not seen. Expected behavior: LO 4.2 should at least open .xlsx which 4.1.5 is opening well Operating System: Ubuntu Version: 4.2.0.4 release Last worked in: 4.1.5.1 rc
Created attachment 94483 [details] Test file opening with LO 4.2.1 - Dont Update Links
Created attachment 94485 [details] Test file opening with LO 4.2.1 - #REF! Error is seen for Text References only
Created attachment 94486 [details] Test file opening with Gnumeric - Error is NOT seen
Created attachment 94488 [details] Test file opening with LO 4.1.5 - Dont Update Links
Created attachment 94489 [details] Test file opening with LO 4.1.5 - Error is NOT seen
Confirmed, with the master branch build. I'm pretty sure it's there in the 4.2.x branch build as well.
I'm looking into it.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3cf0847e7514a3f1217554c08cb109902cf2a637 fdo#75304: Add test for external reference cache import from XLSX. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4917cebdb988223be47b0f1a82241ade643bc675 fdo#75304: Set external reference info to ScCompiler. 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.
4.2 backport request: https://gerrit.libreoffice.org/8212
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=86af0776a09fd49cbd8339350e3b699100c0142a&h=libreoffice-4-2 fdo#75304: Set external reference info to ScCompiler. It will be available in LibreOffice 4.2.3. 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.
Fixed in 4.2.3.
Dear, Kohei Yoshida It's not fixed completely. I am using Libreoffice 4.2.4 Steps to reproduce: 1. Using Libreoffice 4.2.1; Open the attached file - sales view file - Test.xlsx 2. It will ask 'This file contains links to other files. Should they be updated?' ... click NO , & It will open showing all the data. 3. type someting in an empty cell & delete is again so that 'Save' option gets enabled. Save the file again & close it. 4. When you open the file again, now the data is missing. Find attached the screenshot when file is reopened & data is missing.
Created attachment 98758 [details] Libreoffice 4.2.4 still has the same bug
(In reply to comment #14) > Created attachment 98758 [details] > Libreoffice 4.2.4 still has the same bug Please file a new bug for that. with xlsx, import and export have totally different state of completion.
But in 4.1.5 the same used to work. :(
(In reply to comment #16) > But in 4.1.5 the same used to work. :( So file a new bug so we can fix it.
Reported ... Bug 78490 .... as you wish. :P chk it
Migrating Whiteboard tags to Keywords: (PossibleRegression) [NinjaEdit]