Apache OpenOffice (AOO) Bugzilla – Issue 72650
Link in list box not saved
Last modified: 2017-05-20 11:13:50 UTC
Create a list box in Calc. In properties, "source cell range" enter a reference to a cell in another spreadsheet. Save and Close. Reopen the document and the reference is gonne.
Any chance you could provide sample file?
I can confirm this issue. Try this: (1) Create a new spreadsheet (2) Fill Sheet1.A1:A10 with some data (3) Save the file to C:\test.ods (4) Close the file (5) Create another new spreadsheet (6) Create a combo box (7) Set "source cell range" to: 'file:///C:/test.ods'#Sheet1.A1:A10 (8) Save this file, close it, and reopen it (9) source cell range is gone OpenOffice.org 2.1.0 / Windows 2000 SP4 OpenOffice.org 2.0.2 / Ubuntu Linux 6.06
I have confirmed this bug in OpenOffice.org 2.1 on Win XP SP1. After creating a list box and typing the "source cell range" of another file and then saving the current file, the "source cell range" does not get saved.
Created attachment 42652 [details] Details of Tests
The above test of Open Office 2.1 (EN version) were done on using the Microsoft Windows XP Professional Version 2002 Service Pack 2 Operating system, on a Intel ® Pentium® 4 CPU 1.80GHz 1.82Hz, 512 MB of RAM.
Hi Frank, I think it's yours. Frank
Yes. But given that this bug is in there since the very beginning of the whole feature (cell linking of form controls), I doubt the target.
Reset assigne to the default "issues@openoffice.apache.org".