Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

On Mon, Mar 21, 2011 at 12:37 AM, nvrk <> wrote:
On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg <> wrote:

On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg <> 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
have 20).

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- (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
Ubuntu 10.10.

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
List archive:
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.