[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 --- Comment #9 from ady --- Still repro Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5cd9de202765e243e41416802f3e4486b8a96f16 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Built: 2023-04-21 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 BogdanB changed: What|Removed |Added Blocks||108988 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108988 [Bug 108988] [META] Validity-related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 --- Comment #8 from Richard Kelly --- The "Menu/Data/Validity [Ok]" thing is a decent workaround; thank you. Might it also be a clue to the root cause? After the error is introduced, the behavior seems consistent with the spreadsheet holding two versions of the Data Validity attributes, i.e. the human-readable version we see in the dialog and an encoded version cached internally. Does selecting the dialog's [Ok] button cause the software to re-interpret the human-readable version and store the result internally? If so, would re-interpreting it earlier (e.g. when deleting Sheet1) fix the bug? The above is just speculation. I haven't seen the relevant code. I'm just basing my speculation on the behavior I've observed. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 --- Comment #7 from m.a.riosv --- Reproducible with: Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 540a312af2f02108ea90f5d2a9f3bf573db622e5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded But after see the @REF, going to Menu/Data/Validity [Ok] works fine again. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 --- Comment #6 from Richard Kelly --- The bug is still present with the latest version of LibreOffice. I created a new, test spreadsheet by following the steps listed in comment 1. Then I reproduced the problem by following the steps listed in the original description. I got the same result as before, i.e. Sheet2.D1's selection list contains only "#REF!". >From my Help/About LibreOffice dialog: Version: 7.3.5.2 (x64) / LibreOffice Community Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Any suggestions for fixes or workarounds would be greatly appreciated. Thank you! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 --- Comment #4 from BogdanB --- Miguel, what should Richard to do in this case?... It is a bug, or it is something Richard could do?... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #3 from m.a.riosv --- Reproduced. Versión: 6.4.6.1 (x64) Id. de compilación: 985dd72ca280d5c6da2e9f90f7ff9286cafe7ff8 Subprocs. CPU: 4; SO: Windows 10.0 Build 20180; Repres. IU: predet.; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded But after see the @REF, going to Menu/Data/Validity [Ok] works fine again. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g --- Comment #2 from BogdanB --- There should not be a problem because copying the sheet the relations betweens cells break up. I can not reproduce your bug on linux. Tested on Version: 6.4.5.2 Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 135482] EDITING: Data validity fails after copying sheet and deleting original sheet
https://bugs.documentfoundation.org/show_bug.cgi?id=135482 Richard Kelly changed: What|Removed |Added CC||rmkelly...@gmail.com --- Comment #1 from Richard Kelly --- Created attachment 163992 --> https://bugs.documentfoundation.org/attachment.cgi?id=163992&action=edit Spreadsheet with data validity already defined This spreadsheet was created as follows: 1. Create a new spreadsheet. 2. In cells A1, B1, and C1, enter “aaa”, “bbb”, and “ccc”, respectively. 3. In cell D1, select “Data / Validity…” On the Criteria tab of the Validity dialog, allow a “Cell range”, and choose “Show selection list”. Specify a source of A1:C1. 4. On the original sheet’s tab, choose “Move or Copy Sheet…”. Copy the original sheet to a new sheet. 5. Save this spreadsheet. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs