Re: [libreoffice-documentation] Calc Guide chapter 7, formulas & functions

2013-09-17 Thread John Smith
Thanks Shelagh. I'll revisit the chapter and review what I have written. Regards JohnS On 17/09/2013 01:04, shelagh.man...@gmail.com wrote: Have tested ceiling() and Floor() and in Excel niether accepts a third argument. I would propose changing the wording to "if you want your spreadsheet to b

Re: [libreoffice-documentation] Calc Guide chapter 7, formulas & functions

2013-09-16 Thread shelagh.man...@gmail.com
Have tested ceiling() and Floor() and in Excel niether accepts a third argument. I would propose changing the wording to "if you want your spreadsheet to be compatible for both Excel and Calc you should leave the optional mode argument out of your formulas. Or words to that effect. Not sure what th

Re: [libreoffice-documentation] Calc Guide chapter 7, formulas & functions

2013-09-16 Thread John Smith
Hi Jean. I will update to v4.1 then and make a start on Appendix B for Calc 4.1. Thanks to all who have offered to check the guide's Excel statement for me. Regards JohnS On 16/09/2013 00:08, Jean Weber wrote: On Mon, Sep 16, 2013 at 5:38 AM, John Smith wrote: Hi. I've uploaded chapter 7 to t

Re: [libreoffice-documentation] Calc Guide chapter 7, formulas & functions

2013-09-15 Thread Jean Weber
On Mon, Sep 16, 2013 at 5:38 AM, John Smith wrote: > Hi. > I've uploaded chapter 7 to the Calc Drafts 4.0 folder here; > http://www.odfauthors.org/libreoffice/english/calc-guide/draft-lo4/chapter-7-formulas-and-functions/view > > I have left a few comments in the chapter, one of which I need someo

[libreoffice-documentation] Calc Guide chapter 7, formulas & functions

2013-09-15 Thread John Smith
Hi. I've uploaded chapter 7 to the Calc Drafts 4.0 folder here; http://www.odfauthors.org/libreoffice/english/calc-guide/draft-lo4/chapter-7-formulas-and-functions/view I have left a few comments in the chapter, one of which I need someone to answer. It concerns a statement about Excel which I'm