I want my Calc spreadsheet to load records from a registered Base document, selected to match a Calc's cell content.
Let's say I have a Customer DB, registered on Base. I want to have a cell in a Calc spreadsheet working like a dropdown box, filled with a "SELECT name FROM customers;" (first question: how to do that?). Then, upon selecting somebody from that drop-down (and eventually clicking a "Update" button on that spreadsheet), the Calc spreadsheet will recover a list of records, like "SELECT * FROM orders WHERE customer_name = <spreadsheet selected value>". I might either want to have a plain dump (filling cells with the SELECT's result set) or to have it number-crunched by an OO Basic macro.
I know it would make more sense not to have record operations outside Base, but the company I work with is not interested in dropping its spreadsheet based management anytime soon. On the other hand, I am not willing to give up on automating jobs and gaining productiveness, despite my company effort to stay sluggish...
I have made a search for this issue on fora around the 'net, but I was not competent enough to find some concrete clue. So, if anybody can point me out in the right direction, I would be very thankful. I apologise if I am reposting an old and closed topic.
Which version of OpenOffice.org are you using? OpenOffice.org (EN) 2.4
What Operating System (version) are you using? Windows XP Pro
Best regards, Fábio, from Brazil.
