On Mon, Mar 21, 2011 at 12:37 AM, nvrk <email@example.com> wrote:
On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg <firstname.lastname@example.org> wrote:
On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg <email@example.com> wrote:
I'm trying to set up a sheet with multiple listboxes nearly alike,
each taking its data from a cell range in another sheet in the same
file ('other sheet'.b218:b238). If I copy one and paste it, the
pasted copy does not work -- it does not pull any data (drop-down does
not have any items, even blank ones, even though it is specified to
Any suggestions other than "create each listbox by hand"? The reason
I'm using copy/paste is that each box is supposed to be the same size,
and take the same input (while feeding a different cell).
Just to give specifics, this is running LibreOffice 3.3.1 OOO330m19
(Build:8) tag libreoffice-184.108.40.206 (32-bit) Windows version under
64-bit Windows 7 Home Premium.
I have now confirmed that the problem exists in the 64-bit build on
1. What happens if data source becomes ('other sheet".$b$218:$b$238) ?;
It can't; if I input that into "Source cell range" as soon as I tab
out the $s are stripped out of the reference.
2. What happens if copy/paste/special is used?
The same thing. However, I have determined that saving and reloading
the sheet makes the list boxes work. I'm pretty sure this is a bug,
but don't know what further info is wanted by the developers to work
the problem (especially as I can't send a file that is a test case,
just instructions on how to reproduce).
Unsubscribe instructions: E-mail to firstname.lastname@example.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy