Created attachment 113710 [details] just one screenshot Good morning, I hope somebody can be able to find a solution. I also posted into the Italian and English forums but no answer at all at the moment. 1. the spreadsheet is very complex, works on several pages where hundreds of formulas are linked each other 2. the spreadsheet starts on 1.35. then moved to 4.3.6 and 4.4 without any problem where it is originated, a PC of a coder living in Australia. Libre Office is of course in native English for UI and English Australian for texts. 3. opening here in Italy the spreadsheet, ALSO IF I HAVE SET all in native English, Austalian English for texts, DOT vs COMMA and no caring for localized OS, I find hundreds of formulas not working while hundreds of other formulas work pretty nice; obviously the spreadsheet works perfectly on the original PC. 4. I made several attempts and tests also with some friends of mine in Germany and Italy but all involved persons report exactly the same errors! 5. here localized Win8.1, in Germany localized Win7 Ultimate, in Australia older OS (still waiting for the version). It seems to be something related to the formulas that goes across several pages… just a thought, because lots of them work… I also looked at the formula’s names and i.e. SOMMA in Italian is SUM in English and I read SUM because of I replicated the setting of Libre Calc to the original one, but nothing to do! Can somebody help me? Thank you.
This is a bug tracker, not a help forum. Please try on http://ask.libreoffice.org/ and upload your document on some webspace so people can actually have a look at it. The screenshot is not very helpful. My assumption is that some values are not of numeric data type but string instead and can't be converted to number according to your locale's settings. Also check Tools >> Options >> Calc >> Formula "Detailed Calculation Settings" Custom.