As described at https://help.libreoffice.org/7.2/en-GB/text/sbasic/shared/03080202.html?&DbPAR=WRITER&System=WIN the LOG(x) function is natural log (i.e. base e) In version 7.2.5.2 on Windows (the only version tested) LOG(10) returns 1. i.e. this is in fact LOG10(x) Sample other tested values are also LOG10()
Are you confusing Basic function Log (which help page you are citing) with spreadsheet function LOG [1]? You didn't mention how exactly did you test it. [1] https://help.libreoffice.org/7.2/en-GB/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3109813
(In reply to combes from comment #0) > As described at > https://help.libreoffice.org/7.2/en-GB/text/sbasic/shared/03080202. > html?&DbPAR=WRITER&System=WIN the LOG(x) function is natural log (i.e. base > e) > > In version 7.2.5.2 on Windows (the only version tested) LOG(10) returns 1. > i.e. this is in fact LOG10(x) > > Sample other tested values are also LOG10() Yes, looks like I am confusing different functions in different places - if I follow LOG(x) does one thing in one part and one thing in another place? either Log10 or Ln I tested by typing LOG(10) and LOG(cell ref) in a cell This does seem to be something that could be much clearer in the documentation. At least a warning that the same named function does different things in different parts of the suite
(In reply to combes from comment #2) > > if I follow LOG(x) does one thing in one part and one thing in another place? > either Log10 or Ln Yes, LOG in spreadsheet is very different from Log in Basic macro. > This does seem to be something that could be much clearer in the > documentation. At least a warning that the same named function does > different things in different parts of the suite Which is why I added bug 131382 to See Also for your information.
*** This bug has been marked as a duplicate of bug 131382 ***