You are here: Home / OpenOffice.org / English / Userguide3 / Calc3 / old_files

old_files

File Zip archive FunctionsUpload1.zip
File ODT document CG3 Ch1 Introducing Calc
Added some material and edited a few points.
File ODT document CG3- Chapter 7: Using Formulas and Functions
I've reviewed the content and updated screenshots where indicated but couldn't find corresponding file in feedback folder.
File ODT document CG3 Ch9 Data Analysis
I've made many, MANY more edits and comments than I ever thought I would, so I really hope it's OK. I think that many of the textual descriptions of the functions could be chopped down or removed entirely - either due to repetition or sheer complexity - but I've tended only to only re-word them at this stage.
File ODT document CG3 Ch4 Styles and Templates (11 Nov 2009)
Incorporated NT's comments. Replaced some screenshots. Not thoroughly checked against OOoV3.2. --JHW
File ODT document CG3 CH7 Formulas & Functions (22 February 2010)
This file has been updated with most of BMT's comments and has also been edited for grammar. There are still a few outstanding comments so needs a further rework. (Claire Wood)
File ODT document CG3 Ch6 Printing Exporting Emailing (08 Feb 2010)
Minor updates for V3.1 & 3.2. In new template. --JHW
File ODT document CG3 Ch10 Linking Calc Data (9 Nov 2009)
Incorporated NT's revisions and made some other minor changes. Chapter needs thorough checking against OOo 3.2. --JHW
File ODT document CG3 Ch7 Formulas and Functions (16 April 2010)
Includes MJF's edits and his q's and my a's. More work needed. - JHW
File ODT document CG3-FormulasAndFunctions_JHW_MJF20100404.odt
This version (from JHW document dated 16 March 2010, which is an update of Claire Wood's review) contains some additional edits (with changes recorded) and a new short section on advanced functions at the end of the document. There is a question on the section dealing with Function Wizard that needs to be looked at. Martin Fox
File ODT document CG3 Ch6 Printing Exporting Emailing (14 Apr 2010)
Review of draft
File CG3 Ch3 Charts and Graphs (05 Jan 2010)
Updated for 3.2. In new template. --JHW Copy edited -- AJP
File ODT document CG3 Ch10 - Linking Calc Data
A couple of sections of fairly heavy rewriting/resequencing but mostly just comments and queries to improve consistency and accessibility.
File ODT document CG3 Ch10 Linking Calc Data - commented
JA's edits are commented by JHW.
File ODT document CG3 Ch5 Using Graphics in Calc
File ODT document CG3 Ch5 Using Graphics in Calc (31 Dec 2009)
Much material added and revised (working on making graphics chapters in all books more similar in presentation). Included review comments by EK. --JHW
File ODT document CG3 App C Error Codes
Edited by SW.
File ODT document CG3 Ch7 Formulas and Functions (6 Nov 2009)
Latest version of file. Needs editing and further revision and review. Please see similar file in feedback folder, containing BMT's review comments, many of which still need to be incorporated in this chapter. --JHW
File ODT document CG3 Chapter 7 Formulas and Functions (22 April 2010)
Edited by Martin Fox to include additional work on references and formula creation. For review
File ODS spreadsheet CG3 Chapter 7 Formulas and Functions (22 April 2010) Spreadsheet examples
Two figures added by MJF, spreadsheet example.
File ODT document CG3 Ch1 Introducing Calc (31 Jan 2010)
Incorporated KA's comments & two new screenshots. In new template. Should be up to date for 3.2 now. --JHW
File ODT document CG3 Ch2 Entering Editing Formatting Data (07 Feb 2010)
Incorporated SB's & BMT's comments. In new template. Updated for 3.2. --JHW
File ODT document CG3 Ch8 DataPilot (8 Dec 2009)
Amended in response to BMT's review. Added two diagrams to better explain some operations. --JHW
File ODT document CG3 Ch8 DataPilot
Edited by SW.
File ODT document Calc 3 Chapter 2
Copy edited
File ODT document CG3 Chapter 7 Formulas and Functions (25 April 2010)
Updated some of the text, added some screenshots. Some of the calculations in screenshots don't add up when you try to link sheets. Structure needs looking at for last info entered as I think it should appear earlier on in chapter. Will also upload Example: Flowing Abundantly Ltd spreadsheets.
File ODS spreadsheet CG3 Chapter 7 Formulas and Functions - Flowing Abundantly Ltd Spreadsheet
This is the first spreadsheet used for creating Branches 1,2&3. Spreadsheet used for Paste Special example to follow.
File ODS spreadsheet CG3 Chapter 7 Formulas and Functions - Flowing Abundantly Ltd - paste special Spreadsheet
File ODT document 0311CG3 Sharing and Reviewing
Technical review for OOo3.2, some screenshots and general review needed still.
File ODT document CG3 Ch11 Sharing and Reviewing (8 Dec 2009)
Incorporating changes arising from SB's review, plus others (Notes are Comments in 3.2). --JHW
File ODT document CG3 Ch12 Calc Macros (8 Feb 2010)
Updated for 3.2, including some new screenshots. In new template. --JHW
File ODT document CG3 Calc Macros (28 April 2010)
Updated some text and screenshots as some of the smaller imaging had changed. Had problem with Figure 8 and have posted that image to JHW/MF
File ODT document CG3 Ch13 Calc as a Simple Database (8 Feb 2010)
In new template. Not thoroughly checked for 3.2, but I did verify that some of the menu paths are correct. --JHW
File ODT document CG3 Calc as a Simple Database (4 May 2010)
Updated some screenshots as the icons on some were out of date or the screen had been updated, but not sure if they impact on the Listings to do with macros, can someone please check?
File ODT document CG3 Ch14 Setting Up & Customizing Calc (18 Dec 2009)
Some updates and extra info. Thanks to SB for his review, and to Regina for corrections made on the wiki. Chapter still needs further improvement. --JHW
File ODT document CG3 Chapter 14 Customizing Calc (9 May 2010)
Just a few minor text changes and 1 screenshot change
File ODT document CG3 Chapter 11 Sharing and Reviewing
Added a list of features disabled when a spreadsheet is shared (Edit Changes switched on)
File ODT document CG3 Ch6 Printing Exporting Emailing (20 April 2010) - TO BE INDEXED
Includes KP's edits. --JHW
File ODT document CG3 Ch6 Printing, Exporting, Mailing
Reviewed and updated the index. This is my first indexing attempt, so it would probably help to have someone else double check it. I tried to match the style of previously indexed chapters; please let me know if anything needs to be changed.
File CG3 Ch9 Data Analysis (5 Feb 2010)
Incorporates review comments by NT & JA. In new template. --JHW
File ODT document CG3 Ch10 Linking Calc Data (20 April 2010)
Includes JA's edits as well as earlier edits by other. --JHW
File ODT document CG3 - CH09 - Data Analysis
Just minor changes to this one and moved 1 or 2 images so that the document flowed a bit better from a reader's perspective.
File ODT document CG3 - CH10 - Linking Calc Data
Just minor edits really plus a few comments. Everything seemed OK on the whole when I went through it using Calc.
File ODT document CG3 Ch8 DataPilot (6 June 2010)
Includes SW's edits and more of my own. --JHW
File ODT document CG3 Ch2 Enter Edit Format Data
Reviewed, edited, and added to index. No edits made to chapter content.
File ODT document CG3 - Ch08 - Data Pilot - 18 June 2010
I've basically changed wording from "choose" to "select" in places where there are clear instructions. Changed where the flow of the document with certain phrasiology read quite clumsily. I've queried the plural use of "data" and there is a detailed comment, as I was a bit torn. Here in the UK we'd use the singular. I've also queried a heading and whether the word "instructions" should replace "descriptions".
File ODT document CG3 Ch4 Using Styles and Templates in Calc
Edited/updated index. No edits made to guide content.
File ODT document CG3 Ch1 Introducing Calc (5 June 2010)
Included GS's edits of an earlier version of the chapter, plus some other corrections. Indexed and ready to publish. --JHW
File ODT document CG3 Ch2 Enter Edit Format Data (20 June 2010)
Indexed and ready to publish. --JHW
File ODT document CG3 Ch3 Charts and Graphs (21 June 2010)
Includes AJP's edits. Indexed and ready to publish. --JHW
File ODT document CG3 Ch4 Styles and Templates (21 June 2010)
Indexed and ready to publish. - JHW
File ODT document CG3 Ch5 Using Graphics in Calc (24 Apr 2010) - TO BE INDEXED
Includes edits by KP. --JHW
File ODT document CG3 Ch6 Printing Exporting Emailing (15 June 2010)
Indexed & ready to publish.
File ODT document CG3 Ch7 Formulas and Functions (21 June 2010)
Includes MJF's & CW's edits. Indexed and ready to publish. -- JHW
File ODT document CG3 Ch8 DataPilot (20 June 2010)
Includes CW's edits. Indexed and ready to publish. --JHW
File ODT document CG3 Ch9 Data Analysis (17 June 2010)
Includes CW's edits. Indexed and ready to publish. --JHW
File ODT document CG3 Ch10 Linking Calc Data (17 June 2010)
Includes edits by CW. Indexed and ready to publish. --JHW
File ODT document CG3 Ch11 Sharing and Reviewing (21 June 2010)
Includes MJF's & CW's edits. Indexed and ready to publish. --JHW
File ODT document CG3 Ch12 Calc Macros (8 June 2010)
Includes CW's edits and more from me. Indexed and ready to publish. --JHW
File ODT document CG3 Ch13 Calc as Simple Database (8 June 2010)
Reviewed by CW. Some new screenshots by CW & JHW. Indexed and ready to publish. --JHW
File ODT document CG3 Ch14 Customizing Calc (8 June 2010) - TO BE INDEXED
File ODT document CG3 AppA Keyboard Shortcuts (16 March 2010)
Indexed and ready to publish. --JHW
File CG3 AppB Calc Functions (16 March 2010)
Revised, indexed, ready to publish. -- JHW
File ECMAScript program CG3 AppC Calc Error Codes (24 April 2010)
Indexed and ready to publish. --JHW
File ODT document CG3 - CH14 - Customising Calc - 21 June 2010
Did my best at indexing this chapter but someone else should double check as I'm not the world's best. Claire
File ODT document CG3 Ch 5 Using Graphics in Calc
This one was pretty tricky, and might be worth a quick look. "Images" and "Graphics" are used pretty much interchangeably, for one thing; and virtually the whole chapter consists of "(verb)ing graphics" or "(verb)ing images." Deciding which of these should be main entries, sub-entries, or both was challenging. Please let me know if I need to fix anything.
File ODT document CG3 - Ch11 - Sharing and Reviewing Documents - 20 June 2010
I only made 3 minor changes. However, this chapter is difficult to review without another volunteer as you need a second person to test the instructions when using shared spreadsheets. If anyone else reviews it, please get in touch so we can check the screens.
File ODT document Introducing Calc
Contain edits by GS and comments on those edits by JHW. Changes have been incorporated into the current version of the chapter. This file is for information only.
File ODT document CG3 Ch10 Linking Calc Data (ODT)
Edits by JHW.
File Octet Stream Calc Guide 3.3 Ch 2 Entering, Editing, and Formatting Data
Reviewed by JS
File CG3.3 Ch1 Introducing Calc (19 Jan 2011)
Reviewed by NAC.
File Troff document CG3.3 0308 Data Pilot
Data pilot chapter revised and checked over for completeness etc. for version 3.3 of OOo revision 2011 01 22 by MJF
File CG3.3 Ch7 Formulas & Functions (20 Jan 2011)
File chemical/x-alchemy CG3.3 Ch5 Using Graphics in Calc
New template applied and minor edits made.
File CG3.3 Ch 7 Formulas and Functions (2011 01 23)
Chapter 7 reviewed for 3.3 by MJF
File CG3.3 Ch 9 Data Analysis (29 Jan 2011)
Reviewed and minor updates only MJF 29.1.2011
File Calc Chapter 6
A couple small edits. NC
File Haskell source code Calc 3.3 Chapter 3: Charts and Graphs
Calc 3.3 Chapter 3: Charts and Graphs
File Octet Stream CG3.3 Ch 10 Linking Calc Data
Updated for 3.3 and minor edits. Screenshot Figure 26 to be updated.
File text/texmacs CG 3.3 Ch 11 Sharing and Reviewing Documents
Checked for 3.3 and minor edits. MJF 2011 02 21
File chemical/x-rosdal CG3.3 Ch12 Calc Macros
Minor edits. Checked all listings against 3.3. Runs ok. For review. MJF
Navigation

Legal Disclaimers and Limitations | Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0. License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License v2.0.

"LibreOffice" and "The Document Foundation" are registered trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.