Skip to content

Tag: libreoffice-calc

LibreOffice SDK read formula result

I am using the LibreOffice SDK to create a Java program that reads data from a Calc spreadsheet. One of the cells has a formula in it that returns text (i.e. not a numeric/double value). XCell.getFormula() returns the actual formula (“=I6”), rather than the result (“my text”). I have looked at the LibreOffice SDK API, and it appears that XCell.getValue()