MATCH("Total Result";$'Pivot Table_Sheet1_1'.$4:$4;0)
correctly returns the last column of a pivot table as long as the locale (or “function names”?) is set to english. However, this attempt fails in other LO instances where, due to different locale, the “Total Result” column heading is named differently, e. g. “Summe Ergebnis”.
How would you make this work accross languages? As the spreadsheet is interacted with by international people, I don’t want to enumerate all possible translations of the string “Total Result” but rather seek a robust, language-agnostic approach.
Three ideas come to mind:
(a) match the “Total Result” cell by its internal (english) name, regardless of the user’s locale
(b) find the last column of the pivot table by pivot dimensions
(c - least elegant, but this would still be a solution:) fix the locale at document/file level, so it overrides the user’s locale.
Is anything like that feasible?
(LO versions vary a bit amongst users, but all are >= 7.3.)
Many thanks in advance for every helpful hint!