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

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

2013-09-17 Thread John Smith
Hi If I've understood you correctly, this chapter will not be published for v4.0 but will be further reviewed and then published as v4.1. If this is the case then when I revisit it to incorporate Shelagh's comments I will need to add a Caution within the text. There is a bug I've found within

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

2013-09-17 Thread Jean Weber
On Tue, Sep 17, 2013 at 8:55 PM, John Smith clicks...@yahoo.co.uk wrote: Hi If I've understood you correctly, this chapter will not be published for v4.0 but will be further reviewed and then published as v4.1. That is the plan. Skip 4.0. If this is the case then when I revisit it to

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

2013-09-17 Thread John Smith
Hi Jean Yes, the bug came to light as I worked on Appendix B using v4.1.1.2. I posted it to Bugzilla after some research and it as been confirmed in v4.1.3.0. but not present in v4.0.5. Regards JohnS On 17/09/2013 12:20, Jean Weber wrote: On Tue, Sep 17, 2013 at 8:55 PM, John Smith

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

2013-09-17 Thread John Smith
Hi I've incorporated Shelagh's information into the text and I've added a Caution about the Function Wizard bug. The file's been updated on ODF. Back to Appendix B. Regards JohnS On 17/09/2013 13:24, John Smith wrote: Hi Jean Yes, the bug came to light as I worked on Appendix B using

Re: Fwd: [libreoffice-documentation] problem with Base documentation about table control in version 4

2013-09-17 Thread Robert Großkopf
Hi Jean, hi Eduard this answer is also send to Eduard ... Right clicking on more controls I went to the more controls toolbar and I discovered that the icon table control was not clicked in that toolbar ! It happened both in 4.0 and 4.1 : is this a default value problem? I have about 30

[libreoffice-documentation] CONVERT function in Calc

2013-09-17 Thread John Smith
Hi all. I'm working on the Appendix B chapter for Calc and I am looking at the =CONVERT function. This function converts a numerical value from one unit of measure, to another unit of measure in the same group, for example feet into yards, both in the distance group. Within the dialogue of the

Re: [libreoffice-documentation] CONVERT function in Calc

2013-09-17 Thread Steve Edmonds
On 2013-09-18 08:45, John Smith wrote: Hi all. I'm working on the Appendix B chapter for Calc and I am looking at the =CONVERT function. This function converts a numerical value from one unit of measure, to another unit of measure in the same group, for example feet into yards, both in the

Re: [libreoffice-documentation] CONVERT function in Calc

2013-09-17 Thread shelagh.man...@gmail.com
I searched on Google - apparently convert should be convert_add and the list of units you can use (and works 'cause I tried some out) can be found for the help of that function. Now the question is, is it a documentation bug that the convert function is mentioned in the help, if you are supposed

Re: [libreoffice-documentation] CONVERT function in Calc

2013-09-17 Thread Steve Edmonds
On 2013-09-18 08:45, John Smith wrote: Hi all. I'm working on the Appendix B chapter for Calc and I am looking at the =CONVERT function. This function converts a numerical value from one unit of measure, to another unit of measure in the same group, for example feet into yards, both in the

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

2013-09-17 Thread PeeWee
Hello I will be getting to Chapter 7, but it will be sometime before I am there. The best way would be to upgrade the chapter to 4.1 and I will then do a final edit when it is ready so we get the same look and feel throughout the guide. Regards Peter Schofield psaut...@libreoffice.org On