getPropertyValue ( "ConditionalFormat" ) // create a condition and apply it to the rangeĬom. get the conditional format object of the cell rangeĬom. The xSheet is the .XSpreadsheet interface of a spreadsheet. If more help is needed to understand the settings, click the Helpbutton in the dialog box, and a new help window opens with a description of all the fields shown in the dialog box. It uses the cell style "MyNewCellStyle" that is applied to each cell containing a value greater than 1. In the dialog box that appears, enter the conditions that determine the formats and the desired formats for each condition. The following example applies a conditional format to a cell range. The Apache OpenOffice User Forum is an user to user help and discussion forum for exchanging information and tips with other users of Apache OpenOffice, the open source office suite. The method clear() removes all condition entries.Standard conditional formats combine specific rules with custom formatting. On the Conditional Formatting dialog, enter the conditions. Choose Format > Conditional Formatting from the menu bar. Builtins combine specific rules with predefined styles. Using conditional formatting In your spreadsheet, select the cells to which you want to apply conditional formatting. The methods removeByIndex() removes the condition entry at the specified position. Conditional Formatting Excel supports three different types of conditional formatting: builtins, standard and custom.StyleName: The name of the cell style to apply.SourcePosition: A .CellAddress struct that contains the base address for relative cell references in formulas.Sometimes publishers take a little while to make this information available, so please check back in a few days to see if it has been updated. Formula2 is used only if the property Operator contains BETWEEN or NOT_BETWEEN. We dont have any change log information yet for version 4.1.9 of Apache OpenOffice. The style of the first fulfilled condition (in index order) will be applied to the cell(s). Formula1 and Formula2: Strings that contain the values or formulas to evaluate. represents a collection of conditional formatting settings for a cell or cell range.Operator: A .ConditionOperator constant describing the operation to perform.It expects a sequence of .PropertyValue objects. It was forked in 2010 from, an open-sourced version of the earlier StarOffice.
Apache openoffice conditional formatting software#
The method addNew() inserts a new condition. LibreOffice (/ l i b r /) is a free and open-source office productivity software suite, a project of The Document Foundation (TDF).The interface .XSheetConditionalEntries inserts new conditions and removes them. The service .TableConditionalFormat contains all format conditions and returns .TableConditionalEntry objects. The interface .XSheetConditionalEntry gets and sets the cell style name.The interface .XSheetCondition gets and sets the operator, the first and second formula and the base address for relative references.After a conditional format is changed, it has to be reinserted into the property set of the cell or cell range.Ī condition entry of a conditional format is represented by the service .TableConditionalEntry.