[libreoffice-users] Re: Transferring Markdown Documents to LibreOffice
Hi Tim Le 2016-11-27 à 18:02, Tim---Kracked_P_P---webmaster a écrit : Does CentOS 6.8 have access to the "ttf-mscorefonts-installer" package? This package includes Arial and Times New Roman and many of the core fonts you get with a Windows install. I use the DEB package, but hopefully there is a RPM package as well. On my main laptop, I have Arial in "normal" style, monospaced, condensed, narrow, and rounded font sets. Actually, I have over 180 fonts in my ".font"folder, and have over 14GB of font files on my "file server". No need to add fonts, LibreOffice will substitute quite easily with the Liberation family of fonts which are pretty well identical to Arial, the same with Times font. No need to install any MS fonts if you don't need to. The fonts shipped with LibreOffice are such that they will offer the largest success with respect to interoperability with fonts. Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- 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] "Today" in calc
Hello, You could also refer to this post: https://forum.openoffice.org/en/forum/viewtopic.php?f=45=30071 I believe it describes a way to do what you are looking for. Basically they describe a way to trigger a macro that monitors a range of cells and that performs a specific operation when something is changed. Rémy Gauthier. Le dimanche 27 novembre 2016 à 23:57 +, Brian Barker a écrit : > At 07:04 27/11/2016 -0500, William Drescher wrote: > > (2nd posting, it appears the first disappeared in cyberia) > > Both messages presumably awaited moderation. Your first arrived 47 > seconds after your second. > > > When I update the data in a spreadsheet I need to also update the > > one of two cells "date data sent" or "date data received." I can't > > figure out a way of doing that automagically so I have a field in > > the header set to TODAY() and I copy and paste that into the row. > > > > Plain pasting doesn't work as that will paste the function, not the > > > > value. Paste Special works but is a lot of clicks. Can anyone think > > of a better way to do this. > > Right-click | Paste Only > | Number? > > If you prefer, you can find Paste Only under Edit in Tools | > Customise... | Keyboard and bind it to an unused keyboard shortcut. > > 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
Re: [libreoffice-users] "Today" in calc
At 07:04 27/11/2016 -0500, William Drescher wrote: (2nd posting, it appears the first disappeared in cyberia) Both messages presumably awaited moderation. Your first arrived 47 seconds after your second. When I update the data in a spreadsheet I need to also update the one of two cells "date data sent" or "date data received." I can't figure out a way of doing that automagically so I have a field in the header set to TODAY() and I copy and paste that into the row. Plain pasting doesn't work as that will paste the function, not the value. Paste Special works but is a lot of clicks. Can anyone think of a better way to do this. Right-click | Paste Only > | Number? If you prefer, you can find Paste Only under Edit in Tools | Customise... | Keyboard and bind it to an unused keyboard shortcut. 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
[libreoffice-users] today's date in calc
As I work I need to paste today's date into a cell every time I update a row. My first approach is to put the today() function into a cell and then copy/paste it. That doesn't work as I don't want to past the function. I can paste special which works but is cumbersome. I am telling myself that there MUST be a simpler way. Can anyone suggest one ? -- -bill -- 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] "Today" in calc
(2nd posting, it appears the first disappeared in cyberia) When I update the data in a spreadsheet I need to also update the one of two cells "date data sent" or "date data received." I can't figure out a way of doing that automagically so I have a field in the header set to TODAY() and I copy and paste that into the row. Plain pasting doesn't work as that will paste the function, not the value. Paste Special works but is a lot of clicks. Can anyone think of a better way to do this. -- -bill -- 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] Transferring Markdown Documents to LibreOffice
On 11/27/2016 04:37 PM, Charles-H. Schulz wrote: Hello, H. @ 2016-11-27 19:00 GMT: On 11/20/2016 03:13 PM, Ricardo wrote: El 2016-11-20 14:45, Virgil Arrington escribió: Since Markdown is a pure text file with formatting marks inserted, you could easily edit such a file with LO. It sounds like what you're asking is a way to convert the Markdown file to a LO format. I'm not sure of a direct way of doing that. You might try Pandoc, an online file converter. Pandoc can be installed on any system, but only recent versions support ODT, so you need to look with version if offered by CentOS http://pandoc.org/ Regards, Ricardo I have installed pandoc and tried to converted two markdown documents to ODT opening them in LibreOffice 4.3.7 under CentOS 6.8. It seems Pandoc modifies the LO styles, setting fonts to Arial, Times Roman etc. which are not available in LO. Pandoc also did not assign the default list style to lists, nor did it handle tables at all. Although tables are not part of the core markdown they are part of a common extension. Does CentOS 6.8 have access to the "ttf-mscorefonts-installer" package? This package includes Arial and Times New Roman and many of the core fonts you get with a Windows install. I use the DEB package, but hopefully there is a RPM package as well. On my main laptop, I have Arial in "normal" style, monospaced, condensed, narrow, and rounded font sets. Actually, I have over 180 fonts in my ".font"folder, and have over 14GB of font files on my "file server". I would have preferred pandoc to use whatever the style settings are in LO, not trying to change anything. Actually it does not work that way; pandoc cannot guess what styles are used by LibreOffice. If you have written your two documents using markdown they simply cannot use LibreOffice styles "in advance". I think that what's really going on with Pandoc is that it has default settings for each type of export filters. Arial and Times Roman are fairly common fonts and by default LibreOffice can use them with no problem. On the other hand, using Markdown in my experience does not really make me expect to have nicely laid out documents (like with LibreOffice or LATEX for instance). Markdown is fundamentally a web and transitional format, made to process text on websites or online documentation. If you are looking for rich and complex styles I suggest to stick to LibreOffice or other kinds of tools such as LATEX. Best, -- 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] Transferring Markdown Documents to LibreOffice
Hello, H. @ 2016-11-27 19:00 GMT: > On 11/20/2016 03:13 PM, Ricardo wrote: >> El 2016-11-20 14:45, Virgil Arrington escribió: >>> >>> >>> Since Markdown is a pure text file with formatting marks inserted, you >>> could easily edit such a file with LO. It sounds like what you're asking >>> is a way to convert the Markdown file to a LO format. I'm not sure of a >>> direct way of doing that. You might try Pandoc, an online file converter. >>> >>> >> >> Pandoc can be installed on any system, but only recent versions support ODT, >> so you need to look with version if offered by CentOS >> >> http://pandoc.org/ >> >> Regards, >> Ricardo >> > I have installed pandoc and tried to converted two markdown documents to ODT > opening them in LibreOffice 4.3.7 under CentOS 6.8. > > It seems Pandoc modifies the LO styles, setting fonts to Arial, Times Roman > etc. which are not available in LO. Pandoc also did not assign the default > list style to lists, nor did it handle tables at all. Although tables are not > part of the core markdown they are part of a common extension. > > I would have preferred pandoc to use whatever the style settings are in LO, > not trying to change anything. Actually it does not work that way; pandoc cannot guess what styles are used by LibreOffice. If you have written your two documents using markdown they simply cannot use LibreOffice styles "in advance". I think that what's really going on with Pandoc is that it has default settings for each type of export filters. Arial and Times Roman are fairly common fonts and by default LibreOffice can use them with no problem. On the other hand, using Markdown in my experience does not really make me expect to have nicely laid out documents (like with LibreOffice or LATEX for instance). Markdown is fundamentally a web and transitional format, made to process text on websites or online documentation. If you are looking for rich and complex styles I suggest to stick to LibreOffice or other kinds of tools such as LATEX. Best, -- Charles-H. Schulz Co-founder, The Document Foundation, Kurfürstendamm 188, 10707 Berlin Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint Mobile Number: +33 (0)6 98 65 54 24. -- 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] Transferring Markdown Documents to LibreOffice
On 11/20/2016 03:13 PM, Ricardo wrote: El 2016-11-20 14:45, Virgil Arrington escribió: Since Markdown is a pure text file with formatting marks inserted, you could easily edit such a file with LO. It sounds like what you're asking is a way to convert the Markdown file to a LO format. I'm not sure of a direct way of doing that. You might try Pandoc, an online file converter. Pandoc can be installed on any system, but only recent versions support ODT, so you need to look with version if offered by CentOS http://pandoc.org/ Regards, Ricardo I have installed pandoc and tried to converted two markdown documents to ODT opening them in LibreOffice 4.3.7 under CentOS 6.8. It seems Pandoc modifies the LO styles, setting fonts to Arial, Times Roman etc. which are not available in LO. Pandoc also did not assign the default list style to lists, nor did it handle tables at all. Although tables are not part of the core markdown they are part of a common extension. I would have preferred pandoc to use whatever the style settings are in LO, not trying to change anything. -- 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: Line spacing changed.
On 2016-11-26 01:33, CVAlkan wrote: If the problem "goes away" when removing bullets, you are probably a victim of bug # 92657. Read through the entire conversation at: https://bugs.documentfoundation.org/show_bug.cgi?id=92657 Writer will sometimes substitute bullets from another font even when there are bullets in the font you're using; this is related to other font substitutions it makes based on the font matching info it gets from the OS. If this is the case, the spacing between the line with the bullet and the line immediately below it in the same paragraph will have greater spacing that what exists between any subsequent two lines in the same paragraph. If so, it may or may not help for you to post a confirmation reply to that bug along with the usual info: OS & version, version of LO, name of font in use, and anything else you think might be useful. I believe this is actually part of the deeper font substitution problem (although I suspect the thing with bullets is a special case). You CAN, by the way, sort of make the problem disappear by editing the bulleted list style and specifying a smaller bullet or your default font. Go to Styles and Formatting either from the Menu, the sidebar, or by pressing F11. Then choose Character Styles, and then Bullets (this latter does NOT appear unless you are set to "Show ALL styles" and even then it may show up as a series of 7 boxes instead of the characters "Bullets." Then, choose "Modify" and you'll see that Writer is not using your paragraph font for the bullets. Here you can do one of two things: making sure that you can see the actual document, change the font size and press "Apply" - if your paragraph size is set to 12, for instance, set the bullet style to 10 and see what happens. (Actually, first try setting it much larger and press Apply just to prove to yourself that this is the cause of your particular problem.) The other option is to simply change the font to the one you are using as the paragraph font and you'll see the problem disappear. I hope this has been explained clearly enough that you can "fix" your document. Thanks. The bullets, viewed when opened in LO 5.2.3.3 were starsymbol and not Arial like the text. Changing the bullets to arial made the document display correctly. steve -- 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
