Hello I will be looking at all the chapters in numerical order. That way I get a better understanding of Calc works as I am no spreadsheet expert. I do operate Calc as I am checking the chapters to make sure the instructions match what happens on the screen. I do sometimes miss things, but will keep it in my mind about Excel. I do have MS Office for Mac and Windows 2011 version. Just means I have the reinstall onto my computers - not a problem.
Regards Peter Schofield psaut...@libreoffice.org On 16 Sep 2013, at 01:08, Jean Weber [via Document Foundation Mail Archive] <ml-node+s969070n4074293...@n3.nabble.com> wrote: > On Mon, Sep 16, 2013 at 5:38 AM, John Smith <[hidden email]> 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 someone to > > answer. > > It concerns a statement about Excel which I'm unable to verify as I have no > > access to Excel, at least not later than the Win95 version :-) . > > > > > > Peter, I see you intend to continue with the remainder of Calc. I did > > chapter 8 for v3.4. The Pivot table had not fully morphed over from > > DataPilot at that time so I don't think this will make a good stating point > > for v4.0. > > However, Martin Fox did the same chapter for v3.5, which was out when when > > we were doing the v3.4 docs and in that, Pivot table was fully functional. > > He put the chapter into the drafts 3.4 folder as there was no 3.5 folder. > > I've had a look around ODF but I can't see it anywhere. Hopefully Jean may > > have access to a copy, as ODF has gone through some changes since the file > > was uploaded. > > You can see his email to docs, dated 17 May 2012, on Nabble for reference. > > Searching 'Calc chapter 8' will find it. > > > > > > Jean, if there's nothing else you want me to look at, I'll return to the > > Writer guide. I'll hang on for a few days, if I hear nothing then I will > > update my system to v4.1 and get started. > > > > > > Regards > > JohnS > > John, thanks for your work on Chapter 7. Peter, perhaps you can follow > up on John's question as well as doing whatever else you intend with > that chapter? Of course, anyone else who can answer John's Excel > question is very welcome to do so! > > Regarding Chapter 8 (Pivot Tables), AFAIK Martin Fox's v3.5 comments > were incorporated into the v3.4 chapter published in July 2012, after > being checked that they were valid for v3.4. I could, of course, be > misremembering. I'm looking through my backups to see if I can find a > copy of the file he edited. At this point, it's probably not all that > relevant, because of further changes in Calc itself. > > John, we're not working on v4.0 docs any more, not even for Calc, so > please feel free to update your system to v4.1. IMO the most helpful > thing you can do right now -- if you're willing -- is to look at Calc > Appendix B and update it with the new functions (from v3.5, 3.6, 4.0, > 4.1). The lists of new functions are readily available on the new > features pages of the LO website, but I have not looked yet to see > where to get the descriptions. Possibly the French team has already > done this and can help? > > --Jean > > -- > To unsubscribe e-mail to: [hidden email] > 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 > > > > If you reply to this email, your message will be added to the discussion > below: > http://nabble.documentfoundation.org/Calc-Guide-chapter-7-formulas-functions-tp4074279p4074293.html > To start a new topic under Documentation, email > ml-node+s969070n1645240...@n3.nabble.com > To unsubscribe from Documentation, click here. > NAML ----- Peter Schofield psaut...@libreoffice.org -- View this message in context: http://nabble.documentfoundation.org/Calc-Guide-chapter-7-formulas-functions-tp4074279p4074310.html Sent from the Documentation mailing list archive at Nabble.com. -- To unsubscribe e-mail to: documentation+unsubscr...@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