Dear all,
I am having an issue using POI to read formulas coming from XLS files, when they use functions of the Financial pack from Excel like PRICE and MDURATION. Indeed using CellFormula I get with XLSX file (XSSFWorkbook) the correct spelling: PRICE and MDURATION. But with XLS files (HSSFWorkbook) I get the local version of the function names: e.g. DUREE.MODIFIEE and PRIX.TITRE (in French). How could I get the English version of the formula with HSSFWorkbooks? Many thanks in advance for your help and best wishes, Pierre Pierre MIEHE Actuary IA Tel.: +33 (0)6 10 40 68 91 Linkedin: <https://fr.linkedin.com/in/pierremiehe> https://fr.linkedin.com/in/pierremiehe Skype: <skype:pierre.miehe1?add> pierre.miehe1 Twitter: <https://twitter.com/miehepro> https://twitter.com/miehepro --- L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. https://www.avast.com/antivirus
