On 13/03/20 5:14 pm, Stephen Fanning wrote: > I would like to hear the opinions of members of the Documentation Team on a > potential improvement to the Calc Guide. > > As you probably know, Calc provides a library of over 500 functions. The > 6.2 Calc Guide includes an Appendix B entitled Description of Functions > which occupies over 70 pages (not an enjoyable read!).
My suggestion is to break Appendix B out into a book of its own, with each function having its own chapter. Each chapter provides: * Where and when the function would usually be used; * When the function should not be used; * The limitations of the various variables within the function; * Where the function fails, and what to do, when it does fail; I've started writing such a critter several times, but get side tracked by other things that are semi-documented/undocumented/incorrectly documented. This is an addition to finding work-arounds for things that LibO can't do. (Shinji Enoki merely scratched the surface, in his talk at Almeria last year.) Jacques Tiberghien _The Pascal Handbook_. Sybex INC: 1981 ISBN: 0-89588-053-9 is the guide example I'm following. But B Held & T Richardson _Microsoft Excel Functions and Formulas, Third edition_ Dulles VA: Mercury Learning and Information: 2015 ISBN: 978-1-937585-50-1 as does a book called something like _100 Formulas for Excel_. (I can't find it on my drive. I'm running a script within Calibre, so it isn't accessible, to find the correct title, or publication data.) are pointers towards what I'm envisioning. In an ideal world, we'd have * LibreOffice For the Biological Sciences; * LibreOffice For Business Statistics; * LibreOffice For Educational and Psychological Statistics; * LibreOffice For Engineering Statistics; * LibreOffice For Environmental Sciences and Statistics; * LibreOffice For Health Services management Statistics; * LibreOffice For Human Resource Statistics; * LibreOffice For Marketing Statistics; * LibreOffice For Social Science Statistics; * LibreOffice For Data Analysis; * LibreOffice For Project Management; * LibreOffice For Financial Analysis; * LibreOffice For Economic Appraisal and Forecasting; * LibreOffice For Stock Market Analysis; * LibreOffice For Financial Simulation Modelling; FWIW, I simply substituted "Excel" or "Excel 2016" with LibreOffice, to create those titles. jonathon -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy