/************************************************************** * * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ #ifndef __com_sun_star_sheet_XSheetLinkable_idl__ #define __com_sun_star_sheet_XSheetLinkable_idl__ #ifndef __com_sun_star_uno_XInterface_idl__ #include #endif #ifndef __com_sun_star_sheet_SheetLinkMode_idl__ #include #endif //============================================================================= module com { module sun { module star { module sheet { //============================================================================= /** enables a sheet to refer to another sheet in a different document.

To insert a sheet link, the sheet used as linked sheet has to exist already. The method XSheetLinkable::link creates a SheetLink object in the document's SheetLinks collection and links the sheet to the specified external sheet.

@see com::sun::star::sheet::SheetLinks @see com::sun::star::sheet::SheetLink @deprecated */ published interface XSheetLinkable: com::sun::star::uno::XInterface { //------------------------------------------------------------------------- /** returns the link mode of the spreadsheet.

If the returned value is SheetLinkMode::NORMAL, formulas are copied. With SheetLinkMode::VALUE, only results of formulas are used.

*/ com::sun::star::sheet::SheetLinkMode getLinkMode(); //------------------------------------------------------------------------- /** enables the linking of the sheet and controls whether formulas are copied. @param nLinkMode the value specifying the link mode for this spreadsheet.

If the value is SheetLinkMode::NORMAL, formulas are copied. With SheetLinkMode::VALUE, only results of formulas are used.

*/ void setLinkMode( [in] com::sun::star::sheet::SheetLinkMode nLinkMode ); //------------------------------------------------------------------------- /** returns the target URL of the link. */ string getLinkUrl(); //------------------------------------------------------------------------- /** sets the target URL of the link.

A SheetLink object with the same file name must exist already or the link will not work.

*/ void setLinkUrl( [in] string aLinkUrl ); //------------------------------------------------------------------------- /** returns the sheet name of the sheet in the source document. */ string getLinkSheetName(); //------------------------------------------------------------------------- /** sets the name of the linked sheet in the source document.

This method sets the sheet name in the SheetLink object, it does not modify the sheet name in the source document.

*/ void setLinkSheetName( [in] string aLinkSheetName ); //------------------------------------------------------------------------- /** links the sheet to another sheet in another document.

A SheetLink object is created if it does not exist, and the link mode, the URL of the linked document and the linked sheet name are set.

*/ void link( [in] string aUrl, [in] string aSheetName, [in] string aFilterName, [in] string aFilterOptions, [in] com::sun::star::sheet::SheetLinkMode nMode ); }; //============================================================================= }; }; }; }; #endif