When calling tFormula() passing a string in R1C1 notation, the formula shows up in lowercase characters, and the cell yields an Err.When calling oCell.getFormula(), it still gives the formula in Calc A1 notation ( e.g.( This visibly changes the cell adresses in the GUI to R1C1 notation ) the option “Tools : Options : LibreOffice Calc : Formula : Formula Options : Formula Syntax” should be set to Excel R1C1.Hello reproduced this behaviour on my LibreOffice version 5.4.5.1: TokenizeRcformula = hParser.ParseFormula(pRCformula, pCell.CellAddress)

HParser.FormulaConvention = .AddressConvention.XL_R1C1 HParser = ThisComponent.CreateInstance( '.FormulaParser' ) PCell.SetTokens(tokenizeRCformula(pRCformula, pCell))įunction tokenizeRcformula(pRCformula As String, pCell As Object ) As Object I got a new look at the context from that and would like to pay back with a bit of code which demonstrates how to set a formula in RC-style for a cell even without having Calc in the respective mode.Įdit 2: The relevant code is Sub setRCformula(pRCformula As String, pCell As Object) I do not know a way to set this property. Tokens property where every reference occurring in the formula is represented by a token with OpCode 0 and Data being one structure or a sequence of two structures of type .SingleReference containing 7 fields of type Long.

You may get R1C1 info from a cell containing references by evaluating the. The basic info concerning references is, however, coded in numbers like in RC style for the sake of efficiency. Even under Option VBAsupport 1 no formula property contains R1C1 style references though a property.

Excel using rc in formulas