Re: [libreoffice-users] Re: Calc: Problem pasting listboxes

On Mon, Mar 21, 2011 at 12:37 AM, nvrk <nvrk.89410@gmail.com> wrote:
> On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg <jktrigg@gmail.com> wrote:
> > On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg <jktrigg@gmail.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
> > > 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-3.3.1.2 (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.

> and/or
> 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).

Jim

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***