[libreoffice-users] Question about testing changes made to MS Word documents
How-dee! I have a question about testing changes made to MS Word documents. Someone sent me a Word DOCX file that needed to be updated and I managed to update it in LibreOffice Writer 7.1.5.2 on Ubuntu 21.04 Linux. I wanted to test the saved file by loading it in MS Word. Since I don't have access to MS Office, I uploaded it to Word online using my Hotmail account. The document loaded but when I went to print it, the generated PDF was pretty much trashed. So, what's a good/reliable way to test changes saved in DOCX format in Writer? Is using Word online, as I did, akin to loading it in MS Word 2016? I believe the document was last edited in MS Word 2016 before it was sent to me. Thanks in advance! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6
On 10/2/20 7:55 AM, Tom Williams wrote: > On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote: >> Le 2020-10-01 01:13, Tom Williams a écrit : >>> Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to >>> add a formula. The spreadsheet is "simple", in that it had about 90 >>> rows of data, with only one column being a numeric value. Everything >>> else was plain text. I added the formula (to sum the numbers in the one >>> numeric column) and when I saved the file, in XLSX format, I noticed the >>> file size was smaller. >>> >>> Here is what I found: >>> >>> Original file: 22kb >>> >>> Calc 6.4.6 on Ubuntu 20.04: 16kb >>> >>> Calc 5.1.6 (I think) on Mint 18.3: 9kb >>> >>> Why would saving the file in Calc reduce the file size? >>> >>> Thanks in advance! >>> >>> Peace... >>> >>> "The Other" Tom >>> >>> -- >>> /When I leave, I don't know what I'm hoping to find, >>> And when I leave, I don't know what I'm leaving behind.../ >> Hello Tom >> >> A pleasure to have a librarian lol, well already the previous versions >> of LibreOffice converted to Ms Office format are necessarily more >> dancing in size as you have noticed, I will advise you to publish the >> latest version of LibreOffice 7.0.1.2 >> >> then to come back to your question I don't have a screenshot but I >> send you mine which also shows a document at the base ods of 33.6 kiB >> converted to xlsx format of 26.9 kiB but when you look at the content >> level the xlsx version is in excel zip so compressed at the base where >> the xlsx size will be smaller than the ods version in size because it >> is compressed at the source. >> >> I hope to have answered your concern if not please specify your >> question to me with screenshots so that I understand well why it is >> not a question. >> >> cordially >> Sandra LOUVEZO > Thanks for the reply! I'll try LibreOffice 7 and see what happens. I > think I have it installed in a virtual Windows 10 environment I > sometimes use. > > Thanks! > > Peace... > > "The Other" Tom > So, I tried this in LibreOffice 7.0.1 on Windows 10 and found the spreadsheet saved to a file size of 17kb. This isn't a "problem" or anything and I was mostly curious about the difference in file size. :) Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6
On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote: > Le 2020-10-01 01:13, Tom Williams a écrit : >> Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to >> add a formula. The spreadsheet is "simple", in that it had about 90 >> rows of data, with only one column being a numeric value. Everything >> else was plain text. I added the formula (to sum the numbers in the one >> numeric column) and when I saved the file, in XLSX format, I noticed the >> file size was smaller. >> >> Here is what I found: >> >> Original file: 22kb >> >> Calc 6.4.6 on Ubuntu 20.04: 16kb >> >> Calc 5.1.6 (I think) on Mint 18.3: 9kb >> >> Why would saving the file in Calc reduce the file size? >> >> Thanks in advance! >> >> Peace... >> >> "The Other" Tom >> >> -- >> /When I leave, I don't know what I'm hoping to find, >> And when I leave, I don't know what I'm leaving behind.../ > > Hello Tom > > A pleasure to have a librarian lol, well already the previous versions > of LibreOffice converted to Ms Office format are necessarily more > dancing in size as you have noticed, I will advise you to publish the > latest version of LibreOffice 7.0.1.2 > > then to come back to your question I don't have a screenshot but I > send you mine which also shows a document at the base ods of 33.6 kiB > converted to xlsx format of 26.9 kiB but when you look at the content > level the xlsx version is in excel zip so compressed at the base where > the xlsx size will be smaller than the ods version in size because it > is compressed at the source. > > I hope to have answered your concern if not please specify your > question to me with screenshots so that I understand well why it is > not a question. > > cordially > Sandra LOUVEZO Thanks for the reply! I'll try LibreOffice 7 and see what happens. I think I have it installed in a virtual Windows 10 environment I sometimes use. Thanks! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6
Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to add a formula. The spreadsheet is "simple", in that it had about 90 rows of data, with only one column being a numeric value. Everything else was plain text. I added the formula (to sum the numbers in the one numeric column) and when I saved the file, in XLSX format, I noticed the file size was smaller. Here is what I found: Original file: 22kb Calc 6.4.6 on Ubuntu 20.04: 16kb Calc 5.1.6 (I think) on Mint 18.3: 9kb Why would saving the file in Calc reduce the file size? Thanks in advance! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Advice needed on reporting a bug
Hi! I have a Word document that I downloaded from an online Sharepoint site that appears mis-formatted in LibreOffice Writer 6.2.7.1 on Ubuntu 19.04 Linux. It appears as if the page breaks are off. In any event, the document is a legal document so I'm not willing to post the document "as is" in a bug report, if I end up filing one. What would be a good alternative to preserve the information that shows the formatting issues but not include the other legal information, in the document? Thanks in advance! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Help needed with Excel spreadsheet
On 3/6/19 5:42 PM, Tom Davies wrote: > Hi :) > Sounds like a perfect time to suggest they install LO too. > > If an Excel person hadn't immediately found what they were looking for in > Calc they would have immediately claimed that Calc couldn't do the task. > > There are loads of articles about LO that have such posts in the comments > section. It can be fun to refute them in as few words as possible. > Regards from a Tom :) You know, I'm about ready to do that. After doing some experimentation with Excel today, I found it just doesn't want to "play nice" with what I'm trying to do. I want to have an image as the spreadsheet header and have the basic formulas update when I add/remove rows. I'm sure with enough time, I could get Excel to behave but I've been able to get what I needed working far more easily with Calc. I haven't given up, just yet, but I'm really surprised at how stubborn Excel is, when it comes to the things I'm trying to do with it. :( Peace... "The Other" Tom > > > On Wed, 6 Mar 2019 18:21 Luuk >> On 6-3-2019 17:48, Tom Williams wrote: >>> On 3/6/19 8:26 AM, Tom Williams wrote: >>>> I know it's odd to ask for Excel help in this mailing list but I need >>>> help locating a LibreOffice Calc function/feature in Excel. :) >>>> >>>> I'm helping a friend create a billing invoice and since I'm a Linux >>>> user, I'm using Calc to build the template. So far, it's working well >>>> and given I'm not an Excel user, I find myself struggling some in >>>> getting Excel to "behave". Anyway, I recently discovered the "/Expand >>>> reference when new rows are inserted/" in Calc. It does exactly what I >>>> needed. When I add/remove a row in/from the spreadsheet, my total >>>> "SUM()" formula is updated automagically. >>>> >>>> Does the equivalent feature exist in Excel? What I've found is, when >>>> adding rows *after* the last row in my SUM() formula, the new row is >>>> excluded from the SUM() formula. So, my formula is "=SUM(D7:D27)". >>>> Once I add row 28, I need the SUM() formula to be updated to >>>> "=SUM(D7:D28)". Conversely, when row 28 is removed, I want the SUM() >>>> formula to be updated to "=SUM(D7:D27". In Calc, the "/Expand >>>> reference when new rows are inserted/" feature does this work for me. >>>> >>>> I did some web searching and found this article: >>>> >>>> >> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html >>>> but I hope to find an easier and more flexible way to accomplish what I >>>> need. Or is that approach what I really should use? >>>> >>>> Thanks in advance! >>>> >>>> Peace... >>>> >>>> "The Other" Tom >>>> >>>> >>> Nevermind! I found this: >>> >>> https://bettersolutions.com/excel/formulas/automatic-expansion.htm >>> >>> That should do what I need! >>> >>> Thanks anyway! :) >>> >>> Peace... >>> >>> "The Other" Tom >>> >> When i was reading above, i thought you were search for subtotals. >> >> Excel has also a function named SUBTOTAL() >> >> >> https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939 >> >> >> >> >> -- >> To unsubscribe e-mail to: users+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/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Help needed with Excel spreadsheet
On 3/6/19 10:18 AM, Luuk wrote: > > On 6-3-2019 17:48, Tom Williams wrote: >> On 3/6/19 8:26 AM, Tom Williams wrote: >>> I know it's odd to ask for Excel help in this mailing list but I need >>> help locating a LibreOffice Calc function/feature in Excel. :) >>> >>> I'm helping a friend create a billing invoice and since I'm a Linux >>> user, I'm using Calc to build the template. So far, it's working well >>> and given I'm not an Excel user, I find myself struggling some in >>> getting Excel to "behave". Anyway, I recently discovered the "/Expand >>> reference when new rows are inserted/" in Calc. It does exactly what I >>> needed. When I add/remove a row in/from the spreadsheet, my total >>> "SUM()" formula is updated automagically. >>> >>> Does the equivalent feature exist in Excel? What I've found is, when >>> adding rows *after* the last row in my SUM() formula, the new row is >>> excluded from the SUM() formula. So, my formula is "=SUM(D7:D27)". >>> Once I add row 28, I need the SUM() formula to be updated to >>> "=SUM(D7:D28)". Conversely, when row 28 is removed, I want the SUM() >>> formula to be updated to "=SUM(D7:D27". In Calc, the "/Expand >>> reference when new rows are inserted/" feature does this work for me. >>> >>> I did some web searching and found this article: >>> >>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html >>> >>> >>> but I hope to find an easier and more flexible way to accomplish what I >>> need. Or is that approach what I really should use? >>> >>> Thanks in advance! >>> >>> Peace... >>> >>> "The Other" Tom >>> >>> >> Nevermind! I found this: >> >> https://bettersolutions.com/excel/formulas/automatic-expansion.htm >> >> That should do what I need! >> >> Thanks anyway! :) >> >> Peace... >> >> "The Other" Tom >> > When i was reading above, i thought you were search for subtotals. > > Excel has also a function named SUBTOTAL() > > https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939 > > > > > Thanks for the info! Sorry I wasn't more clear. :( I just needed the SUM formulas to update as I added/deleted rows. :) Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Help needed with Excel spreadsheet
On 3/6/19 8:26 AM, Tom Williams wrote: > I know it's odd to ask for Excel help in this mailing list but I need > help locating a LibreOffice Calc function/feature in Excel. :) > > I'm helping a friend create a billing invoice and since I'm a Linux > user, I'm using Calc to build the template. So far, it's working well > and given I'm not an Excel user, I find myself struggling some in > getting Excel to "behave". Anyway, I recently discovered the "/Expand > reference when new rows are inserted/" in Calc. It does exactly what I > needed. When I add/remove a row in/from the spreadsheet, my total > "SUM()" formula is updated automagically. > > Does the equivalent feature exist in Excel? What I've found is, when > adding rows *after* the last row in my SUM() formula, the new row is > excluded from the SUM() formula. So, my formula is "=SUM(D7:D27)". > Once I add row 28, I need the SUM() formula to be updated to > "=SUM(D7:D28)". Conversely, when row 28 is removed, I want the SUM() > formula to be updated to "=SUM(D7:D27". In Calc, the "/Expand > reference when new rows are inserted/" feature does this work for me. > > I did some web searching and found this article: > > https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html > > but I hope to find an easier and more flexible way to accomplish what I > need. Or is that approach what I really should use? > > Thanks in advance! > > Peace... > > "The Other" Tom > > Nevermind! I found this: https://bettersolutions.com/excel/formulas/automatic-expansion.htm That should do what I need! Thanks anyway! :) Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Help needed with Excel spreadsheet
I know it's odd to ask for Excel help in this mailing list but I need help locating a LibreOffice Calc function/feature in Excel. :) I'm helping a friend create a billing invoice and since I'm a Linux user, I'm using Calc to build the template. So far, it's working well and given I'm not an Excel user, I find myself struggling some in getting Excel to "behave". Anyway, I recently discovered the "/Expand reference when new rows are inserted/" in Calc. It does exactly what I needed. When I add/remove a row in/from the spreadsheet, my total "SUM()" formula is updated automagically. Does the equivalent feature exist in Excel? What I've found is, when adding rows *after* the last row in my SUM() formula, the new row is excluded from the SUM() formula. So, my formula is "=SUM(D7:D27)". Once I add row 28, I need the SUM() formula to be updated to "=SUM(D7:D28)". Conversely, when row 28 is removed, I want the SUM() formula to be updated to "=SUM(D7:D27". In Calc, the "/Expand reference when new rows are inserted/" feature does this work for me. I did some web searching and found this article: https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html but I hope to find an easier and more flexible way to accomplish what I need. Or is that approach what I really should use? Thanks in advance! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about signed documents
On 1/31/19 7:50 AM, James Knott wrote: On 01/31/2019 10:33 AM, Tom Williams wrote: Hi! I recently learned LibreOffice 6 supports PGP signed documents. My question: why would anyone want to digitally sign a document? When you take out a loan, etc., don't you sign the document? There are many times you sign things. This is just a digital way to verify you did. Without this, you'd have to print out the document, sign it and then get it to the recipient. With digital signing, you digitally sign it and then can email it, right from LibreOffice. Now, this is interesting. So, the digital signing you describe would generate a digital version of my signature? I have experience with digitally signing a document, using a third party service, like DocuSign. In those cases, a "signature" font is used to represent my actual signature. I initially though the digital signing LibreOffice supported added a digital signature to the document, itself, providing some verification that I am who I claim to be. Does it also add the signature, in the manner you describe? Thanks! Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about signed documents
On 1/31/19 7:38 AM, hy...@lactose.homelinux.net wrote: Tom Williams writes: why would anyone want to digitally sign a document? The two most obvious answers are: (*) confirm authorship (*) verify integrity of contents I'm sure there are plenty of other reasons as well. Thanks for the reply. :) The reason I asked is, I've never considered the need to digitally sign a document I created or modified in LibreOffice. So, I was wondering why anyone would want to do so. Your examples make sense. Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Question about signed documents
Hi! I recently learned LibreOffice 6 supports PGP signed documents. My question: why would anyone want to digitally sign a document? Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] centring text boxes
On 09/25/2018 03:49 AM, DaveB wrote: > On 25.09.2018 09:59, Mike Scott wrote: >> Today's daft question. >> >> Why can't you automatically centre up a text box on the page in Writer? >> >> If I have an image, I do R-click, Alignment, and pick from a useful >> selection of options. >> >> Try the same on a text box and I get "". >> >> It makes laying out a page (and I've just started on an order of >> service for a funeral) decidedly frustrating. >> >> (Nor for that matter do styles work in a text box. I fail to >> understand the issues here.) > Hi Mike, > > Not a daft question, but Draw might be a better choice for what you are > doing. To center align text boxes in Writer you need to first change the > anchoring. When you initially draw the text box it is, by default, > anchored to the paragraph, which allows the box to be manually > positioned anywhere on the page. Select "Anchor" from the right click > context menu and choose "As Character", then set the paragraph to be > center aligned. > > Hope this helps. > > Dave > > Wow, I just did this same thing, over the weekend. Dave is right on the money. Changing the anchor should do the trick. Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question about tables and page margins in Writer
Thanks for the tip! I'll give it a try. Peace... "The Other" Tom On 08/12/2018 03:41 PM, Remy Gauthier wrote: > Hi, > > You could insert a 1-inch header that is empty. You can alter the page > style or directly format the page: > > Format -> Page -> Header, then: > > - Header ON > - Autofit height: OFF > - Height: 1 inch > > Note that I am using LO 6.0, so it might be slightly different for you > but I think that those settings will work in your version. > > I hope this helps. > > Rémy. > Le dimanche 12 août 2018 à 13:40 -0700, Tom a écrit : >> Hi! I'm running Writer 5.1.6.2 on Linux Mint 18 and had a question >> about tables and page margins. I'm creating a playlist in Writer and >> have an image filling the entire background of the page. I have 0 >> margins so the image covers all available whitespace. I have a table >> with a header row that repeats on each page. Everything looks fine >> except when the table spills over to page #2. The header row is >> repeated but the top of the table is flush against the top of the page. >> I would like a 1", maybe, gap between the top of the table, on page #2, >> and the top of the page. >> >> Any idea on how to accomplish this? >> >> Thanks! >> >> Peace... >> >> "The Other" Tom >> >> -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?
On 04/29/2018 08:23 AM, James Knott wrote: > On 04/29/2018 10:23 AM, Tim-L wrote: >> There was a question in it about wondering how to get the users of >> Linux to save LibreOffice files to Microsoft Word formats. > Why would we want to, unless we had to? > To make it easier to more readily exchange documents with others. I don't help many LibreOffice on Linux users but I do help a number of LibreOffice on Windows users and I usually configure LibreOffice to save in Microsoft formats, by default. Most of these people don't understand different file formats and want to be able to "just send" files to friends, family, or other members of a group or something. Being a Linux user, myself, I save files in Microsoft format only when I *know* I need to send a Word or Excel file to someone else. Otherwise, any files I need to send to people are saved as PDF. I've never heard of the Linux Users Facebook Group until today. :) Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problem with LibreOffice 5
On 07/15/2017 03:56 PM, anne-ology wrote: >Curiously wondering if you're saying one can go to MsFt's heads with > problems & these will be fixed pronto; > if so, I'd like to hear an example of when you so did. > >And just what is NT4??? "NT4" = Windows NT version 4 Peace... "The Other" Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problem with LibreOffice 5
On 07/09/2017 02:33 PM, Tom Davies wrote: > Hi :) > There was a Win 10 update that messed up the permissions in one of the > places i volunteer at. > > I have no idea how to fix it. I think we went through each individual > folder to reset the permissions but that sounds like a very > inefficient and highly error-prone way of trying to fix it generally. > Still, 'everyone' loves Windows. > > Regards from > Tom :) Wow. Craziness. :) Peace... "The Other" Tom > > > > On 9 July 2017 at 17:46, Tom Williams <tomd...@comcast.net > <mailto:tomd...@comcast.net>> wrote: > > On 07/08/2017 02:56 AM, MICHAEL HELY wrote: > > I am having trouble with this suite. Normally I have been able > to open, amend, and save a document without any problem. > However, in the last week or so I can only open a document in > read-only form. To change the contents I have to open a copy for > editing, save that under a different name, delete the original, > and then rename the new document to fit in with my filing system. >This is time consuming, and very inconvenient. > > The only event that I can identify as a possible cause is that > about the same time there was an automatic update to Windows 10, > and there might be some incompatablity between the updated Windows > and LibreOffice.(I have since installed the latest update to > LibreOffice5, but to no avail; the problem is still there). > However that is only a wild guess! I would be grateful for > your advice and a remedy > > regards > > M. Hely > > > I have two basic questions: > > 1. Have you confirmed the original file wasn't already "read-only" > before attempting to open it? > 2. Are you opening files from the file system or directly from an > email > attachment? > > > These are things you have probably already thought of but I want > to ask > anyway. :) I've run LibreOffice 5 on a couple of Windows 10 systems > and have been able to open, edit, and save documents without issue. > > Peace... > > "The Other" Tom > > -- > /When we dance, you have a way with me, > Stay with me... Sway with me.../ > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > <mailto:users%2bunsubscr...@global.libreoffice.org> > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > <http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: > http://wiki.documentfoundation.org/Netiquette > <http://wiki.documentfoundation.org/Netiquette> > List archive: http://listarchives.libreoffice.org/global/users/ > <http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and > cannot be deleted > > -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problem with LibreOffice 5
On 07/08/2017 02:56 AM, MICHAEL HELY wrote: > I am having trouble with this suite. Normally I have been able to open, > amend, and save a document without any problem.However, in the last week > or so I can only open a document in read-only form. To change the contents > I have to open a copy for editing, save that under a different name, delete > the original, and then rename the new document to fit in with my filing > system. This is time consuming, and very inconvenient. > The only event that I can identify as a possible cause is that about the same > time there was an automatic update to Windows 10, and there might be some > incompatablity between the updated Windows and LibreOffice.(I have since > installed the latest update to LibreOffice5, but to no avail; the problem is > still there).However that is only a wild guess! I would be grateful > for your advice and a remedy > regards > M. Hely > I have two basic questions: 1. Have you confirmed the original file wasn't already "read-only" before attempting to open it? 2. Are you opening files from the file system or directly from an email attachment? These are things you have probably already thought of but I want to ask anyway. :) I've run LibreOffice 5 on a couple of Windows 10 systems and have been able to open, edit, and save documents without issue. Peace... "The Other" Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] OS hangs while visiting a LO wiki page
On 09/16/2015 01:39 PM, Ady Ady wrote: > On Wed, Sep 16, 2015 at 10:53 PM, > <libreoffice-ml.mbou...@spamgourmet.com> wrote: >> Simos Xenitellis wrote: >>> (obviously we are off-topic) >>> >>> On Wed, Sep 16, 2015 at 8:46 PM, <libreoffice-ml.mbou...@spamgourmet.com> >>> wrote: >>> >>>> Tom Williams wrote: >>>> >>>>> On 09/15/2015 01:43 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: >>>>> >>>>>> Ady Ady wrote: >>>>>> >>>>>>> Hello Users of LibreOffice, >>>>>>> >>>>>>> Once in a while I visit the Release Plan wiki page, >>>>>>> https://wiki.documentfoundation.org/ReleasePlan >>>>>>> >>>>>>>From that wiki page, I recently tried to visit the "5.0.2" -> "RC1" >>>>>>> page (more than once), but my OS hangs when I click on the relevant >>>>>>> link. >>>>>>> >>>>>>> Of course, it could be just a coincidence. I am reluctant to try to >>>>>>> reach these pages again, especially considering that every new wiki >>>>>>> page in the series is based on the prior one. >>>>>>> >>>>>>> I am using Windows Vista Home Basic 32-bit, with Internet Explorer 9 >>>>>>> and Mozilla Firefox 40.0.3, all updated. >>>>>>> >>>>>>> The strange behavior happened with both web browsers. >>>>>>> >>>>>>> I don't know whether some security tool being in use (e.g. Avast) >>>>>>> might be relevant. >>>>>>> >>>>>>> I wanted to share this unusual experience, in case someone else >>>>>>> happens to see it too (or something similar, or at least uncommon), >>>>>>> and/or maybe it might be worth someone checking the source of these >>>>>>> wiki pages (and their related nested templates). >>>>>>> >>>>>>> I am aware that this behavior (hanging OS) would be considered >>>>>>> "unlikely to be triggered by some wiki page". The fact that it >>>>>>> happened to me more than once while following the same links (but >>>>>>> nowhere else) pushed me to at least comment on it. >>>>>>> >>>>>> Interesting... I don't see a problem with that page at the moment. >>>>>> However, since mid July I have been experiencing occasional OS hangs >>>>>> which seem to be triggered by visiting certain web pages or sometimes >>>>>> scrolling down the page slightly even after it's been loaded for a >>>>>> while. Revisiting the same page doesn't necessarily trigger another >>>>>> hang, but some pages seem to be more prone to it than others. >>>>>> >>>>>> I use Windows Vista Business 32-bit, Mozilla SeaMonkey 2.33.1 (based >>>>>> on Firefox 36), Avast antivirus. >>>>>> >>>>>> One site (www.discount-electrical.co.uk) seemed to be particularly >>>>>> troublesome. At one point I couldn't even add a few items to the >>>>>> shopping cart and check out before the OS hung. Hangs seemed to be >>>>>> less frequent using Chrome instead, but I did still get a few. I >>>>>> didn't try IE. >>>>>> >>>>>> I haven't had so much trouble since mid August, but then again I >>>>>> haven't been visiting the sites which seemed to be triggering the >>>>>> problem so much lately either. Still get a couple of unexplained hangs >>>>>> a week though. >>>>>> >>>>>> I can't be certain that visiting the web sites is/was the trigger, or >>>>>> whether that's just coincidental. As you say, it does seem unlikely! >>>>>> If anything, I'd suspect some interaction with a Windows update or >>>>>> perhaps Flash or Avast, since I'd just got back from holiday and >>>>>> installed a load of updates just before the problems started. Another >>>>>> possibility for me is overheating or failing hardware (this is a 9 >>>>>> year old laptop so getting on a bit!) but I haven't got around to >>>>>> investigating further. >>>>>> >>>>>> Mark. &
Re: [libreoffice-users] OS hangs while visiting a LO wiki page
On 09/15/2015 01:43 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: > Ady Ady wrote: >> Hello Users of LibreOffice, >> >> Once in a while I visit the Release Plan wiki page, >> https://wiki.documentfoundation.org/ReleasePlan >> >> From that wiki page, I recently tried to visit the "5.0.2" -> "RC1" >> page (more than once), but my OS hangs when I click on the relevant >> link. >> >> Of course, it could be just a coincidence. I am reluctant to try to >> reach these pages again, especially considering that every new wiki >> page in the series is based on the prior one. >> >> I am using Windows Vista Home Basic 32-bit, with Internet Explorer 9 >> and Mozilla Firefox 40.0.3, all updated. >> >> The strange behavior happened with both web browsers. >> >> I don't know whether some security tool being in use (e.g. Avast) >> might be relevant. >> >> I wanted to share this unusual experience, in case someone else >> happens to see it too (or something similar, or at least uncommon), >> and/or maybe it might be worth someone checking the source of these >> wiki pages (and their related nested templates). >> >> I am aware that this behavior (hanging OS) would be considered >> "unlikely to be triggered by some wiki page". The fact that it >> happened to me more than once while following the same links (but >> nowhere else) pushed me to at least comment on it. > > Interesting... I don't see a problem with that page at the moment. > However, since mid July I have been experiencing occasional OS hangs > which seem to be triggered by visiting certain web pages or sometimes > scrolling down the page slightly even after it's been loaded for a > while. Revisiting the same page doesn't necessarily trigger another > hang, but some pages seem to be more prone to it than others. > > I use Windows Vista Business 32-bit, Mozilla SeaMonkey 2.33.1 (based > on Firefox 36), Avast antivirus. > > One site (www.discount-electrical.co.uk) seemed to be particularly > troublesome. At one point I couldn't even add a few items to the > shopping cart and check out before the OS hung. Hangs seemed to be > less frequent using Chrome instead, but I did still get a few. I > didn't try IE. > > I haven't had so much trouble since mid August, but then again I > haven't been visiting the sites which seemed to be triggering the > problem so much lately either. Still get a couple of unexplained hangs > a week though. > > I can't be certain that visiting the web sites is/was the trigger, or > whether that's just coincidental. As you say, it does seem unlikely! > If anything, I'd suspect some interaction with a Windows update or > perhaps Flash or Avast, since I'd just got back from holiday and > installed a load of updates just before the problems started. Another > possibility for me is overheating or failing hardware (this is a 9 > year old laptop so getting on a bit!) but I haven't got around to > investigating further. > > Mark. > > So, when the problem happens for you, what do you do to recover? How do you get the system working again? Have you checked the Windows Event Viewer for log messages? There might be a log message around the time the system hangs. Peace.. "The Other" Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] OS hangs while visiting a LO wiki page
On 09/15/2015 05:48 AM, Ady Ady wrote: > Hello Users of LibreOffice, > > Once in a while I visit the Release Plan wiki page, > https://wiki.documentfoundation.org/ReleasePlan > > From that wiki page, I recently tried to visit the "5.0.2" -> "RC1" > page (more than once), but my OS hangs when I click on the relevant > link. > > Of course, it could be just a coincidence. I am reluctant to try to > reach these pages again, especially considering that every new wiki > page in the series is based on the prior one. > > I am using Windows Vista Home Basic 32-bit, with Internet Explorer 9 > and Mozilla Firefox 40.0.3, all updated. > > The strange behavior happened with both web browsers. > > I don't know whether some security tool being in use (e.g. Avast) > might be relevant. > > I wanted to share this unusual experience, in case someone else > happens to see it too (or something similar, or at least uncommon), > and/or maybe it might be worth someone checking the source of these > wiki pages (and their related nested templates). > > I am aware that this behavior (hanging OS) would be considered > "unlikely to be triggered by some wiki page". The fact that it > happened to me more than once while following the same links (but > nowhere else) pushed me to at least comment on it. > > TIA, > Ady. > Works for me in Firefox 40.0.3 on Ubuntu Linux 15.04 (64-bit). Peace... "The Other" Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Bugs
On 08/31/2015 05:47 AM, V Stuart Foote wrote: > jorge-2 wrote >> ... >> >>How we can help with this ? >> >>We, the users can make one example to each topic of the menu of >> LibreOffice can do. Then when coming new version before out we can probe >> each example during one week and make a report to programers. With this >> reports, just following the menu, they can fix the bugs that apear before >> freeing the new version. >> >>The other way is to make a macro to probe each topic of the menu to do >> it automatically. > It is already there. > > LibreOffice "Regression Testing," both automated and manual, is continual > and ongoing: > > https://wiki.documentfoundation.org/QA/Testing/Regression_Tests > > Individuals, please note that the LibreOffice project runs a MozTrap based > test suite for performing exactly this manual testing--with guided test > cases--but it is woefully underutilized by the broader user community. If > you are interested, check it out: > > https://wiki.documentfoundation.org/MozTrap/User_Guide > http://manual-test.libreoffice.org/results/runs/? > > The learning curve is a little steep for folks to get registered and get a > test case open, but is worth the effort as the results ARE reviewed and > integrated into the QA process. The Engineering Steering Committee reviews > results bi-weekly. Thanks for this information!!! I wasn't aware of this until now. This is something I would definitely be interested in participating in! Thanks! Peace... "The other" Tom > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Unable-to-Protect-Unprotect-cells-in-Libreoffice-5-tp4158473p4158876.html > Sent from the Users mailing list archive at Nabble.com. > -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/24/2015 08:25 AM, Stephen Harding wrote: I've had no problem using Writer to create 200+ page documents with over a hundred illustrations, annotated screen shots and drawings, imported from Microsoft's Visio or LO Draw (LO Draw works best) and JPEG photos. Also frequently use tables to show information. The documents have many, many cross references embedded in them and four level table of contents at the beginning. Impressive! :) Peace... The other Tom -Original Message- From: Dan Lewis [mailto:elderdanle...@gmail.com] Sent: 24 July 2015 16:06 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Question about LO Writer and complex documents On 07/24/2015 09:31 AM, Tom Williams wrote: Greetings! With all of the recent discussion about Linux being a viable alternative to Windows, in today's computing world, I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no. One common comment made by those who say no is Writer isn't good for complex documents. For basic word processing, it's fine. Question: in what ways does LO Writer fail at editing or creating complex documents? Does anyone here have any experience with LO Writer and complex documents? If so, what has your experience been (either good or bad)? I know I haven't actually defined complex documents but I haven't seen any definition of that in any of the comments I've read either. So, I'll leave the definition up to whatever you would consider a complex document. :) I've submitted on LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. I was helping a friend with a term paper and most of the paper was in portrait orientation, but a few pages were in landscape. LO Writer treated the entire document as either portrait or landscape but couldn't handle the mixture of both. I think that's been fixed, since I reported the bug. That's been about my only experience with a complex document. Thanks! Peace... The other Tom Is the problem with Complex documents really about the complexity, or is it about using LO and?Word on a complex document? I have been working with ODF Authors to create documentation for OpenOffice.org and then LibreOffice. I consider these document to be complex. Dan -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/24/2015 09:56 AM, toki wrote: On 07/24/2015 01:31 PM, Tom Williams wrote: Does anyone here have any experience with LO Writer and complex documents? I've had as many as 10,000 images in a single document. OOo 2.x didn't balk when I created it. Libo 5.0 beta does have any problems when I edit that document. LibO had no problems with an outline that was 50,000 pages long. (That project is on temporary hold, whilst I verify that GIT backup for LibO works as advertised. My current estimate is that the completed document will be 5,000,000 pages.) I've had as many as 10 different writing systems in one document. LibO does has some issues correctly displaying them, especially when they are intermixed in the same sentence, and a Pan-Unicode font is not being used. (FWIW, when using two or more writing systems that are BiDi, CTL, or CJVK, use a Pan-Unicode font, to minimize display issues.) Well, I think this certainly serves as a great example of a very complex document. :) I've submitted on LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. If one is not paying attention to what one is doing, when changing page styles, one can unintentionally change the wrong pages to the wrong page style. Understood and I can easily see this happening. I've never created a document like this, but I've imported a couple MS Word documents that had a mixture of landscape and portrait pages and Writer applied one page orientation to the entire document. This has since been fixed. Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/24/2015 08:05 AM, Dan Lewis wrote: On 07/24/2015 09:31 AM, Tom Williams wrote: Greetings! With all of the recent discussion about Linux being a viable alternative to Windows, in today's computing world, I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no. One common comment made by those who say no is Writer isn't good for complex documents. For basic word processing, it's fine. Question: in what ways does LO Writer fail at editing or creating complex documents? Does anyone here have any experience with LO Writer and complex documents? If so, what has your experience been (either good or bad)? I know I haven't actually defined complex documents but I haven't seen any definition of that in any of the comments I've read either. So, I'll leave the definition up to whatever you would consider a complex document. :) I've submitted on LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. I was helping a friend with a term paper and most of the paper was in portrait orientation, but a few pages were in landscape. LO Writer treated the entire document as either portrait or landscape but couldn't handle the mixture of both. I think that's been fixed, since I reported the bug. That's been about my only experience with a complex document. Thanks! Peace... The other Tom Is the problem with Complex documents really about the complexity, or is it about using LO and?Word on a complex document? I have been working with ODF Authors to create documentation for OpenOffice.org and then LibreOffice. I consider these document to be complex. Dan Unfortunately, most of the comments I had read were more of a general nature, so details like the ones you raise were left out. I think it could be a combination or mixture of both. Maybe in some cases, actual complexity of documents was being considered and in other cases, the perception that Writer couldn't handle anything other than basic word processing tasks. Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/24/2015 10:45 AM, Brian Barker wrote: At 06:31 24/07/2015 -0700, Tom Williams wrote: ... I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no. One common comment made by those who say no is Writer isn't good for complex documents. For basic word processing, it's fine. Question: in what ways does LO Writer fail at editing or creating complex documents? I've submitted an LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. I was helping a friend with a term paper and most of the paper was in portrait orientation, but a few pages were in landscape. LO Writer treated the entire document as either portrait or landscape but couldn't handle the mixture of both. It's worth saying that you are mixing your ideas here. This experience is not about LibreOffice's facility at creating or editing (text) documents with mixed page orientations, but about how it can handle whatever Microsoft Word puts in its proprietary file formats to encode similar structures. That may well matter to you, but it has little to do with how good LibreOffice may be at achieving this particular structure. Yes, the example I cited doesn't reflect on Writer's ability to create or edit documents with mixed page orientations but the behavior I experienced could be easily viewed as Writer not being able to handle some kinds of MS Word documents. This isn't my personal view but a view I've experienced from those I've helped in using Writer. You surely cannot believe that it is at all difficult to create and edit text documents with mixed page orientations in LibreOffice? I haven't personally created a document like this but I wouldn't have thought it would be difficult to do. I would have simply looked up how to do it and do it. :) Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/24/2015 08:40 AM, Pablo Dotro wrote: The main complaint I've observed regarding different capabilities in MS Office and LO comes from people that expect both products to work exactly the same. Commonality exist between them, but each one is it's own product, with different design, coding and debugging standards. Yes, I've encountered this as well and I consider each its own product, as you. :) What frustrates me some is people not giving LO a legitimate chance to function as its own suite vs being viewed in the shadow of MS Office. Peace... The other Tom On Fri, Jul 24, 2015 at 12:05 PM, Dan Lewis elderdanle...@gmail.com wrote: On 07/24/2015 09:31 AM, Tom Williams wrote: Greetings! With all of the recent discussion about Linux being a viable alternative to Windows, in today's computing world, I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no. One common comment made by those who say no is Writer isn't good for complex documents. For basic word processing, it's fine. Question: in what ways does LO Writer fail at editing or creating complex documents? Does anyone here have any experience with LO Writer and complex documents? If so, what has your experience been (either good or bad)? I know I haven't actually defined complex documents but I haven't seen any definition of that in any of the comments I've read either. So, I'll leave the definition up to whatever you would consider a complex document. :) I've submitted on LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. I was helping a friend with a term paper and most of the paper was in portrait orientation, but a few pages were in landscape. LO Writer treated the entire document as either portrait or landscape but couldn't handle the mixture of both. I think that's been fixed, since I reported the bug. That's been about my only experience with a complex document. Thanks! Peace... The other Tom Is the problem with Complex documents really about the complexity, or is it about using LO and?Word on a complex document? I have been working with ODF Authors to create documentation for OpenOffice.org and then LibreOffice. I consider these document to be complex. Dan -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LO Writer and complex documents
On 07/26/2015 09:58 AM, toki wrote: On 07/26/2015 04:48 PM, Tom Williams wrote: Well, I think this certainly serves as a great example of a very complex document. :) Which document? * 10,000 images in one document; * 50,000 pages in the outline, with projected length of 5,000,000 pages; * 10 different writing systems in the same document; Certainly, the 10 different writing systems in the same document is something *I* would consider complex, especially since that's not something I've ever seen, done, or even heard of. :) The 50,000 page outline document sounds complex as well, since I imagine that outline would have several levels and not be relatively flat. When I wrote my comment, I thought to these two documents were one in the same. :) Peace.. The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about LO Writer and complex documents
Greetings! With all of the recent discussion about Linux being a viable alternative to Windows, in today's computing world, I've read many comments about whether or not LibreOffice is a good alternative to MS Office. Some say yes, others say no. One common comment made by those who say no is Writer isn't good for complex documents. For basic word processing, it's fine. Question: in what ways does LO Writer fail at editing or creating complex documents? Does anyone here have any experience with LO Writer and complex documents? If so, what has your experience been (either good or bad)? I know I haven't actually defined complex documents but I haven't seen any definition of that in any of the comments I've read either. So, I'll leave the definition up to whatever you would consider a complex document. :) I've submitted on LO Writer bug where Writer didn't handle Word documents with pages with different page orientations well. I was helping a friend with a term paper and most of the paper was in portrait orientation, but a few pages were in landscape. LO Writer treated the entire document as either portrait or landscape but couldn't handle the mixture of both. I think that's been fixed, since I reported the bug. That's been about my only experience with a complex document. Thanks! Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux alternative helpsupport
On 07/19/2015 07:52 AM, Tom Davies wrote: Hi :) If Win8 started up at the normal desktop (as it can be set to do now) and then the Metro stuff is used just as the old; Start button - All Programs Then it's kinda ok - err after adding in new tiles for Kodi, LibreOffice, Chrome/Firefox etc, removing quite a lot of the default useless ones and moving around all the tiles into something that makes some kind of sense and makes useful programs/documents/things easier to get to. Then using the Windows key brings up that programs menu. Regards from Tom :) You know, you raise another point about Windows 8.1 that irks me. Many, if not most, think one of the main problems with Windows 8 is/was the missing Start menu. I truly don't miss the Start menu and don't like any window managers or desktop environments that try to retain that look/behavior. I think GNOME shell got it right by having the Applications menu, where one would find the applications they wanted to run. But I digress... anyway, I don't miss the Start menu at all. I don't like how Metro has its tiles laid out. Look at ANY new desktop or laptop system with Windows 8 pre-installed. After the initial setup process, you see the Metro desktop and its tiles. Where is the MS Office tile? Off to the far right somewhere, requiring you to scroll to see it. I'm on a *desktop* system and using a Word processor is something I'm probably going to want to do so why not put the tile for MS Office in the same set of tiles where you can EASILY access the online stuff? Stupid strike #1. When I'm on the desktop side, I can double-click a photo to see it. If I'm not careful, I can get flipped to the Metro side and view the photo. Cool. When I'm done looking at the photo, I have no clue what to do because the X to close the window isn't in view (I have to know to move the mouse to the top of the screen to get it to appear). Stupid strike #2 (the flip from the desktop to Metro). Now, these aren't things I've personally struggled with but things I've personally witnessed many others struggle with as they get new computers I setup for them. To be fair, I have no issue with Windows 8's underpinnings and security changes. It's mostly the UI behavior I have issue with. Of course, if one wants to take the time to learn how to use Windows 8 effectively and efficiently, more power to them. I would also state, if they could take the time to learn how to use Windows 8, they could (and should) take the time to learn how to use LibreOffice effectively and efficiently instead of slamming it for not looking or behaving exactly like MS Office. :) Peace... The other Tom On 18 July 2015 at 22:59, Tom Williams tomd...@comcast.net mailto:tomd...@comcast.net wrote: On 07/18/2015 11:28 AM, Tom Davies wrote: Hi :) Something i really appreciate most about Linux is that it's so easy to change the gui - or more importantly that if you don't like the crazy new things that have been done to the gui then you can fairly easily go back to the old one or on to something else entirely. The under-laying system remains the same. Back in the day, I used to have 3 or 4 window managers I used to switch between. lol As for Windows 8's metro, I mean modern UI, I'm not digging it and I never have. The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [OT] [libreoffice-users] Linux alternative
On 07/18/2015 07:51 PM, toki wrote: On 07/18/2015 10:08 PM, James Knott wrote: Tell that to all the scientists who use supercomputers. The vast majority of them, including my cousin, run Linux. If you want state of the art software, that costs a fortune, you run *Nix. If you want almost state of the art, that costs a small fortune, it is as likely to run on Mac OS X, as on Windows. If you want software that is almost state of the art, but is affordable, you run Windows. If you want software that is good enough for most purposes, you run Linux. Joe Sixpack wants something slightly better than good enough for most purposes, but doesn't want the cash outlay that state of the art requires. Thus far, Windows has been that happy medium. jonathon I disagree with most of this, but the good enough for most purposes part really bothers me. :) Joe Sixpack is most familiar with Windows and will stick with it. Familiarity is definitely worth its weight in gold. :) Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [OT] Re: [libreoffice-users] Linux alternative
On 07/18/2015 10:44 AM, Felmon Davis wrote: On Sat, 18 Jul 2015, Thomas wrote: Although I know, this does not belong here, just a word. I have been trying (STRUGGLING) to move away from MS and get friendly with Linux for 7-8 years now! So far with little success. Yet, I still keep trying. this makes me wonder what the top two or three things are that people find hard in adopting Linux. I've found a number of people simply expect _any_ computer to look, act, and feel like Windows. I installed LibreOffice on the computer of a client of mine because MS Office Starter Edition kept acting funny when he would try to open MS Office documents attached to email messages. One day, we were talking about his using Excel vs Calc to update a spreadsheet. He insisted he couldn't use Calc because it didn't do what Excel did. I asked him to show me the things he could do in Excel but couldn't do in Calc and we both discovered he actually _could_ do all of the things he needed to do in Calc but the way he needed to do those things were a little different. In another case, I showed an IT guy I used to work with an Ubuntu system. He wanted to run an application and went straight to the lower left corner of the screen, looking for the Start menu. The more people learn Windows, especially as their first computing interface, the more they tend to think all computers behave that way. Of course, this isn't an absolute statement. :) Something else I've found is non-Linux users tend to expect a higher standard of performance from Linux for it to even be considered a viable option. For example, if Linux can't support {fill in the blank} perfectly, Linux isn't ready for prime time. Let's forget the fact that Windows might have issues supporting {fill in the blank} as well. lol This thread could not have come at a better time since I recently read the TechRepublic article and another article about Linux being an alternative to Windows. In the other article, I was floored by various comments made by others who had read that article. Comments about how Linux is good for basic things and not good for productivity. So, if you want to just read email and surf mainstream websites, Linux is great. If you want to do real work, you need Windows for that. I had to laugh since I find myself doing real and productive work on Linux on a daily basis, and without using the command line unless I want to use ImageMagick to process some images in batch. I've switched my mom to Linux and while she's not doing anything sophisticated, I've noticed her computer question volume has decreased significantly. Her computer usage hasn't changed much from when she used Windows XP except I think she's actually listening to more music on her computer now, while reading email and surfing the web. Sorry for being so long winded. :) Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux alternative helpsupport
On 07/18/2015 11:28 AM, Tom Davies wrote: Hi :) Something i really appreciate most about Linux is that it's so easy to change the gui - or more importantly that if you don't like the crazy new things that have been done to the gui then you can fairly easily go back to the old one or on to something else entirely. The under-laying system remains the same. Back in the day, I used to have 3 or 4 window managers I used to switch between. lol As for Windows 8's metro, I mean modern UI, I'm not digging it and I never have. The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [OT] Operating Environment Survey
On 07/18/2015 06:25 PM, James E Lang wrote: The big discussion of Linux over the past 24+ hours has me wondering: What operating environment(s) do other members of this list use at home and at work? What factors influence the choice? To set the tone, here are my answers: • I am retired so at work is not applicable • At home we have a desktop dual boot Windows XP (and Ubuntu Linux) computer, a laptop dual boot Kubuntu Linux (and pre-installed Windows Vista) computer and several other laptop, desktop, and dedicated server (Ubuntu Linux based) computers. I also have Android Lollipop, Android Kit Kat, and Android Jelly Bean tablets and phones. I have nothing from Apple. • Windows XP is used primarily for single player gaming and e-Sword Bible software though it also is used to run LO, FireFox and Pegasus Mail (proprietary though free of cost). • Kubuntu Linux is my general purpose go to environment. My first Linux system used what I believe was the penultimate marketed version from SuSE before the first release of Open SuSE. I liked the flexibility that was inherent in the KDE desktop environment and found the UI to be quite similar to that of Windows at the time. I have briefly tried Gnome and Unity desktop environments but KDE is my personal first choice. • If I had a tablet computer that I thought could support my Linux usage it, too, would run Kubuntu Linux, LO, etc. • Apple equipment is too expensive for me and from what I've heard about the company's software policies, they are too restrictive to suit me. • Dual boot capabilities are seldom used to deviate from the above information. • The BSODs on Windows influenced my initial adoption of Linux. At work, I use Windows 7. At home, I use Ubuntu Linux (64-bit) and have been a Linux devotee for years. I first switched from Windows XP to Slackware back in the late 1990s. I installed Slackware 8 from CD and installed only the base system and compiler. Most everything else, I built from sources I would download, including X11 (XFree86). :) I switched to Ubuntu around 7.04 to see what the Linux experience was like without compiling everything all the time. Now, I just don't have the time to build everything from source to keep the system updated. Peace... The other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Word documents that LO messes up
On 06/23/2015 07:06 AM, Malcolm Moore wrote: Is there anyone who is interested in documents that LO munges up. There are lots of nice words on the web site about how there are loads of test that are run to ensure compatibility but we still get a lot of documents that are unusable I was wondering if there is a place to send them so the developers can see them Ta Mal When I encounter this, I file bug reports and attach the Word documents as test case files. Doing this has resulted in a number of my reported issues getting fixed. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Question about font replacement/substitution in Writer 4.3.3
On 02/16/2015 04:56 AM, Italo Vignoli wrote: On 16/02/2015 13:22, Maurice wrote: On Sun, 15 Feb 2015 12:09:59 -0800, Tom Williams wrote: I don't have Calibri installed, If you have Windows on the same PC you can get Linux to clone it to Linux. If not, try Googling on: calibri download linux Please do mind that Calibri is a Microsoft proprietary font strictly connected to a Windows/MS Office license, which cannot be used if you do not have such a license. This is clearly stated in the Windows/MS Office EULA. LibreOffice offers a Calibri replacement, Carlito, which has a free font license and can therefore be downloaded and installed on every operating system without infringing the license. Thanks for everyone for the replies. :) I did install the Carlito font. :)However, I'm still looking for a way to see which substitute font Writer chose, if that's possible.MS Word appears to support this, as indicated in this article: http://wordribbon.tips.net/T012657_Finding_Words_Font_Substitutes.html Is there a way to determine which font Writer uses as the substitute font? Thanks! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about font replacement/substitution in Writer 4.3.3
Hi! I'm running LibreOffice Writer 4.3.3.2 on Ubuntu 14.10 Linux (64-bit). I'm helping someone convert a MS Word document info a PDF form. I'm creating the form as a native ODT document, which I will save as a PDF form. The original MS Word document uses the Calibri font everywhere. I don't have Calibri installed, yet the text is displayed anyway. My question: how I can find out which font is being used as a substitute for Calibri? I know about the Font Replacement Table, where I can specify which fonts to use as replacements or substitutes. However, I'm looking for a way to find out which font Writer chose as the replacement font. Is there a way to find this out? Thanks in advance for your time and assistance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about upcoming 4.3.3 release
Hi! I was looking at the fixed bugs section of the release notes for LO 4.3.3 RC1 (https://wiki.documentfoundation.org/Releases/4.3.3/RC1#List_of_fixed_bugs) and noticed bug #66701 (https://bugs.freedesktop.org/show_bug.cgi?id=66701) was listed as being fixed in LO 4.3.3. However, when I look at bug #66701, it's still in New status and is targeted for release 4.4.0. Who can I notify to see about getting the release notes corrected? Thanks! Peace... The Other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about upcoming 4.3.3 release
On 10/25/2014 09:50 AM, Sophie wrote: Hi Tom, all, Le 25/10/2014 18:28, Charles-H. Schulz a écrit : Hello Tom, Le Sat, 25 Oct 2014 08:59:35 -0700, Tom Williams tomd...@comcast.net a écrit : Hi! I was looking at the fixed bugs section of the release notes for LO 4.3.3 RC1 (https://wiki.documentfoundation.org/Releases/4.3.3/RC1#List_of_fixed_bugs) and noticed bug #66701 (https://bugs.freedesktop.org/show_bug.cgi?id=66701) was listed as being fixed in LO 4.3.3. However, when I look at bug #66701, it's still in New status and is targeted for release 4.4.0. Who can I notify to see about getting the release notes corrected? Thanks! Peace... The Other Tom Thanks for picking that up. Release notes are very much a volunteers' business, and I usually only post a summary directly to the website when the release is done. But first we need to know whether you picked an actual mistake or if the bug report itself has not been updated. I'll ping one of our release managers, Sophie, who just happens to be on that list :-) Sophie, do you have more info on this bug status? Yes, you'll find the answer here https://gerrit.libreoffice.org/#/c/11455/ if you look at the branch, you'll see that it's 4.3. The bug is still on new because nobody closed it, most of the time, the target is the next major, but if it can be added to a current branch with no risk, it's done. Kind regards Sophie Great! Thanks to you both for looking into this matter. :) Peace... The Other Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about Calc and hiding rows
On 08/11/2014 08:33 PM, Brian Barker wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When he tried to make a change, he showed the row but wasn't able to change a cell because something prevented him from making changes. When he showed the hidden row, he saw an icon for an anchor and green squares along the perimeter of the selection of the now shown rows. He sent the spreadsheet to me and when I open it in LibreOffice Calc, 4.2.4.2 on Linux, I see the same behavior he describes. From what I can tell, it looks like Calc converts the hidden row into an image or graphic of some kind such that when he tries to change it, he can't because those rows are now part of an image/graphic or object that's embedded in the file. I doubt very much that Calc has converted values to a picture of those values. But yes: you very probably do have a graphic or other object in or covering the relevant cells. If you need to modify a cell which appears inaccessible because of an overlaid graphic, there are a number of ways to do this. o You can type the cell reference into the Name Box and then edit the contents in the Input Line. o You can (temporarily?) suppress display of the graphic at Tools | Options... | LibreOffice Calc | View | Objects | Objects/Graphics. o Most easily, you can send the graphic to the background using right-click | Arrange | To Background. If you do this, you may want to bring it back to the front after you have completed the edit, but you will not be able to select it by simply clicking on it precisely because it is now in the background. One convenient way to select the graphic is to open the Navigator (go to View | Navigator or press F5) and double-click the name of the graphic. You can then use right-click | Arrange | To Foreground to reset the position. Of course, if you cannot see the graphic and are not missing anything, it may be that you don't want it and can merely delete it. Well, I have an update on this issue. You were 100% correct about an image covering the cells. Apparently, my dad used a copy/paste function to update the spreadsheet and pasted data as a bitmap. So, I was able to guide him through simply deleting the image and his data is editable as expected. THANK YOU! :) Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about Calc and hiding rows
On 08/11/2014 08:33 PM, Brian Barker wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When he tried to make a change, he showed the row but wasn't able to change a cell because something prevented him from making changes. When he showed the hidden row, he saw an icon for an anchor and green squares along the perimeter of the selection of the now shown rows. He sent the spreadsheet to me and when I open it in LibreOffice Calc, 4.2.4.2 on Linux, I see the same behavior he describes. From what I can tell, it looks like Calc converts the hidden row into an image or graphic of some kind such that when he tries to change it, he can't because those rows are now part of an image/graphic or object that's embedded in the file. I doubt very much that Calc has converted values to a picture of those values. But yes: you very probably do have a graphic or other object in or covering the relevant cells. If you need to modify a cell which appears inaccessible because of an overlaid graphic, there are a number of ways to do this. o You can type the cell reference into the Name Box and then edit the contents in the Input Line. o You can (temporarily?) suppress display of the graphic at Tools | Options... | LibreOffice Calc | View | Objects | Objects/Graphics. o Most easily, you can send the graphic to the background using right-click | Arrange | To Background. If you do this, you may want to bring it back to the front after you have completed the edit, but you will not be able to select it by simply clicking on it precisely because it is now in the background. One convenient way to select the graphic is to open the Navigator (go to View | Navigator or press F5) and double-click the name of the graphic. You can then use right-click | Arrange | To Foreground to reset the position. Of course, if you cannot see the graphic and are not missing anything, it may be that you don't want it and can merely delete it. I trust this helps. Brian Barker Thanks for the information and sorry for the delayed response. I'll give this a try and will report back my findings! :) Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about Calc and hiding rows
On 08/12/2014 01:16 AM, Tom Davies wrote: Hi :) +1 Also ... Errr, how are the cells being hidden?!?? Of course it is possible to hide an entire row or column by clicking on the row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide the entire row/column. This is what my dad does to hide the rows in question. :) Peace... The Other Tom :) On 12 August 2014 04:33, Brian Barker b.m.bar...@btinternet.com wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When he tried to make a change, he showed the row but wasn't able to change a cell because something prevented him from making changes. When he showed the hidden row, he saw an icon for an anchor and green squares along the perimeter of the selection of the now shown rows. He sent the spreadsheet to me and when I open it in LibreOffice Calc, 4.2.4.2 on Linux, I see the same behavior he describes. From what I can tell, it looks like Calc converts the hidden row into an image or graphic of some kind such that when he tries to change it, he can't because those rows are now part of an image/graphic or object that's embedded in the file. I doubt very much that Calc has converted values to a picture of those values. But yes: you very probably do have a graphic or other object in or covering the relevant cells. If you need to modify a cell which appears inaccessible because of an overlaid graphic, there are a number of ways to do this. o You can type the cell reference into the Name Box and then edit the contents in the Input Line. o You can (temporarily?) suppress display of the graphic at Tools | Options... | LibreOffice Calc | View | Objects | Objects/Graphics. o Most easily, you can send the graphic to the background using right-click | Arrange | To Background. If you do this, you may want to bring it back to the front after you have completed the edit, but you will not be able to select it by simply clicking on it precisely because it is now in the background. One convenient way to select the graphic is to open the Navigator (go to View | Navigator or press F5) and double-click the name of the graphic. You can then use right-click | Arrange | To Foreground to reset the position. Of course, if you cannot see the graphic and are not missing anything, it may be that you don't want it and can merely delete it. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about Calc and hiding rows
On 08/12/2014 01:22 AM, Tom Davies wrote: Hi :) Also the 4.1.0 was VERY early in that branch's cycle. There have been numerous updates to fix lots of bugs and make it more stable. So instead of the 4.1.0 it would be better to try the 4.1.6. Similarly with the 4.0.1. That 3rd digit shows it had only 1 update (to fix bugs) since the beginning of it's branch. Better to try the 4.0.6 ! I had him reinstall OpenOffice 4.0.1 because that was the previous version he used before I upgraded it to 4.1.0. Thanks! Peace.. The Other Tom On 12 August 2014 09:16, Tom Davies tomc...@gmail.com wrote: Hi :) +1 Also ... Errr, how are the cells being hidden?!?? Of course it is possible to hide an entire row or column by clicking on the row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide the entire row/column. To hide individual cells it might be easier to grab a graphic, drag it onto the spreadsheet, perhaps right-click again to Anchor to - page and resize to fit the cell(s). It's also probably possible to put a frame over the cells and then have writing or number in the frame although it might be difficult to then reach those numbers in calculations in the rest of the spreadsheet because they wont be recognised as being in a cell. Regards from Tom :) On 12 August 2014 04:33, Brian Barker b.m.bar...@btinternet.com wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When he tried to make a change, he showed the row but wasn't able to change a cell because something prevented him from making changes. When he showed the hidden row, he saw an icon for an anchor and green squares along the perimeter of the selection of the now shown rows. He sent the spreadsheet to me and when I open it in LibreOffice Calc, 4.2.4.2 on Linux, I see the same behavior he describes. From what I can tell, it looks like Calc converts the hidden row into an image or graphic of some kind such that when he tries to change it, he can't because those rows are now part of an image/graphic or object that's embedded in the file. I doubt very much that Calc has converted values to a picture of those values. But yes: you very probably do have a graphic or other object in or covering the relevant cells. If you need to modify a cell which appears inaccessible because of an overlaid graphic, there are a number of ways to do this. o You can type the cell reference into the Name Box and then edit the contents in the Input Line. o You can (temporarily?) suppress display of the graphic at Tools | Options... | LibreOffice Calc | View | Objects | Objects/Graphics. o Most easily, you can send the graphic to the background using right-click | Arrange | To Background. If you do this, you may want to bring it back to the front after you have completed the edit, but you will not be able to select it by simply clicking on it precisely because it is now in the background. One convenient way to select the graphic is to open the Navigator (go to View | Navigator or press F5) and double-click the name of the graphic. You can then use right-click | Arrange | To Foreground to reset the position. Of course, if you cannot see the graphic and are not missing anything, it may be that you don't want it and can merely delete it. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Question about Calc and hiding rows
On 08/12/2014 08:44 AM, Pedro wrote: If the document has been going back and forth between LibreOffice and Apache OpenOffice (or old OpenOffice.org) it is quite possible that it was corrupted at some stage (I have a document where this happened...) If your father has been using OpenOffice only, can he pinpoint a version where it worked/works correctly? Does he have older copies of the document (it might have become corrupted at same point in the past...) Thanks for the info. Before I got involved, my dad used OpenOffice exclusively.I had him install version 4.0.1 because that was the version he had been previously running, before I upgraded to 4.1.0. :) Thanks! Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about Calc and hiding rows
My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When he tried to make a change, he showed the row but wasn't able to change a cell because something prevented him from making changes. When he showed the hidden row, he saw an icon for an anchor and green squares along the perimeter of the selection of the now shown rows. He sent the spreadsheet to me and when I open it in LibreOffice Calc, 4.2.4.2 on Linux, I see the same behavior he describes. From what I can tell, it looks like Calc converts the hidden row into an image or graphic of some kind such that when he tries to change it, he can't because those rows are now part of an image/graphic or object that's embedded in the file. Any ideas on what could be going on? He first encountered this with OpenOffice 4.1.0 and continues to see it with OpenOffice 4.0.1. Thanks! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about viewing cell formulas in Writer
Hi! I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 Linux (64-bit) and I created an OpenDocument with a table that has a few cells with formulas. The formulas are simple in nature (basic math) but I would like to see the formula of any given cell at any given time. I've found if I hover the mouse over a cell in the last row of the table, the formula appears as a tool-tip. However, if I hover over another cell in a row in the middle of the table, the formula doesn't appear. Is there a way I can see the formula in any given cell in a table in Writer? Thanks in advance! Peace... The Other Tom :) -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about viewing cell formulas in Writer
On 07/12/2014 01:15 PM, Brian Barker wrote: At 21:20 12/07/2014 +0200, Rob Jasper wrote: Op 12 jul. 2014, om 20:59 heeft Tom Williams het volgende geschreven: I'm using LibreOffice 4.2.4.2 on Ubuntu 14.04 Linux (64-bit) and I created an OpenDocument with a table that has a few cells with formulas. The formulas are simple in nature (basic math) but I would like to see the formula of any given cell at any given time. I've found if I hover the mouse over a cell in the last row of the table, the formula appears as a tool-tip. However, if I hover over another cell in a row in the middle of the table, the formula doesn't appear. Is there a way I can see the formula in any given cell in a table in Writer? If you select a cell you should see the formula in the top in the line containing the selected cell, just after fx â^' = If you want to see ten all, go to preferences LibreOffice Calc View and tick Formulas Er, except that the questioner is asking about formulae in table cells in a text (Writer) document - not in a spreadsheet. You can put the cursor into a table cell in a text document, but you then need to use Table | Formula or to press F2 to open the Input Line to display the formula. Perfect! Thank You!! :) Peace... The Other Tom And there appears to be no equivalent of that Options / Preferences setting for table formulae rather than spreadsheets. I trust this helps. Brian Barker -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about fonts and forms in Writer
On 05/11/2014 11:40 AM, Tom Davies wrote: Hi :) Can you right-click on the boxes or select them all and set their properties? Err, when you say converting a Word document into a form - for most things it is often better to start off with a fresh document in ODF format when you find yourself struggling with odd weirdnesses. Documents that were previously in some other format, particularly MS formats (especially the various versions of DocX or Rtf), often have tons of hidden coding stuffing things up. A fresh start often helps. ODF is the better format for stability between different versions of software. Ok, I FINALLY had some time to look into this. I created a form from scratch and it behaved much better than the Word document I converted into a form. I'm not sure why, since the Word document didn't have any form fields so the form fields I added were in LibreOffice Writer but starting with a fresh document resulted in a much better behaving PDF form. :) Thanks again! Peace... The other Tom :) How about Chapter 15 in this guide? https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide I haven't read it so i don't know if it covers setting properties for the boxes Regards from Tom :) On 11 May 2014 17:59, Tom Williams tomd...@comcast.net mailto:tomd...@comcast.net wrote: Hi! I'm converting a Word document into a form that will eventually be a PDF form that can be filled in using Adobe Reader. I'm doing this in LibreOffice Writer 4.2.3.3 on Ubuntu Linux 14.04. My first pass worked splendidly well and everything worked fine except for two issues: 1. I can't seem to control the font used in the form controls, namely the text boxes 2. I can't get the text boxes to align text at the top (despite my setting the form control to align text at the top) Does anyone reading this list have much experience with creating forms in Writer? With regard to issue #2, when I enter text into a text box, it's vertically centered vs being aligned along the top of the text box. This is when I view the generated PDF file in Ubuntu's PDF document viewer, the text I typed wasn't aligned at the top of the text box. I'm not sure if this is an Ubuntu document view issue or an issue with the generated PDF file. I'll test in Adobe Reader later. With regard to issue #1, is there any way to control the font used for the text boxes in a form? Thanks in advance for your time and assistance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Question about fonts and forms in Writer
On 05/16/2014 09:12 AM, Brad Rogers wrote: On Fri, 16 May 2014 16:14:21 +0100 Tom Davies tomc...@gmail.com wrote: Hello Tom, Isn't this a good one to ask Spotify? I dunno if simply trying to sing it Or simply cut/paste it into a search engine. First and, to my mind, most likely match is Dean Martin - Sway With Me. Yep, it's from Sway. :) I tend to listen to Michael Buble's version. I also attended a live performance of Sway by the Montclair Women's Big Band, many moon ago. :) Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about fonts and forms in Writer
On 05/13/2014 08:21 AM, Tom Davies wrote: Hi :) Has this issue been solved? Sorry i didn't know enough to help with this! Was the documentation useful? Regards from Tom :) I haven't had time to work on the form any, lately. When I do, I'll be sure to let you know how things go. :) Peace... Tom On 12 May 2014 01:53, Tom Williams tomd...@comcast.net wrote: On 05/11/2014 11:40 AM, Tom Davies wrote: Hi :) Can you right-click on the boxes or select them all and set their properties? Yes, I can and that's how I set two of the text boxes to align the entered text at the top, instead of the middle. I'll try my PDF form in Adobe Reader now and will see how it behaves. Err, when you say converting a Word document into a form - for most things it is often better to start off with a fresh document in ODF format when you find yourself struggling with odd weirdnesses. Documents that were previously in some other format, particularly MS formats (especially the various versions of DocX or Rtf), often have tons of hidden coding stuffing things up. A fresh start often helps. ODF is the better format for stability between different versions of software. Thanks for mentioning this. I'll keep this in mind. :) How about Chapter 15 in this guide? https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide I haven't read it so i don't know if it covers setting properties for the boxes Great! Thanks! I'll check it out! Peace... The other Tom :) Regards from Tom :) On 11 May 2014 17:59, Tom Williams tomd...@comcast.net wrote: Hi! I'm converting a Word document into a form that will eventually be a PDF form that can be filled in using Adobe Reader. I'm doing this in LibreOffice Writer 4.2.3.3 on Ubuntu Linux 14.04. My first pass worked splendidly well and everything worked fine except for two issues: 1. I can't seem to control the font used in the form controls, namely the text boxes 2. I can't get the text boxes to align text at the top (despite my setting the form control to align text at the top) Does anyone reading this list have much experience with creating forms in Writer? With regard to issue #2, when I enter text into a text box, it's vertically centered vs being aligned along the top of the text box. This is when I view the generated PDF file in Ubuntu's PDF document viewer, the text I typed wasn't aligned at the top of the text box. I'm not sure if this is an Ubuntu document view issue or an issue with the generated PDF file. I'll test in Adobe Reader later. With regard to issue #1, is there any way to control the font used for the text boxes in a form? Thanks in advance for your time and assistance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- *When we dance, you have a way with me, Stay with me... Sway with me...* -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Which components do you use most?
On 05/11/2014 02:53 PM, Virgil Arrington wrote: I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. For myself, my approximate usage is: Writer (85% of my use of LO) Calc(10%) Impress (3%, Maybe four to five presentations a year) Base (once a year to print out labels for my Christmas cards) Draw (What's that?) Virgil I use Calc more than Writer but I rarely use Impress and have never used Draw or Base. So, it's between Calc and Writer for me. :) I use Calc daily (to update blood pressure monitoring spreadsheet, mostly) and Writer occasionally. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about fonts and forms in Writer
Hi! I'm converting a Word document into a form that will eventually be a PDF form that can be filled in using Adobe Reader. I'm doing this in LibreOffice Writer 4.2.3.3 on Ubuntu Linux 14.04. My first pass worked splendidly well and everything worked fine except for two issues: 1. I can't seem to control the font used in the form controls, namely the text boxes 2. I can't get the text boxes to align text at the top (despite my setting the form control to align text at the top) Does anyone reading this list have much experience with creating forms in Writer? With regard to issue #2, when I enter text into a text box, it's vertically centered vs being aligned along the top of the text box. This is when I view the generated PDF file in Ubuntu's PDF document viewer, the text I typed wasn't aligned at the top of the text box. I'm not sure if this is an Ubuntu document view issue or an issue with the generated PDF file. I'll test in Adobe Reader later. With regard to issue #1, is there any way to control the font used for the text boxes in a form? Thanks in advance for your time and assistance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about fonts and forms in Writer
On 05/11/2014 11:40 AM, Tom Davies wrote: Hi :) Can you right-click on the boxes or select them all and set their properties? Yes, I can and that's how I set two of the text boxes to align the entered text at the top, instead of the middle. I'll try my PDF form in Adobe Reader now and will see how it behaves. Err, when you say converting a Word document into a form - for most things it is often better to start off with a fresh document in ODF format when you find yourself struggling with odd weirdnesses. Documents that were previously in some other format, particularly MS formats (especially the various versions of DocX or Rtf), often have tons of hidden coding stuffing things up. A fresh start often helps. ODF is the better format for stability between different versions of software. Thanks for mentioning this. I'll keep this in mind. :) How about Chapter 15 in this guide? https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide I haven't read it so i don't know if it covers setting properties for the boxes Great! Thanks! I'll check it out! Peace... The other Tom :) Regards from Tom :) On 11 May 2014 17:59, Tom Williams tomd...@comcast.net mailto:tomd...@comcast.net wrote: Hi! I'm converting a Word document into a form that will eventually be a PDF form that can be filled in using Adobe Reader. I'm doing this in LibreOffice Writer 4.2.3.3 on Ubuntu Linux 14.04. My first pass worked splendidly well and everything worked fine except for two issues: 1. I can't seem to control the font used in the form controls, namely the text boxes 2. I can't get the text boxes to align text at the top (despite my setting the form control to align text at the top) Does anyone reading this list have much experience with creating forms in Writer? With regard to issue #2, when I enter text into a text box, it's vertically centered vs being aligned along the top of the text box. This is when I view the generated PDF file in Ubuntu's PDF document viewer, the text I typed wasn't aligned at the top of the text box. I'm not sure if this is an Ubuntu document view issue or an issue with the generated PDF file. I'll test in Adobe Reader later. With regard to issue #1, is there any way to control the font used for the text boxes in a form? Thanks in advance for your time and assistance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto:users%2bunsubscr...@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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On 04/24/2014 06:09 AM, Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) Thanks for mentioning this. :)I think bug hunts are great, but I need to ask this question: how does the current backlog of bugs factor in with these bug hunts? I understand the bug hunts are great for finding new bugs, but I've filed several bug reports, some of which have been stagnant for over six months. Here is an example: https://bugs.freedesktop.org/show_bug.cgi?id=57116 I'm excited about LibreOffice 4.3's release because the software keeps getting better and better. However, it's also a bit frustrating when reported issues exist for a long period of time. Thanks! Peace... Tom On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized - with the same pattern - immediately after the release of LibreOffice 4.3 Release Candidate 1, in mid June. Short link to TDF blog: http://wp.me/p1byPE-uy. -- Italo Vignoli - The Document Foundation mob IT +39.348.5653829 - mob EU +39.392.7481795 sip it...@libreoffice.org - skype italovignoli hangout / jabber italo.vign...@gmail.com email it...@documentfoundation.org GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0 -- To unsubscribe e-mail to: announce+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ List archive: http://listarchives.documentfoundation.org/www/announce/ -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [tdf-announce] Get ready for LibreOffice 4.3 bug hunting session
On 04/25/2014 08:40 AM, Charles-H. Schulz wrote: Hello Tom, Le 2014-04-25 15:35, Tom Williams a écrit : On 04/24/2014 06:09 AM, Tom Davies wrote: Hi :) These bug-hunting sessions can be a great fun. It's only for a short time-period so you can find yourself racing against other people who are also new to it all. Even if you know nothing about how to do it there are experienced people on-hand to help. If you don't know coding then that can even be an advantage because you avoid getting embroiled in 'interesting' details. Sometimes these competitions have led to prizes, such as netbooks and things. Bodhi Linux have such awarded a a few people netboks as top prizes. The QA team here did the same around a year ago. I think this time there isn't a prize but it's a good time to get in some practice. Good luck all! Regards from Tom :) Thanks for mentioning this. :)I think bug hunts are great, but I need to ask this question: how does the current backlog of bugs factor in with these bug hunts? I understand the bug hunts are great for finding new bugs, but I've filed several bug reports, some of which have been stagnant for over six months. Well you're right, it is about finding new bugs (or previously fixed bugs that may reappear) in the development versions. Actually, old or open bugs get fixed at every new release, while others get (unfortunately) introduced. That's the factor you were asking about I guess? Not really. I was asking how current backlog bug reports factor in with these bug hunts. As bugs are fixed in each new release, those bug reports are eventually resolved and maybe even closed. They might be reopened if a regression occurs, but that's something different. I do understand the need to find out if new features and functionality either have problems, themselves, or possibly caused regressions but a regression is a break of something that previously worked. A bug report that's still in New status, like my sample bug, hasn't been fixed and my question is: during these bug hunts, is there any effort put into seeing if any of the backlog bug reports have also been fixed or is the intent mostly to focus on the new stuff, making sure new features and functions work properly and to see if any regressions have been introduced. Here is an example: https://bugs.freedesktop.org/show_bug.cgi?id=57116 It's not really stagnant. As I read on the bug reports comments, you filed that bug against the 3.6.2 version. This version is obsolete; but someone actually tested the problematic behaviour with a 4.2.0 and the bug was no longer observed: So even it is not informed here, it is solved for the releases in production. So it was fixed somehow. Please keep in mind that bug fixes are only brought to actively supported versions (the ones you can download from the website), not obsolete ones like the 3.6.x branch. Yep, release 3.6.2 is certainly obsolete but that's the version of the software in which I first experienced the problem. I certainly hope bug reports filed against *now* obsolete releases aren't being ignored. As for the status of my sample bug report being changed to invalid, I'm addressing that now since I experienced the same problem with Writer 4.2.3 on Windows XP. :) I'm excited about LibreOffice 4.3's release because the software keeps getting better and better. However, it's also a bit frustrating when reported issues exist for a long period of time. I hope I have answered your question;of course there are always unresolved issues that are still in the actively supported versions. Devs try hard to squash these bugs, and are very successful at doing that, but there are always some leftovers. Yes, you have and I appreciate your response. :) Peace... Tom Cheers, Charles. Thanks! Peace... Tom On 24 April 2014 12:19, Italo Vignoli it...@documentfoundation.org wrote: The Document Foundation (TDF) announces the schedule of the first LibreOffice 4.3 bug hunting session, which will start with the availability of the first beta of the new major release in calendar week 21 (May 23 to May 25). Participating will be easy. Details of the bug hunting session are on TDF wiki (https://wiki.documentfoundation.org/BugHunting_Session_4.3.0), where there is also a growing list of LibreOffice 4.3 new features and improvements to check for bugs and regressions (https://wiki.documentfoundation.org/ReleaseNotes/4.3). To participate, it will be necessary to have a PC with Windows, MacOS or Linux, and LibreOffice 4.3 Beta 1 (available at http://www.libreoffice.org/pre-releases), plus a lot of enthusiasm. Filing bugs will be extremely easy, thanks to the help of experienced volunteers who will be around on the QA mailing list (libreoffice...@lists.freedesktop.org) and IRC channel (irc://irc.freenode.net/#libreoffice-qa). A second LibreOffice 4.3 bug hunting session will be organized
[libreoffice-users] Question about LibreOffice Calc 4.2.1 and MS Excel workbook
Hi! A friend of mine has LibreOffice 4.2.1 installed alongside MS Office 2010 Starter Edition on his Windows 7 system. He received an Excel spreadsheet via email which he can open just fine in both Excel and Calc. The problem is when he opens the file in Calc, it opens with the page zoom set to 60%. When he opens the file in Excel, it opens with page zoom set to 100%. Because of this, he didn't think he could edit the file in Calc since he couldn't read the info. He wasn't aware of the page zoom capability of either application. :) Any ideas as to why Calc would open the spreadsheet with a page zoom of 60%? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LibreOffice Calc 4.2.1 and MS Excel workbook
On 03/08/2014 06:15 PM, Brian Barker wrote: At 17:18 08/03/2014 -0800, Tom Williams wrote: A friend of mine has LibreOffice 4.2.1 installed alongside MS Office 2010 Starter Edition on his Windows 7 system. He received an Excel spreadsheet via email which he can open just fine in both Excel and Calc. The problem is when he opens the file in Calc, it opens with the page zoom set to 60%. When he opens the file in Excel, it opens with page zoom set to 100%. Because of this, he didn't think he could edit the file in Calc since he couldn't read the info. He wasn't aware of the page zoom capability of either application. :) Experimentation suggests that the zoom factor in use when the document file is saved is stored in the document, with the effect that it can be reopened with the same appearance. This is the case whether the document is saved as .xls, .xlsx, or .ods. Calc appears to respect the saved zoom factor in each case, but Microsoft Office 2010, whilst it respects the zoom saved in .xls and .xlsx files, ignores that in .ods files - even when saved by Microsoft Office itself. Any ideas as to why Calc would open the spreadsheet with a page zoom of 60%? Presumably it was being displayed at a zoom factor of 60% and was saved as an .ods file. I trust this helps. Brian Barker Thanks for the information. I'll do some experimentation with the particular file in question and see what happens. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about LibreOffice Calc 4.2.1 and MS Excel workbook
On 03/08/2014 06:47 PM, James E Lang wrote: I think Calc defaults to zoom of 60% when the View mode is Page instead of Normal. Thanks! I'll look into this too! Peace... Tom On March 8, 2014 6:38:23 PM PST, Tom Williams tomd...@comcast.net wrote: On 03/08/2014 06:15 PM, Brian Barker wrote: At 17:18 08/03/2014 -0800, Tom Williams wrote: A friend of mine has LibreOffice 4.2.1 installed alongside MS Office 2010 Starter Edition on his Windows 7 system. He received an Excel spreadsheet via email which he can open just fine in both Excel and Calc. The problem is when he opens the file in Calc, it opens with the page zoom set to 60%. When he opens the file in Excel, it opens with page zoom set to 100%. Because of this, he didn't think he could edit the file in Calc since he couldn't read the info. He wasn't aware of the page zoom capability of either application. :) Experimentation suggests that the zoom factor in use when the document file is saved is stored in the document, with the effect that it can be reopened with the same appearance. This is the case whether the document is saved as .xls, .xlsx, or .ods. Calc appears to respect the saved zoom factor in each case, but Microsoft Office 2010, whilst it respects the zoom saved in .xls and .xlsx files, ignores that in .ods files - even when saved by Microsoft Office itself. Any ideas as to why Calc would open the spreadsheet with a page zoom of 60%? Presumably it was being displayed at a zoom factor of 60% and was saved as an .ods file. I trust this helps. Brian Barker Thanks for the information. I'll do some experimentation with the particular file in question and see what happens. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about Calc and user-defined number formats
So, I installed LibreOffice 4.2.0 on a Windows 7 system today and was showing the system owner how to use it. I created a new spreadsheet and added two columns and four rows, the last row being a total row that would show the sum of the previous rows. The first row I added was column headings. The second row I added had text in the first cell and the number 50 in the second cell. The third row I added had text in the first cell and the number 40 in the second cell. The fourth row was blank. The fifth row was the total row. Cool. So, I selected cells B2..B5 and used the Format/Cells function to change the format to a currency format. I chose the -$1,234.00 in red format. The numbers in column B were changed accordingly. Then, my friend wanted only the first cell with a number to have a dollar sign and the numbers below it to NOT have a dollar sign. So, I selected cells B3..B5 and used the Format/Cells function to change the format. When the Format Cells window appeared, the Currency number format was selected, as expected. I went to the Format code box and simply removed the $$ references, leaving the rest of the format code intact. The Category immediately changed to User Defined, which is fine. Here's the problem: after the category changes to User Defined, the modified format code, which is still displayed, doesn't apply to the selected cells and I can't find any way to save the modified currency format as a user defined format I can reuse. I tried changing the comment of User-defined to something else, thinking that might be used as a category name or something. What am I doing wrong? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Question about Calc and user-defined number formats
On 02/16/2014 02:36 PM, Brian Barker wrote: At 11:27 16/02/2014 -0800, Tom Williams wrote: I selected cells B2..B5 and used the Format/Cells function to change the format to a currency format. I chose the -$1,234.00 in red format. The numbers in column B were changed accordingly. Then, my friend wanted only the first cell with a number to have a dollar sign and the numbers below it to NOT have a dollar sign. So, I selected cells B3..B5 and used the Format/Cells function to change the format. When the Format Cells window appeared, the Currency number format was selected, as expected. I went to the Format code box and simply removed the $$ references, leaving the rest of the format code intact. The Category immediately changed to User Defined, which is fine. Here's the problem: after the category changes to User Defined, the modified format code, which is still displayed, doesn't apply to the selected cells ... Nothing happens until you confirm by clicking OK, of course. But if you mean that the format didn't change even after you clicked OK, then the obvious first possibility is that you had made an error in modifying the string in the Format code box and had created something that was not a valid format code. In this case, the format of the selected cells would not change and no new format example would be created in the User-defined category. (You can test this by experiment.) Thanks for posting this. Duh :) Since no message of any kind was issued telling me the modified format might be invalid, it didn't occur to me that I was breaking the format code. I'll experiment with this. Thanks! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Help needed with LibreOffice Calc 4.1.3.2
On 01/21/2014 05:03 AM, Carl Paulsen wrote: Hi Tom, You can try View-Value Highlighting for the email column. That works on my Mac running LO 4.1.4. But it still leaves the gray cell background fill. As for gridlines, I don't know if that can be done. Carl Thanks for the reply! Peace... Tom On 1/20/14 9:29 PM, Tom Williams wrote: Hi! This is my first time posting to the mailing list. :) A client of mine is in need of editing some Excel spreadsheets on her shiny new Windows 8 system. I installed LibreOffice 4.1.3 and it mostly works but she's not able to do some of the things she used to do with MS Excel 2000. Primarily, she wants to be able to change the color of hyperlinks of email addresses. In MS Excel 2000, she could simply select the column of email addresses and change the color to black or any other color and the color of the links changes. In Calc, we select the column of email address and change the text color to black and the hyperlinks remain blue. I did some web searching and found I needed to edit the hyperlink style, but that appears to be only for cells that use the HYPERLINK formula (if that's what it's called) and not on cells that have email addresses listed that aren't using HYPERLINK syntax. I have a test Excel spreadsheet (generated with MS Excel 2000) I can send, if necessary. Any ideas on how I can get the color of the email address links to change color? She would like to preserve the links, in the spreadsheet, as she'll occasionally click them to send messages from Mozilla Thunderbird. Also, is it possible to adjust the thickness of grid lines shown in a spreadsheet, if we enable display of grid lines? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Help needed with LibreOffice Calc 4.1.3.2
On 01/21/2014 11:37 AM, Tinkerer wrote: To adjust the line thickness of the grid: Format Cell Borders Line Width From there you can alter the color, the spacing and the Line Arrangement. Tink. Thanks for this info! :) Peace... The other Tom :) -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Help needed with LibreOffice Calc 4.1.3.2
Hi! This is my first time posting to the mailing list. :) A client of mine is in need of editing some Excel spreadsheets on her shiny new Windows 8 system. I installed LibreOffice 4.1.3 and it mostly works but she's not able to do some of the things she used to do with MS Excel 2000. Primarily, she wants to be able to change the color of hyperlinks of email addresses. In MS Excel 2000, she could simply select the column of email addresses and change the color to black or any other color and the color of the links changes. In Calc, we select the column of email address and change the text color to black and the hyperlinks remain blue. I did some web searching and found I needed to edit the hyperlink style, but that appears to be only for cells that use the HYPERLINK formula (if that's what it's called) and not on cells that have email addresses listed that aren't using HYPERLINK syntax. I have a test Excel spreadsheet (generated with MS Excel 2000) I can send, if necessary. Any ideas on how I can get the color of the email address links to change color? She would like to preserve the links, in the spreadsheet, as she'll occasionally click them to send messages from Mozilla Thunderbird. Also, is it possible to adjust the thickness of grid lines shown in a spreadsheet, if we enable display of grid lines? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted