Your file [input.ods] has formula in O13, but it is incomplete. While opening in OpenOffice I am getting an error Err:511 [see attachment text()err.PNG]. I tried saving this file to XLSX file format using latest version of Aspose.Cells JAVA v22.214.171.124 and the resultant file has 0 in O13, also the formula is lost [see attachment odsOut.xlsx].
Actually, function TEXT() take two parameters. First is number and second is string format. In input-2.ods file, I modified your formula in O13 to =Text(A1, “0”). Now when I converted this file to XLSX, the result is as expected [see odsOut-2.xlsx]. The resultant file in this case preserved the formula.
Attached is an archive containing all input/output files.