Eike Rathke wrote:
Hi Leonard,

On Tue, Jul 12, 2005 at 15:21:35 -0600, Leonard Sitongia wrote:

So, I'm still at a loss: why my Beamer table doesn't show 9-digit zip codes and why changes I make in the Beamer don't show up in the spreadsheet and visa versa.


I wonder how you could expect that changes show up in the original
spreadsheet document, as normally you can't even edit the spreadsheet
data in the beamer's data source view. How did you accomplish that? Are

You're right, I can't edit it in the Beamer. But, I can edit the spreadsheet. The change doesn't show up in the Beamer when I refresh or disconnect/reconnect the data source, or when I quit and restart OOo. Only when I delete the data source and recreate it, do I see the changed spreadsheet data in the Beamer.

Is this the expected behavior? I would hope that modifying the spreadsheet and simply clicking refresh would update the Beamer view.

My main goal at this time is to print address labels, which appears to require this data source approach. Is there another way to print labels from a spreadsheet?

you sure you connected the spreadsheet as data source and not some other
database that just has similar data but lacks the 9-digit zip codes?

Yes, I'm sure. It's quite clear from creating a simple spreadsheet and then configuring the data source to it.

I don't know where the data source information is stored. Probably not in each document.


No, that wouldn't make sense. Try to _delete_ the data source
connection, not just disconnect/reconnect, quit the application,
restart, and create a new data source connection from scratch and be
sure to use the connection type Spreadsheet and select the appropriate
source document.

Well, I suppose the resolution of this is clear if I need to create a new data source every time I make a change to the spreadsheet. I would hope a simple "refresh" would be enough.

Thanks for your help,
==Leonard


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to