https://bugs.freedesktop.org/show_bug.cgi?id=54854
--- Comment #11 from Forester <[email protected]> --- Salut Jacques, The PageName extension is derived from the DoobieDoo example that can be found here: http://wiki.openoffice.org/wiki/Calc/Add-In/Python_How-To. The example is 4 years old and was written for the other Office but I was unable to find any other documentation that did not look a lot older and out-of-date. You can download a zip file from the DoobieDoo page. This contains an oxt file. I used this to install the extension (under LibreOffice 3.5.7). It seemed to install OK and the add-in function seem to work OK as well. I will attach a simple python script that can be run as a macro from the UI that inserts several simple formula that call the DoobieDoo functions. The macro does not refer to Sheet1 but you may still have to modify it yourself if your numbers use a «virugle décimal» instead of a decimal point. When I run the script I get Err:508 for the numeric functions and Err:509 for the string functions. As with PageName, selecting a cell containing a 'bad formula' and entering the key sequence F2, SPC, RET causes the function to be re-entered at the UI and the error goes away. I rebuilt the DoobiBoo oxt file under 3.5.7 using my methods. I get the same results. This suggests the package itself is not to blame. The errors suggest that LibreOffice (some component thereof) is unable to parse the formulae due to a syntax error. But there is no syntax error as the F2, SPC, RET sequence confirms. I also infer we do not see the #NAME! error because LibreOffice has given up on a syntax error and has not got as far a trying to look up the function. I think we do not see a syntax error with the PageName functions because they take only one parameter. We are perhaps looking at another bug here. One thing to note is that the first formula the script tries to enter is: =DOOBIEMULT(2.5,1.1) but what I see entered in the spreadsheet is: =DOOBIEMULT(2.5,10.1) where did the extra 0 come from ? I looks to me what whatever bit of code is trying to parse the formula is having a really bad day. Ciao -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
