Compare two help sections for WeekDay: https://bit.ly/2vpJuTG https://bit.ly/3d42lVp (both lead to subpages of https://help.libreoffice.org/latest/en-US/), and try to tell which is about Calc function, and which about BASIC function. The problem is, there's no clear marking that this is WEEKDAY *spreadsheet* function vs WeekDay BASIC function. There are a number of coinciding function names between the two modules; and I suppose that all functions, even without counterparts, should be somehow made unambiguous (e.g., to not create an impression that it might be used in a module it doesn't belong to). In fact, that creates actual confusion in users: see e.g. https://ask.libreoffice.org/en/question/233750/.
Also https://ask.libreoffice.org/en/question/233897/
Changing the names of any of the functions will have impact in all the literature and legacy spreadsheet and Basic code. The ambiguity exit since years and has been sorted out by users. The referred pages clearly shows spreadsheet examples for spreadsheet function and BASIC example for BASIC function.
(In reply to Olivier Hallot from comment #2) I am sorry, there's some misunderstanding here! I never suggested to rename functions - only change heading of the articles; and even mentioned that IMO they should be something like WeekDay BASIC function and WeekDay spreadsheet function
And renaming the functions wouldn't solve anything even: one would still not easily see if one should use it in spreadsheet or in a macro. Please re-consider! :-)
And then, if I suggested to rename functions, I'd not make it a "documentation" issue ;-P
Reopening Suggested from IRC: 16:04:36 - mikekaganski: Possibly another note would be useful in same-named topics: "This is an article about Basic function. For same-named spreadsheet function, see here" (and in the opposite direction), to emphasize that they are *different*
Olivier Hallot from comment #6) > Reopening > > Suggested from IRC: > > 16:04:36 - mikekaganski: Possibly another note would be useful in same-named > topics: "This is an article about Basic function. For same-named spreadsheet > function, see here" (and in the opposite direction), to emphasize that they > are *different* This suggestion will make no sense for languages that translate CALC function names.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/698b678fff3ce1c596196a3ca6cf8b16c5d108e4 tdf#131382 scope of function (Calc or BASIC)
ASC is both a spreadsheet function and BASIC function
Log https://help.libreoffice.org/7.2/en-GB/text/sbasic/shared/03080202.html https://help.libreoffice.org/7.2/en-GB/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3109813
*** Bug 147366 has been marked as a duplicate of this bug. ***
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/68c52a06cf89d374fd8d46a5d5f78bd3d4a0cb9a tdf#131382 Scope of functions LOG and ASC
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/a6304ba5dd0efe2d5e2a16254aa9e7d2e74f5660 tdf#127477, tdf#131382 scope of function Minute