openoffice-api mailing list archives

Hi ,
   You can use the following Api's in C++. This is some prototype code, I implemented for
my project.

Thanks
Mangesh



    // This API sets the active Spreadsheet in the Calc document
    int Calc::SetActiveWorksheet(Reference<XSpreadsheet> rSheet)
    {
        ////create xSheetDocument
        Reference<XSpreadsheetDocument> xSheetDocument (rComponent,UNO_QUERY);
      
        Reference< XModel > xSpreadsheetModel (xSheetDocument, UNO_QUERY);

        // then get the current controller from the model
        Reference< XController > xSpreadsheetController = xSpreadsheetModel->getCurrentController();
 
        // get the XSpreadsheetView interface from the controller, we want to call its method
        // setActiveSheet
        Reference< XSpreadsheetView > xSpreadsheetView (xSpreadsheetController, UNO_QUERY);
 
        // make our newly inserted sheet the active sheet using setActiveSheet
        xSpreadsheetView->setActiveSheet(rSheet); 
                
        return 0;
    }

    // Sets the active sheet to the index provided
    // Sheet number starts with 0,1 .Therefore index 1 indicates second sheet.
    int Calc::SetSheetNumber(int index)  
    {
        //create xSheetDocument
        Reference<XSpreadsheetDocument> xSheetDocument (rComponent,UNO_QUERY);

        //create an instance of XSpreadsheets, which is a worksheets collection
        Reference<XSpreadsheets> xSheets = xSheetDocument->getSheets();

        //create a class to interact with single worksheets;

        //the single worksheets are referenced by an XIndexAccess interface
        Reference<XIndexAccess> xIndex (xSheets,UNO_QUERY);

        //take the first worksheet (index=0)...
        Any any=xIndex->getByIndex(index -1);
        
        // create an instance of Xspreadsheet, able to manage 
        //single worksheets; 
        Reference<XSpreadsheet> xSheet;

        //finally, assign the first worksheet to xSheet 
        any >>= xSheet;
        
        // Set the sheet as active sheet
        SetActiveWorksheet(xSheet);

        return 0;
    }



-----Original Message-----
From: Andrew Pitonyak [mailto:andrew@pitonyak.org] 
Sent: Wednesday, April 10, 2013 5:54 PM
To: api@openoffice.apache.org
Subject: Re: UNP API

I think I demonstrate this in AndrewMacro.odt, but am unable to verify at this time. Utilities
were accidentally cut outside my house yesterday.

"k.misha" <misha@4k.com.ua> wrote:

>Hi!
>
>How can I select a sheet in calc document?
>
>Thanks!
>

---------------------------------------------------------------------
To unsubscribe, e-mail: api-unsubscribe@openoffice.apache.org
For additional commands, e-mail: api-help@openoffice.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: api-unsubscribe@openoffice.apache.org
For additional commands, e-mail: api-help@openoffice.apache.org