Create a new plugin for OpenOffice calc that allows users to retrieve data from the Pentaho platform using metadata based queries.
The plugin needs to:
- Allow the user to connect and login to a Pentaho BI server
- Retrieve the list of metadata models available to the user and let them pick one
- Retrieve the details of the selected metadata model
- Allow the user to select columns of data that they want to see
- Submit the metadata-based query to the server and populate the sheet with the results
- Save the connection and query information with the Calc sheet
- Allow the user to refresh the data when a saved document is loaded