https://bugs.documentfoundation.org/show_bug.cgi?id=166654
Bug ID: 166654
Summary: FILESAVE: Cannot save a document after renaming a
sheet referenced in some Data field of dialog controls
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: alfi...@inwind.it
Description:
In a Calc file, I made a dialog and inserted a "Form List Box" in it. In the
Data tab page for that control, I set the "Source Cell range" field to
Sheet1.A1:A3. After, I changed the name of Sheet1 to SheetX. The "Source Cell
range" field automatically changed to SheetX.A1:A3. Perfect! But when I tryed
to save the document, the saving procedure aborts, leaving a temporary file
lu*.tmp and showing this message: "Error saving the document <filename>.
General Error. General input/output error".
When I rename again the sheet to "Sheet1", the save become possible.
Repeating the test with a new document, renaming the sheet *before* creating
the dialog, it save. Obviously, renaming again, it do not save.
The bug also can happen with other controls that permits, in a Data tab page,
to set some sheet address. In the steps to reproduce, I show the problem with
the "Form Spin Button". Nevertheless, the "Form Check Box" seems immune to the
bug.
Steps to Reproduce:
1. Create a new Calc document
2. Click the menu Tools > Macros > Organize Dialogs...
3. In the list on the left, click the temporary name of the new document
4. Click the "New..." button
5. Click the "Ok" button to confirm the name of the new dialog
6. Click the name "Standard" immediately above the dialog name, then click the
dialog name: the Edit button become enabled.
7. Click the Edit button: a draft of the new dialog become visibile
8. The Toolbox toolbar should be visible: else put a check on the menu View >
Toolbars > Toolbox.
9. On the Toolbox click the Form Spin Button icon.
10. Put the mouse cursor over the dialog draft, then drag it diagonally. A
control will be created and selected.
11. On the property pane (to the left) click the Data tab.
12. Read the name of the first sheet in the document. In the next steps you
must replace the name Sheet1 with it.
13. In the "Linked cell..." field write Sheet1.A1
14. In the document, rename the Sheet1 spreadsheet with a new name.
15. Try to save the document.
Actual Results:
The document is not saved and the error message do not tell why. A new lu*.tmp
file is added.
Expected Results:
The document is saved. No file *.tmp remains
Reproducible: Always
User Profile Reset: No
Additional Info:
Tested on version 7.2.1.2, 25.2.3.2 and
Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 6190fe56f72008e0b6d0e502bf94099e72b9d202
CPU threads: 2; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster;
VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
