Re: [libreoffice-documentation] Fw: Calc Manual - need for major edit and proofing

[Jean Weber <jeanweber@gmail.com>]

Those sorts of comments will be very welcome. Looking forward to them.
--Jean

On Mon, Jul 2, 2012 at 9:54 AM, kedarnath <smartxpark@yahoo.com> wrote:
>  hi jean weber and everybody,
>
> 1. I read the first 10 pages and said major edit and proofing was needed. A good book deserves the best cover is my opinion on the first 10 pages.
>
> I did not see any mention of the sheer power of Calc sitting in our computers waiting to be used by anybody. kids or doctors or scientists or common people anywhere. If they are not using spreadsheet software they should. It is a tool to learn, a tool to teach, a tool to do simple jobs or the most complex. And you need not be a highly qualified in maths or programming to program! Spreadsheets can process numbers, text, pictures, graphics, Art and sounds too. I have used Calc to hold pictures of text and OCR text and Land maps and contour surveys.
>
> In counting occurrence of specific character x in cell there was a brilliant solution given by a member of OOo community forum.
>
> LEN(cell)-LEN(SUBSTITUTE(cell;"x";""))
>
> I am using a variant in cells R16:R(many) =LEN(S16)-LEN(SUBSTITUTE(S16;$R$14;"")).. where R14 is cell for input of any character. My text is from S16 to S(many). R16 copied down to R(many)... Now (Space) character when input in R14, gives me a count of the words in each cell of my text!
>
> 2. I am going through the other pages, the technical area and pictures are well done and appealing (what I am reading now).

-- 
Unsubscribe instructions: E-mail to documentation+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted