https://bugs.documentfoundation.org/show_bug.cgi?id=151166
--- Comment #7 from SheetJS <[email protected]> --- > I thought this function is different from the Address function of odf, You probably tested it :) They give different results with cross-sheet/table references. =ADDRESS(2,2,2,FALSE,"Sheet2") is the string value "Sheet2!R2C[2]" in LibreOffice and Excel. In Numbers it is the string value "Sheet2::R2C[2]" using two colons. Overall the casing in the map is a bit inconsistent. A number of functions like CUMPRINC are all upper-case letters, while others like AverageIfs use proper case -- You are receiving this mail because: You are the assignee for the bug.
