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 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 <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 incorporate Shelagh's
comments
I will need to add a Caution within the text. There is a bug I've found
within the Function Wizard which crashes LO in v4.1, but not in
v4.0. Bug
69440 for reference.
This bug is still there in 4.1.1?
--Jean
Alternatively, if Peter is doing the chapter for v4.1 then he will
be able
to do the Caution his own way from the bug report.
If you could let me know which way you want it done, I'll be fine to
go with
it.
Appendix B in progress.
Regards
JohnS
On 16/09/2013 07:36, PeeWee 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
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