Quoting @cbg.jahn: “… Is your ‘.String’ in BASIC code?..”
Of course, many (not all!) things I see as “simple” properties, and access/change like variables when using the Basic IDE for object inspection, or writing statements in Basic are “full-grown” propertis with their set and get methods (still bad wording though finally accepted instead of take and give).
The API, however, works with services and interfaces and a SheetCell object as I see it supports a lot of services, amongt them com::sun::star::text::Text for formatted text cells. This service in turn exports lots of interfaces…
See: LibreOffice: SheetCell Service Reference
I personally am not interested in BeanShell, but if it pretends to offer a sufficiently complete bridge to the LibreOffice API, it must support the mentioned services an interfaces.
Try mySheetCellObject.getText.getString it should return the content as formatted due to the ‘Numbers’ format settings. This implicit dependency must be independent of the language/DE used for programming.
You can NOT get this way a string afflicted by ConditionalFormatting. That’s a very different case.