While import XML as data source works in a new Calc default sheet, importing to a new sheet does not work. Step to reproduce: 1. Create a new Calc spreadsheet, add a new sheet 2. Import XML data to the new sheet (Data > Import XML Source)
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(In reply to Oliver Brinzing from comment #1) > Thank you for reporting the bug. > Please attach a sample document, as this makes it easier for us to verify > the bug. > (Please note that the attachment will be public, remove any sensitive > information before attaching it. > See > https://wiki.documentfoundation.org/QA/ > FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help > on how to do so.) > > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' once the requested document is provided. You can use any XML files to be imported while keeping in mind this issue occurs when importing to a NEW SHEET, not default existing one.
[Automated Action] NeedInfo-To-Unconfirmed
Hi Rizal, Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
OK here my testing come When importing to the Sheet2 (A new sheet) with "Mapped cell: $A$1" the XML content go to Sheet1 But with addition in "Mapped cell: $Sheet2.$A$1" then the XML content go to Sheet2. Is this happen by design? By default without defining Sheet variable the content go to Sheet1. I just think this is a little bit misleading, without defining $Sheet variable the content SHOULD BE go to THE active sheet. Tested with Version: 6.5.0.0.alpha0+ Build ID: d5d8fa63282a433da9c49d811f04390b8d6ab9cc CPU threads: 4; OS: Linux 5.0; UI render: default; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-12-11_04:03:13 Locale: id-ID (id_ID.UTF-8); UI-Language: en-US Calc: threaded
Hi Rizal, could you please attach a document ?
Created attachment 156534 [details] XML File Example
Created attachment 156535 [details] XLM Mapping to Document
> When importing to the Sheet2 (A new sheet) with "Mapped cell: $A$1" the XML > content go to Sheet1. > But with addition in "Mapped cell: $Sheet2.$A$1" then the XML content go to > Sheet2. reproducible with: Version: 6.4.0.0.beta1 (x64) Build-ID: 4d7e5b0c40ed843384704eca3ce21981d4e98920 CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc:
Rizal, could you test this bug with 7.1? In my tests it is solved. I don't see any difference between the default sheet and adding another sheet and importing. Tested on Version: 7.1.0.0.alpha0+ Build ID: 4a899a5f8a72ea29a6919316afe3627de9f33e95 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
(In reply to BogdanB from comment #10) > Rizal, could you test this bug with 7.1? > > In my tests it is solved. I don't see any difference between the default > sheet and adding another sheet and importing. > Still reproducible, the data imported to Sheet1, not active sheet (Sheet2) Version: 7.1.0.0.alpha0+ Build ID: a8c218a52a639b0e7f689dea878a0421702628e0 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5 Locale: id-ID (id_ID.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-09-25_22:25:07 Calc: threaded
In my case aftyer importing, the imported file is open in a new document. So, it's not depending of Sheet1 or Sheet2. Am I doing wrong?
(In reply to BogdanB from comment #12) > In my case aftyer importing, the imported file is open in a new document. > So, it's not depending of Sheet1 or Sheet2. Am I doing wrong? See my explanation in #c5
I confirm this Version: 7.0.1.2 Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: nl-BE (ro_RO.UTF-8); UI: en-US Calc: threaded
Works for me in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 7390401fa21d9ebf35d9473bef6b44b42ea7475d CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN Calc: threaded Rizal Muttaqin: Could you please retest with a daily build or the 7.3 beta version?
(In reply to Rizal Muttaqin from comment #5) > OK here my testing come > > When importing to the Sheet2 (A new sheet) with "Mapped cell: $A$1" the XML > content go to Sheet1 > > But with addition in "Mapped cell: $Sheet2.$A$1" then the XML content go to > Sheet2. > > Is this happen by design? By default without defining Sheet variable the > content go to Sheet1. I just think this is a little bit misleading, without > defining $Sheet variable the content SHOULD BE go to THE active sheet. > > Tested with > Version: 6.5.0.0.alpha0+ > Build ID: d5d8fa63282a433da9c49d811f04390b8d6ab9cc > CPU threads: 4; OS: Linux 5.0; UI render: default; VCL: gtk3; > TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: > 2019-12-11_04:03:13 > Locale: id-ID (id_ID.UTF-8); UI-Language: en-US > Calc: threaded Still reproducible in Version: 7.3.0.0.beta1+ / LibreOffice Community Build ID: ecfb83d7463bed7c89baeccc03286c1ac9956d70 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Steps: 1. Open Calc 2. Insert a new sheet 3. Data - XML Source 4. "Mapped cell: $A$1" @Eike, I thought you might be interested in this issue
Looks like some dumb reference processing not taking relative references (here relative to the current sheet if no sheet is given) into account..
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ec4f8cd2172bf7b232961f31ebd22d7e13af261e Resolves: tdf#126565 RefEditModified() preset current sheet for address-only It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/126883 for 7-2
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/a79fc65f583b3ec2bb924bc25b105dda59099f61 Resolves: tdf#126565 RefEditModified() preset current sheet for address-only It will be available in 7.3.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fwiw, this is not related at all to new sheets, only the 2D address (without sheet name) that always imports to the first sheet. Adjusted summary.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/262656092fda6398e6b028a92f2ac7222ce11d30 Resolves: tdf#126565 RefEditModified() preset current sheet for address-only It will be available in 7.2.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/759da7e51d73ad4a0ae40156097eea96f029bd4f tdf#126565: sc: Add UItest It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I can verify this bug has been fixed Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 17a4f4d5e4d49189b43e748271d2d4fa330eef9b CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb) Locale: id-ID (id_ID.UTF-8); UI: id-ID Calc: threaded