[libreoffice-documentation] Documentation Reviewer
Hi All, I kind of fell off there, but I expect to get back into it this coming summer. I am a high school teacher, as well as a computer science student, so between being a teacher, and being a student, I have been so busy once summer ended. I am looking forward to getting back into the swing of things, once summer 2021 comes back around! Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] CG7001-Introduction Reviewed and in Feedback NextCloud
Okay, all very good points. Im still new to this, so thank you for the in depth remarks regarding the changes that I suggested. Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Sat, Aug 1, 2020 at 2:42 AM Steve (GMail) wrote: > Hi Gordon, > > Many thanks for your thorough first review of this chapter. I'm a little > embarrassed that I didn't spot the erroneous description of the > characters that can be used in sheet names! > > I have processed all comments and the chapter is now back in the Draft > folder with no tracked changes, ready for second review. > > A few matters arising from your queries and suggestions: > With regards to adding the URL of the Getting Started Guide. As far as > I’m aware we don’t tend to include cross-links like this in any of the > guides. Bear in mind that Calc Guide, Chapter 0 includes a link to the > English Documentation page of the LO website, where copies of all the > guides can be found. If we include the URL for the Getting Started Guide > in this chapter then we’d have to be consistent and include URLs in any > of the chapters that reference other guides. There’s a lot of these > references and I don’t think it would be advantageous to introduce this > extra clutter. > With regards to the differences between the Save As dialog on Windows, > Linux and macOS. I don’t think we need to expand on this because Chapter > 0 states that there will be some differences - “Therefore, some > illustrations will not look exactly like what you see on your computer > display”. > With regards to providing other links about regular expressions. I think > we have now expanded this topic so that it is covered adequately in the > guide. For me, the purpose of our guides is not to provide exhaustive > sets of links to other sites. I don’t think it’s a copyright issue but > we do need to be aware that providing a link can be interpreted as > somehow implying a recommendation. I hope we’ve now provided enough > information for our users to get started with regex and hence don’t see > the need for providing additional links; those interested can probably > discover 100s of links via Google. This is covered by the existing text > “There are numerous websites that include examples of regular > expressions and these provide an endless source of inspiration and ideas > to help improve your data analysis skills”. > With regards to your idea about embedding spreadsheets in the Writer > file for this chapter. In principle of course this is possible but > wouldn’t be very helpful for anybody using a printed copy of the guide! > And I’m not certain how useful it would be in PDF versions of the > document. But beyond that, I am against the idea because of the work > involved in doing it consistently. The examples you’ve cited happen to > be in an area of new text, written for this update. However throughout > that Calc Guide there are many spreadsheets and spreadsheet fragments; I > don’t think it is a worthwhile investment of our time to go through all > chapters replacing relevant images with embedded spreadsheets, for very > little gain. I also feel that the associated explanatory text (“Double > click on the first box below, highlight, copy, and paste into your own > spreadsheet to follow the example”) is unnecessary clutter because it > isn’t hard to follow the examples just by reading what’s already > written. I understand that some readers might like to try it themselves > but we’re writing a guide, not a workbook. > > Regards, > > Steve > > -- Original Message -- > From: "Kevin Berry" > To: "documentation list" > Sent: 30/07/2020 22:39:42 > Subject: [libreoffice-documentation] CG7001-Introduction Reviewed and in > Feedback NextCloud > > >I have finished the first review of CG7001-Introduction-SF-GB-30Jul2020, > >and it is in the Feedback folder now. > > > >Gordon Bates > >berrykevin...@gmaill.com > >github.com/jdoes > > > >-- > >To unsubscribe e-mail to: > documentation+unsubscr...@global.libreoffice.org > >Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > >List archive: https://listarchives.libreoffice.org/global/documentation/ > >Privacy Policy: https://www.documentfoundation.org/privacy > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.document
[libreoffice-documentation] Re: CG7001-Introduction Reviewed and in Feedback NextCloud
I also changed the date formatting of the Return Date columns H and J, in Guide Staus CG.ods, so that the date formatting matches the date format in the file names, and the date formatting in columns D and E. Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Thu, Jul 30, 2020 at 2:39 PM Kevin Berry wrote: > I have finished the first review of CG7001-Introduction-SF-GB-30Jul2020, > and it is in the Feedback folder now. > > Gordon Bates > berrykevin...@gmaill.com > github.com/jdoes > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] CG7001-Introduction Reviewed and in Feedback NextCloud
I have finished the first review of CG7001-Introduction-SF-GB-30Jul2020, and it is in the Feedback folder now. Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Update on Ubuntu18
I think I'll give that and some other things a try on a VM before I do anything on my main computer. I am in the middle of reviewing one of the chapters, and I would hate to bork my LO install when I really need it to work. Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Mon, Jul 27, 2020 at 6:58 AM Dan Lewis wrote: > I think you may have found a bug. I have both LibreOffice 7.0.0.2 and > 6.4.5.2 installed. I have LibreOffice Base 6.4.5.2 in my Dash as a > favorite. Yet, When I bring the cursor over its icon, the popup window > shows LibreOffice 7.0 Base. But when I use Help > About LibreOffice, I > see LibreOffice 6.4.5.2. > > There is one other difference that I have. When I install a version of > LibreOffice, I modify the bootstraprc file to rename the folder > containing the configuration files in the home folder > (.../.config/libreoffice/). I replace the 4 on the last line with the > actual number of the LO version. For example, my .../.config/libreoffice > forlder contains these folders: 6.3, 6.4, 7.0. This allows me to run all > three versions at the same time if necessary. > > Dan > > > On 7/25/20 22:30, Kevin Berry wrote: > > Anyone familiar with updating from LibreOffice 6.0 to 6.4, on Ubuntu > 18.04? > > I am used to using the terminal, using Bash, as I do most administrative > > things in my OS from there. > > > > I already added the LibreOffice PPA and updated my system. I saw > > LibreOffice 6.4 all over the place when the update was happening, so I > > think things were updated properly. However, when I do libreoffice > > --version, it says I am still on 6.0 > > > > Anyone know how I can update from 6.0 to 6.4, in Ubuntu 18.04? > > > > Gordon Bates > > berrykevin...@gmaill.com > > github.com/jdoes > > > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Update on Ubuntu18
Anyone familiar with updating from LibreOffice 6.0 to 6.4, on Ubuntu 18.04? I am used to using the terminal, using Bash, as I do most administrative things in my OS from there. I already added the LibreOffice PPA and updated my system. I saw LibreOffice 6.4 all over the place when the update was happening, so I think things were updated properly. However, when I do libreoffice --version, it says I am still on 6.0 Anyone know how I can update from 6.0 to 6.4, in Ubuntu 18.04? Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Extended tips and the "What's This?" menu option
Can you put "(BETA)" in the menu, and people will understand that it is still under development? Do you thing the general public understands that BETA means something might not be fully functional? Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Fri, Jul 3, 2020 at 5:04 AM Olivier Hallot < olivier.hal...@libreoffice.org> wrote: > Hi Steve, All > > I am ok to inform that we are working on the issue. > > Olivier > > Em 03/07/2020 06:55, Steve (GMail) escreveu: > > All, > > > > I realise that there is a tension here - while we want to avoid > > confusing our users and readers, we would also prefer not to advertise > > our problems. > > > > In the context of extended tips and the What's This? function, what do > > people think of including a simple note that reads as follows: > > "The What's This? facility and extended tips are currently being > > improved and so in LibreOffice 7.0 they are not fully functional." > > > > Regards, > > > > Steve > > > > > > -- Original Message -- > > From: "Jean Weber" > > To: "Olivier Hallot" > > Cc: "Kevin Berry" ; "Steve (GMail)" > > ; "Documentation Team" > > > > Sent: 30/06/2020 00:51:28 > > Subject: Re: [libreoffice-documentation] Extended tips and the "What's > > This?" menu option > > > >> I think we should mention in the guides (where the Help and the > >> Options dialog are descrived) that those features are not working in > >> this release, to save people thinking they are doing something wrong. > >> Jean > >> > >> On Tue, Jun 30, 2020 at 4:10 AM Olivier Hallot > >> wrote: > >>> > >>> The extended tips are not solved yet in the Help for LibreOffice. > >>> > >>> It may be removed in the Guide, but it will return when we fix the > >>> issue. > >>> > >>> https://bugs.documentfoundation.org/show_bug.cgi?id=118148 > >>> > >>> Olivier > >>> > >>> > >>> Em 29/06/2020 14:51, Kevin Berry escreveu: > >>> > If they aren't functional, should they be removed? > >>> > Gordon Bates > >>> > berrykevin...@gmaill.com <mailto:berrykevin...@gmaill.com> > >>> > github.com/jdoes <http://github.com/jdoes> > >>> > > >>> > > >>> > On Mon, Jun 29, 2020 at 2:54 AM Steve (GMail) > >>> > mailto:stevemfanning...@gmail.com>> > >>> wrote: > >>> > > >>> > Good morning Olivier, > >>> > > >>> > Before I joined the project, I understand that these options did > >>> > something useful. (I can't define exactly what or when!) > >>> > > >>> > As reported in bug 120538, they have not worked for some time, > >>> since > >>> > the > >>> > Help system was upgraded. > >>> > > >>> > In Calc, the Help > What's This? option on the Menu bar > >>> appears to be > >>> > available (not greyed out) but doesn't appear to do anything. > >>> Similarly > >>> > the Tools > Options > LibreOffice > General > Help > Extended > >>> tips > >>> > option isn't greyed out but doesn't appear to do anything. > >>> > > >>> > In the latest Calc Guide, the text implies that these options > >>> will do > >>> > something useful. The 6.0 Writer Guide gives the same > >>> impression and I > >>> > haven't checked others. I am uncomfortable ignoring the fact > >>> that these > >>> > options don't anything and running the risk of confusing > readers. > >>> > > >>> > Do we have an agreement about how cases like this should be > >>> > addressed in > >>> > the guides? > >>> > > >>> > Regards, > >>> > > >>> > Steve > >>> > > > > > > > -- > Olivier Hallot > LibreOffice Documentation Coordinator > Comunidade LibreOffice > Rio de Janeiro - Brasil - Local Time: UTC-03:00 > http://tdf.io/joinus > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Extended tips and the "What's This?" menu option
If they aren't functional, should they be removed? Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Mon, Jun 29, 2020 at 2:54 AM Steve (GMail) wrote: > Good morning Olivier, > > Before I joined the project, I understand that these options did > something useful. (I can't define exactly what or when!) > > As reported in bug 120538, they have not worked for some time, since the > Help system was upgraded. > > In Calc, the Help > What's This? option on the Menu bar appears to be > available (not greyed out) but doesn't appear to do anything. Similarly > the Tools > Options > LibreOffice > General > Help > Extended tips > option isn't greyed out but doesn't appear to do anything. > > In the latest Calc Guide, the text implies that these options will do > something useful. The 6.0 Writer Guide gives the same impression and I > haven't checked others. I am uncomfortable ignoring the fact that these > options don't anything and running the risk of confusing readers. > > Do we have an agreement about how cases like this should be addressed in > the guides? > > Regards, > > Steve > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Re: Re[2]: Helping with the 7.0 Calc Guide
Okay, got it finished! Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Sun, Jun 28, 2020 at 2:44 PM Steve (GMail) wrote: > Thanks Gordon. > > Once you have created the folders and the tracking spreadsheet, you > shouldn't need to take any extra steps for others to access them. > > Regards, > > Steve > > > -- Original Message -- > From: "Kevin Berry" > To: "Steve (GMail)" > Cc: "Documentation Team" > Sent: 28/06/2020 22:24:32 > Subject: Re: Helping with the 7.0 Calc Guide > > I am creating the folder structure in NextCLoud. Does everybody > automatically get access to this, or does that take extra steps? > > > Gordon Bates > berrykevin...@gmaill.com > github.com/jdoes > > > On Thu, Jun 25, 2020 at 5:29 AM Steve (GMail) > wrote: > >> Hi Gordon, >> >> I hope that you are okay. >> >> During the coming days, I intend making some tidy-ups to the Calc Guide’s >> .ODT files, in preparation for the 7.0 update. This is probably a >> one-person job. >> >> However, while I am doing these edits. there are a few related matters >> that somebody could address. As you have expressed an interest in >> continuing to help with the Calc Guide, maybe you would like to address >> some or all of these? >> >>1. Somebody could create a 7.0 structure in the Calc Guide area of >>NextCloud. This will require the same folders as the 6.4 structure. It >> will >>also need a tracking spreadsheet like that used for 6.4, but with the >>various dates etc. deleted, ready to start afresh. >>2. Somebody could investigate the LO extension called “Code >>Highlighter” ( >>https://extensions.libreoffice.org/en/extensions/show/code-highlighter) >>to see whether we can use it to improve the appearance of the macro code >>segments that appear in Chapters 12 and 13 of the Calc Guide. This >>extension was discussed and recommended in a recent Documentation Team >>meeting, but I have not had time to see what impacts it will have on our >>chapters. >>3. Reading the 7.0 Release Notes, you may have noticed that Calc 7.0 >>has two new functions, RAND.NV() and RANDBETWEEN.NV(). Although we do not >>need to discuss the gory detail of these two in the Calc Guide (covered in >>Help and, eventually, on the Calc Functions wiki), their very existence >>leads to asking “what is a volatile function?”. Therefore, I think we need >>to draft a new (short) section to be put into Chapter 7 (Using Formulas >> and >>Functions) of the Calc Guide to discuss the concept of a volatile function >>in Calc. (The word “volatile” does not appear in the 6.4 version). >> Somebody >>could have a go at drafting such a section in a standalone ODT file, to be >>entitled “Volatile functions”? Sources of background information include: >> >> •The Release Notes for 7.0 ( >> https://wiki.documentfoundation.org/ReleaseNotes/7.0#New_spreadsheet_functions) >> and maybe the discussions that took place in progressing the associated bug >> (127831). >> •ODF version 1.2 ( >> http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.html) – >> see Section 3.5 “When recalculation occurs”. >> •The source code contains a function entitled >> “IsOpCodeVolatile” which determines whether a function called by a user is >> volatile or not. From this code I have gleaned that the volatile Calc >> functions are: RAND, RANDBETWEEN, NOW, TODAY, FORMULA, INFO, INDIRECT, and >> OFFSET. >> •The descriptions of the two new functions that have been >> included in the Help system at >> https://help.libreoffice.org/7.1/en-US/text/shared/05/new_help.html. >> >> Let me know if you need any more information or help. >> >> Regards, >> >> Steve >> > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Re: Helping with the 7.0 Calc Guide
I am creating the folder structure in NextCLoud. Does everybody automatically get access to this, or does that take extra steps? Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Thu, Jun 25, 2020 at 5:29 AM Steve (GMail) wrote: > Hi Gordon, > > I hope that you are okay. > > During the coming days, I intend making some tidy-ups to the Calc Guide’s > .ODT files, in preparation for the 7.0 update. This is probably a > one-person job. > > However, while I am doing these edits. there are a few related matters > that somebody could address. As you have expressed an interest in > continuing to help with the Calc Guide, maybe you would like to address > some or all of these? > >1. Somebody could create a 7.0 structure in the Calc Guide area of >NextCloud. This will require the same folders as the 6.4 structure. It will >also need a tracking spreadsheet like that used for 6.4, but with the >various dates etc. deleted, ready to start afresh. >2. Somebody could investigate the LO extension called “Code >Highlighter” ( >https://extensions.libreoffice.org/en/extensions/show/code-highlighter) >to see whether we can use it to improve the appearance of the macro code >segments that appear in Chapters 12 and 13 of the Calc Guide. This >extension was discussed and recommended in a recent Documentation Team >meeting, but I have not had time to see what impacts it will have on our >chapters. >3. Reading the 7.0 Release Notes, you may have noticed that Calc 7.0 >has two new functions, RAND.NV() and RANDBETWEEN.NV(). Although we do not >need to discuss the gory detail of these two in the Calc Guide (covered in >Help and, eventually, on the Calc Functions wiki), their very existence >leads to asking “what is a volatile function?”. Therefore, I think we need >to draft a new (short) section to be put into Chapter 7 (Using Formulas and >Functions) of the Calc Guide to discuss the concept of a volatile function >in Calc. (The word “volatile” does not appear in the 6.4 version). Somebody >could have a go at drafting such a section in a standalone ODT file, to be >entitled “Volatile functions”? Sources of background information include: > > •The Release Notes for 7.0 ( > https://wiki.documentfoundation.org/ReleaseNotes/7.0#New_spreadsheet_functions) > and maybe the discussions that took place in progressing the associated bug > (127831). > •ODF version 1.2 ( > http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.html) – > see Section 3.5 “When recalculation occurs”. > •The source code contains a function entitled > “IsOpCodeVolatile” which determines whether a function called by a user is > volatile or not. From this code I have gleaned that the volatile Calc > functions are: RAND, RANDBETWEEN, NOW, TODAY, FORMULA, INFO, INDIRECT, and > OFFSET. > •The descriptions of the two new functions that have been > included in the Help system at > https://help.libreoffice.org/7.1/en-US/text/shared/05/new_help.html. > > Let me know if you need any more information or help. > > Regards, > > Steve > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Embedding images of toolbar button icons within text paragraphs
I would not object. Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Thu, Jun 25, 2020 at 9:26 PM 驿窗 wrote: > Agree. > > > When I translateed Getting Started Guide 6.0 from English to Simplified > Chinese in 2019, I have to find the source files of those small icons, > which is very troublesome. > > > > > > > > > > > > > > > > > > At 2020-06-25 15:22:17, "Steve (GMail)" > wrote: > >All, > > > >First, many apologies if this topic has been discussed before in this > >mailing list. I have a suspicion that it may have been, but I could not > >locate the thread. > > > >The Calc Guide contains many cases where a small image is included in a > >text paragraph, showing the icon that appears on a toolbar button > >mentioned in the paragraph. My view is that these images are undesirable > >for the following reasons: > >I assume that they are included to help the user to identify the > >relevant icon on his screen. However, given that the user is able to > >customize his / her copy of LO by selecting from one of many icon sets > >(via the Tools > Options > LibreOffice > View dialog), I think that in > >many cases the images may hinder a user rather than help. We are in > >danger of confusing and delaying him / her by showing an image of an > >icon that is not displayed on his / her screen.Because these images are > >inevitably taller than the normal line of text, they often cause extra > >white space to appear within text paragraphs which I think is ugly and > >does not improve readability. > >I am not convinced that such images embedded in paragraphs provide the > >reader with any useful information or context and would prefer not to > >use them. Instead I would make sure that every reference to a toolbar > >item names the button correctly and consistently. By correctly, I mean > >that we use exactly the name that appears in the button’s tooltip when > >using the English(US) version of Calc (omitting any mention of shortcut > >key sequences). > > > >Would anybody object if these images were to be removed when we produce > >the 7.0 Calc Guide? > > > >Regards, > > > >Steve > >-- > >To unsubscribe e-mail to: > documentation+unsubscr...@global.libreoffice.org > >Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > >List archive: https://listarchives.libreoffice.org/global/documentation/ > >Privacy Policy: https://www.documentfoundation.org/privacy > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] 6.4 Calc Guide
Its really cool to be part of a project like this, thanks for allowing me to participate in the review process! Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Sun, Jun 21, 2020 at 5:55 PM Drew Jensen wrote: > Howdy Steve, > > > On Sun, Jun 21, 2020 at 4:28 PM Steve (GMail) > wrote: > > > > All, > > > > The 6.4 Calc Guide is, I believe, almost ready for publication. The PDF > > version is available for inspection in the relevant Published folder in > > Nextcloud (CG64-CalcGuide.pdf). > > > > If anybody wishes to have glance at the PDF over the next 24 hours then > > feel free to do so; please email me if you spot any problems. > > > > I am not happy with the front and back pages. These are SVG format > > images in the .ODT file but lose something in the translation to PDF. Is > > this a known effect and is there a recommended solution? > > Right - if you check the PDF files from the earlier guides you find > that the covers, front and back, are 100% graphics (including the > text). > This is because the SVG source files were used to generate a PNG file > equal to the page format (A4) and that image is what is used as the > page background for the cover pages. > That is not the only way it could be done, but the SVG file itself is > not suitable for use directly in LibreOffice and you want to always > generate the graphic from that source file as a PNG for use in the > final document. > > Best wishes, > > Drew > > > > > One aspect of the document has not yet been reviewed by anybody and that > > is the alphabetical index at the back. I would encourage any team > > members to inspect this and let us know your thoughts. I hope it is a > > useful addition for the intended readers of the guide but others might > > think otherwise. It is straightforward to remove it before publication > > if that proves necessary. > > > > Finally, please could one of our experienced publishers advise me of the > > steps necessary to actually publish a guide (beyond placing all the > > files in the Published folder)? > > > > Regards, > > > > Steve Fanning > > -- > > To unsubscribe e-mail to: > documentation+unsubscr...@global.libreoffice.org > > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/documentation/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] CG6415 Calc Keyboard Shortcuts on macOS
I have completed the macOS review of keyboard shortcuts, using macOS Sierra 10.12.16, and it has been uploaded to the Feedback folder in NextCloud. I found that there were a couple of shortcuts that were actually system shortcuts, and also, some of the mac keyboard symbols didnt show properly on macOS, whereas they showed just fine on Windows. I like this stuff, thanks for allowing me to participate!!! Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Question: Recording Changes vs Track Changes
I have a couple of questions about recording vs tracking changes. What is the difference between going to File > Properties > Security > Record Changes versus Edit > Track Changes > Record ? Also, when I am on macOS, there is a check mark in the Edit menu that clearly indicates when Edit > Track Changes > Record is active, whereas I dont see that at all in Windows- havent tried it in Linux. Also, another thing I noticed is that there is View > Track Changes, which I have noticed is what makes the colored strike-through, which shows me the changes that have been made. So my question is: What is the difference between "Track Changes" and "Record Changes", and what is "Record Changes" actually doing? Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Re: Re[2]: Calc Error Codes Rev 1
Thank you for catching that mistake. Yes, it is a 532, not 503. I didnt see the =ERRORTYPE(cell-address) in the chapter- maybe I just overlooked it. Is that something that might be able to be added in there? Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Fri, Jun 5, 2020 at 12:46 PM Steve Fanning wrote: > Hi Gordon, > > To find the error code, use the ERRORTYPE function. > > For example, if the cell containing the erroneous formula is B2, then put > the formula =ERRORTYPE(B2) in some other blank cell. Hope that helps. > > Regards, > > Steve > > > -- Original Message -- > From: "Kevin Berry" > To: "Steve Fanning" > Cc: "documentation list" > Sent: 05/06/2020 19:52:27 > Subject: Re: Calc Error Codes Rev 1 > > Yeah, the #DIV/0 might actually be a 532, huh? How do I make Calc show me > the error Code, not just the error Message? > > What made me add that in there was that the explanation of that error is " > *Division by 0*, or another calculation that results in an overflow of > the defined value range (*a value too big or too small*)." > Dividing by zero is the "too big" part of that. > > I attached the spreadsheet I was using to replicate some of these errors. > The part that is relevant to this email is A2:E4 > > Gordon Bates > berrykevin...@gmaill.com > github.com/jdoes > > > On Fri, Jun 5, 2020 at 2:07 AM Steve Fanning > wrote: > >> Hi Gordon, >> >> Thanks for that. I have accepted most of the changes and placed the >> updated file in the Draft folder, ready for second review. >> >> I did not accept one of the changes (in Table 2) because I'm not sure >> that it is correct. As far as I was aware, error 503 gives a #NUM! error in >> the cell, not a #DIV/0! error (unless you've come across a >> counterexample?). >> >> Regards, >> >> Steve >> >> >> >> -- Original Message -- >> From: "Kevin Berry" >> To: "Stephen Fanning" ; "documentation list" >> >> Sent: 04/06/2020 20:34:51 >> Subject: Calc Error Codes Rev 1 >> >> I have completed review1 of the error codes section, and placed it in the >> feedback folder. >> >> Gordon Bates >> berrykevin...@gmaill.com >> github.com/jdoes >> >> -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Re: Calc Error Codes Rev 1
Yeah, the #DIV/0 might actually be a 532, huh? How do I make Calc show me the error Code, not just the error Message? What made me add that in there was that the explanation of that error is " *Division by 0*, or another calculation that results in an overflow of the defined value range (*a value too big or too small*)." Dividing by zero is the "too big" part of that. I attached the spreadsheet I was using to replicate some of these errors. The part that is relevant to this email is A2:E4 Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Fri, Jun 5, 2020 at 2:07 AM Steve Fanning wrote: > Hi Gordon, > > Thanks for that. I have accepted most of the changes and placed the > updated file in the Draft folder, ready for second review. > > I did not accept one of the changes (in Table 2) because I'm not sure that > it is correct. As far as I was aware, error 503 gives a #NUM! error in the > cell, not a #DIV/0! error (unless you've come across a counterexample?). > > Regards, > > Steve > > > > -- Original Message -- > From: "Kevin Berry" > To: "Stephen Fanning" ; "documentation list" < > documentation@global.libreoffice.org> > Sent: 04/06/2020 20:34:51 > Subject: Calc Error Codes Rev 1 > > I have completed review1 of the error codes section, and placed it in the > feedback folder. > > Gordon Bates > berrykevin...@gmaill.com > github.com/jdoes > > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Calc Error Codes Rev 1
I have completed review1 of the error codes section, and placed it in the feedback folder. Gordon Bates berrykevin...@gmaill.com github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Calc Guide – first reviews
Okay, Ill grab the error codes one. Did anyone pick up the keyboard shortcuts on Mac? I see someone returned that chapter on June 3, but it's not indicated on the spreadsheet f they reviewed it for macOS. Should I use macOS to do the chapter CG6415KeyboardShortcuts, or has that already been gotten? Gordon Bates berrykevin...@gmaill.com github.com/jdoes On Thu, Jun 4, 2020 at 8:55 AM Steve Fanning wrote: > All, > > The reviews of the Calc Guide are progressing, with all but one chapter > having completed its first review. > > The unreviewed chapter is very short and should be easy to check because > it has not changed significantly since 6.2, when it went through a full > review cycle. However don’t look for the 6.2 version in the PDF file (it > was omitted by mistake) but dig out the 6.2 source file from Nextcloud > if you want to refer to it. > > So if you have a little time to spare, please consider reviewing > Appendix B (also known as chapter 16), entitled Calc Error Codes. > > Regards, > > Steve > > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Date on Reviewed FIles
Okay, another question- I dont meant o be irritating or anything, sorry :) Thanks for all of your replies. I noticed the file guide names have dates like 27May2020, but then in the spreadsheet, people are putting in dates like 27/05/20. I looked at the Draw guide's status spreadsheet, and they have all of theirs in numerical only format, like 27/05/20. In the Calc status spreadsheet, do I spell out the month, or do I keep it as only numerical? Should the Calc status spreadsheet have 27May2020, or should it have 27/05/20? Gordon Bates github.com/jdoes On Wed, May 27, 2020 at 10:55 PM Kevin Berry wrote: > Thank you Jean and Kees. > > OOOooohh, okay: > "This is also the date you enter in the Guide status sheet." > > That is an easy way to remember it! > > Gordon Bates > github.com/jdoes > > > On Wed, May 27, 2020 at 9:44 PM wrote: > >> In my opinion it is the return date. >> This is also the date you enter in the Guide status sheet. >> >> Kees >> >> Kevin Berry schreef op 28.05.2020 01:13: >> > Do I append the date when I downloaded the file for review, or do I >> > append >> > the return date into the filename? >> > >> > Gordon Bates >> > github.com/jdoes >> >> -- >> To unsubscribe e-mail to: >> documentation+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/documentation/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-documentation] Date on Reviewed FIles
Thank you Jean and Kees. OOOooohh, okay: "This is also the date you enter in the Guide status sheet." That is an easy way to remember it! Gordon Bates github.com/jdoes On Wed, May 27, 2020 at 9:44 PM wrote: > In my opinion it is the return date. > This is also the date you enter in the Guide status sheet. > > Kees > > Kevin Berry schreef op 28.05.2020 01:13: > > Do I append the date when I downloaded the file for review, or do I > > append > > the return date into the filename? > > > > Gordon Bates > > github.com/jdoes > > -- > To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/documentation/ > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Calc 6.4 FormulasAndFunctions
I have uploaded the second review of CG6407-FormulasAndFunctions into the Feedback folder in nextcloud, and I have recorded it in the Guide Stats spreadsheet. Gordon Bates github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Date on Reviewed FIles
Do I append the date when I downloaded the file for review, or do I append the return date into the filename? Gordon Bates github.com/jdoes -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] LibreOfice Calc First Timer
Hello, I am doing a secondary review as my first time doing anything with you guys. This is actually my first time every participating in an open source project whatsoever. I am a high school science and math teacher, who uses spreadsheets a LOT, which is what makes me want to be involved in the Calc documentation. After downloading, changing the filename, turning on Track Changes: Record, as per Steve Fanning's instructions, I think I am on the right track so far. a) I have Track Changes: Record turned on (I think), which I did by Edit > Track Changes > Record (or by Ctrl+Shift+C): [image: image.png] I think I confirmed this by checking File > Properties > Security > Record Changes [image: image.png] [image: image.png] b) I also got my name to show in my comments, by going to Tools > Options: [image: image.png] And then LibreOffice > User Data: [image: image.png] Which I confirmed by making a comment (or by Ctrl+Alt+C): [image: image.png] and then seeing my name there now, when it was not before: [image: image.png] I have downloaded the file from the Drafts folder in NextCLoud, onto my local machine, and changed the file name on my copy, which I will then put into the Feedback folder when I am done. However, to be honest, I have not yet placed my initials into the Guide Stats CG spreadsheet, because I am a bit nervous that I am not doing something correctly here, and I dont want to get ahead of myself. So, as a noob, I am asking for some of your guys' first time experiences, and am also wondering if I am going about this the right way so far. DO you guys have safeguards in place, so I dont irreparably damage anything? Is there some critical mistake that anyone sees me making already? Is there one piece of advice that you would travel back in time to tell your younger self, which would have made your first time experience a lot more enjoyable? Is there anything that you can share with me that you wish someone would have shared with you on your first time around? Thanks for any advice you can give me. Im just trying to not get in anybody's way, or make some kind of amateur mistake that will cause a disruption to everyone else's productivity. -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Calc Documentation Reviewer
Hello, this is Gordon Bates. My SSO username is berrykevin. I am interested in getting involved in the LibreOffice open source project, by helping out with the Calc Guide documentation- specifically as a "Reviewer", as described here: https://wiki.documentfoundation.org/Documentation/DocumentationTeamInfo/JoinDocTeam . I am new to this, meaning I have never contributed to an open source project, and I have never been part of a software developemtn or documentation team before. Any guidance or suggestions would be very much appreciated. I plan on attending the meeting next Thursday, May 28th at 18:00 UTC Thanks, Gordon Bates *If you really think about it, everything in the entire Universe is either ice cream, or it is not ice cream.* -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-documentation] Libre Office Documentation Subscription
Hello, I am interested in helping on documentation for Libre Office.
