Can you share a sample file? Thanks... Dominik
On Dec 11, 2016 12:29, "Pierre MIEHE" <[email protected]> wrote: > 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 >
