On Sun, Mar 20, 2011 at 6:41 PM, Jim Trigg <[email protected]> wrote:
> On Sun, Mar 20, 2011 at 9:18 PM, Jim Trigg <[email protected]> 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. > > Thanks, > Jim > > -- > Unsubscribe instructions: E-mail to [email protected] > List archive: http://listarchives.libreoffice.org/www/users/ > *** All posts to this list are publicly archived for eternity *** > 1. What happens if data source becomes ('other sheet".$b$218:$b$238) ?; and/or 2. What happens if copy/paste/special is used? FWIW - I could easily be barking up a wrong tree here since I am a far cry from an experienced user. nvrk -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
