I have to use MSExcel at work. I could check what you are asking about. Cheers
Shelagh On 16 September 2013 16:36, PeeWee <[email protected]> wrote: > 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 > [email protected] > > > > On 16 Sep 2013, at 01:08, Jean Weber [via Document Foundation Mail > Archive] <[email protected]> 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 > [email protected] > > To unsubscribe from Documentation, click here. > > NAML > > > > > > ----- > Peter Schofield > [email protected] > -- > 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: [email protected] > 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 > > -- To unsubscribe e-mail to: [email protected] 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
