Re: [libreoffice-users] Editing contents of an ODS file...

2022-01-14 Thread Gilles Gravier
... I'll know next time. Gilles Le ven. 14 janv. 2022 à 18:29, sophi a écrit : > > Hi Gilles, > Le 14/01/2022 à 18:01, Gilles Gravier a écrit : > > Hi! > > > > I have a broken ODS file. LibreOffice can't repair it. > > > > When opening the ODS file in a

[libreoffice-users] Editing contents of an ODS file...

2022-01-14 Thread Gilles Gravier
. Unfortunately 7--zip let's me open the ODF file, and even extract its contents... but not write the updated archive. Any idea how I can do that? Thanks! Gilles -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Brian Barker wrote > Yes, if your locale needs semicolons as separators commas will not do. > That is definitely > what error 509 will be signalling. Odd that the locale would change the sign used in functions. Brian Barker wrote > That is because you have - weirdly - chosen to mess up my

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Problem solved by copy/pasting into a text colum, manually selecting the relevant cells, and running a regex to prepend a minus sign. Not proud of this, but it got the job done. Thanks everyone for the help. https://postimg.cc/6yVT0V8C -- Sent from:

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Thank you. The issue with Error 509 was apparently due to columns being of the wrong type (source should be text, and target should be number), and using "," instead of ";" in Left() and Mid(). After copy/pasting into/from Notepad, it's working… but the West/East isn't: Even when LO finds "O"

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Gilles wrote > I get the same error even after reformatting the data as XX:XX:XX, and > changing the column from Number to Time: … and yet again after fixing the typo (A1 → D1): https://postimg.cc/VdkQt7Rp <https://postimg.cc/VdkQt7Rp> -- Sent from: http://document-foundation-

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Gilles wrote > I tried this formula, but get error 509 ("operator expected"). Maybe it's > because the cell contains "Numbers"? I get the same error even after reformatting the data as XX:XX:XX, and changing the column from Number to Time: https://postimg.cc/D43Hm6zj &l

[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

2020-11-22 Thread Gilles
Thanks everyone for the input. Using regexes, I split the latitudes and longitudes so they're in their own columns. Brian Barker wrote > I'm guessing that "O" means "east" (as in "ouest"?) and that the > alternatives to "O" and > "N" are "E" and "S" respectively? Sorry, I didn't pay

[libreoffice-users] [Calc] Convert GPS coords from DMS to decimals?

2020-11-21 Thread Gilles
Hello, I need to convert GPS coordinates from degrees+minutes+seconds (DMS) to decimal, eg. 00°05'12"O 42°59'12"N → 42.9867,-0.0867 https://postimg.cc/QH0q5qmn Can Calc do this, or should I look elsewhere? Thank you. -- Sent from:

[libreoffice-users] Re: [Draw] Colorize SVG?

2020-11-16 Thread Gilles
Please ignore the question: Turns out LO Draw can import a bitmap, and turn it into an SVG file, so potrace's lack of support for colors doesn't matter. https://listoffreeware.com/best-free-png-to-svg-converter-software-windows/ -- Sent from:

[libreoffice-users] [Draw] Colorize SVG?

2020-11-16 Thread Gilles
Hello, I know nothing about graphic design, and am trying to make a flyer for a club I'm a member of. Inkscape and GIMP are pretty big, so I'm first trying LibreOffice Draw. To get a clean look when zooming in, I used ImageMagick's Convert to turn the club's logo from PNG to PNM, and then used

[libreoffice-users] Re: [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

2020-09-21 Thread Gilles
Found it: 1. Tools > Customize > Keyboard 2. Category = Edit, Function = Delete Rows 3. Shortcut Keys = CTRL+Del 4. "Modify" to assign shortcut -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] Re: [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

2020-09-21 Thread Gilles
Thanks. I'd rather a single shortcut eg. CTRL+SHIFT+-. I'll see if I can find a way. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

2020-09-21 Thread Gilles
Hello, I need a keyboard shortcut to delete the current row CTRL+- only works when 1) reaching for the mouse and 2) clicking on its ID number on the left-most column (1,2,3, ie. the "grey part")… which beats the point of keyboard shortcuts. Do you know of a way? Thank you. -- Sent from:

[libreoffice-users] Re: [Calc] Good way to turn hours+minutes into minutes?

2020-07-17 Thread Gilles
Brian Barker wrote > I'm guessing that you have text values. If so, use > =LEFT(Xn;2)*60+RIGHT(Xn;2) That was the easiest solution: =LEFT(F3;2)*60+RIGHT(F3;2) Next, copy the cell (formula), select all the cells below, and paste. But before, make sure the destination column is also set to

[libreoffice-users] [Calc] Good way to turn hours+minutes into minutes?

2020-07-17 Thread Gilles
Hello, I have a spreadsheet where time is formatted as HHhMM. In the next column, I'd like to show this in minutes. What would be a good way to achieve this? Thank you. https://i.postimg.cc/qRKCK14F/image.png -- Sent from:

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-14 Thread Gilles
Lessons learned: 1. By default, LO uses "Default Text" for formatting: Make sure you use Text Body for parapgraphs 2. Make sure you do no not change formatting locally, eg. changing the font size: Use Styles for this 3. To remove local changes, select the text, and hit CTRL+M ("Clear Direct

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Gilles
Andrew Pitonyak wrote >  You can do this with search and replace.  My hero! https://postimg.cc/gXGpTLd6 Thank you. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: [6.4.2.2] List footnotes in Writer?

2020-07-13 Thread Gilles
Not exactly what I was looking for, although it might be possible to make a list by running a macro, but you can jump from one footnote to the other through the Find function: https://postimg.cc/Jt8PDc4L -- Sent from:

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Gilles
steveedmonds wrote > Possibly first you need to make sure that there is no direct formatting > applied to the paragraphs as this will override the style setting. Note > that clearing direct formatting will clear any bolding/italics and > super/sub scripts. Good to know, thanks for the tip

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Gilles
Jean-Francois Nifenecker wrote > It does as it says: it updates the *currently selected paragraph* > according to changes made through direct formatting. > > Say you've selected a paragraph that is in Text Body paragrah style. You > set its font DejaVu Sans 14. If you click the button, the

[libreoffice-users] [6.4.2.2] List footnotes in Writer?

2020-07-13 Thread Gilles
Hello, I'd like to check that all footnotes have been added to a document. Apparently, Writer doesn't include footnotes in Navigator (F5): https://bugs.documentfoundation.org/show_bug.cgi?id=98005 Is there a work-around? Thank you. -- Sent from:

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Gilles
Also, I can't figure out what Styles > Update Selected Style actually do. No infos in the online help. https://help.libreoffice.org/6.4/en-US/text/swriter/main.html?System=WIN=WRITER After changing the font + size in Styles > Edit Style > Apply, I assumed it would change the font + size for

[libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Gilles
remygauthier wrote > Option 2: Use Search and Replace. Place your cursor in the Find box and > then then click Format... Configure to Arial Unicode MS 11, then place > your cursor in the Replace box, hit Format... again and put Liberation > Serif 12. Then "Replace All". Probably a safer option...

[libreoffice-users] [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-12 Thread Gilles
Hello, Not sure how to to word this better: Some "Text Body" paragraphs are in Arial Unicode MS 11 while others are in Liberation Serif 12. I haven't found a way to have Writer set all Text Body to be Liberation Serif 12. Is there a way to automate this? Thank you. -- Sent from:

[libreoffice-users] Re: [newbie/Calc] How to mix relative/absolute cells in formula?

2019-10-02 Thread Gilles
Brian Barker wrote > That $ holds the column indicator, E, fixed, so that it would not be > automatically changed to another column (F2, G2, ...) if you filled or > copied the formula to other *columns*. What you need here is just to keep > the row indicator, 2, fixed, so you need E$2 instead.

[libreoffice-users] [newbie/Calc] How to mix relative/absolute cells in formula?

2019-10-02 Thread Gilles
Hello, Another newbie question: I need to show percentages in columns. This involves using a relative cell as numerator, and an absolute cell as denominator. https://postimg.cc/G9tccRmV I tried adding $… 1. in the first cell: NOK. 2. in the second cell: NOK. How can I apply the formula to all

[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?

2019-10-02 Thread Gilles
Johnny Rosenberg wrote > If your cell was formatted as text, then whatever you type into that cell > will be displayed as pure text. The funny thing is that changing the > format doesn't help. You must first empty the cell, then format it as a > number, then type your formula again. You can also

[libreoffice-users] Re: [newbie/Calc] Why does SUM() not compute?

2019-10-02 Thread Gilles
Thanks. No change. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- 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:

[libreoffice-users] [newbie/Calc] Why does SUM() not compute?

2019-10-02 Thread Gilles
Hello, I made sure the column is set to Number. For some reason, SUM() doesn't work. It only displays the formula: https://postimg.cc/k29XkyJs Any idea why? Thank you. -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail

Re: [libreoffice-users] Libreoffice corrupted by Ubuntu failed upgrade

2019-04-21 Thread Gilles Gravier
Please don't spread nonesense. Ubuntu upgrades are designed to work well in the VAST majority of cases. Gilles On Sun 21 Apr 2019, 18:04 jonathon, wrote: > On 4/21/19 10:56 AM, Keith Bates wrote: > > So I thought I would upgrade from Ubuntu to 18.10 to 19.04. The normally > > Th

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Gilles Gravier
Linux, Leap 15.0. > > > On 08/08/2018 12:20 PM, James Knott wrote: > > On 08/08/2018 12:15 PM, Gilles Gravier wrote: > >> On Windows 7 it works on SeaMonkey 2.49.1 on my system. > >> > > Same version on 15.0. > > > > > -- > To unsubscribe e-mail

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Gilles Gravier
On Windows 7 it works on SeaMonkey 2.49.1 on my system. Gilles 2018-08-08 18:08 GMT+02:00 James Knott : > On 08/08/2018 11:49 AM, Gilles Gravier wrote: > > For me it works fine with Chromium and Firefox... on Windows and on > > Ubuntu 18.04.1. > > I did some more testi

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Gilles Gravier
help with first >>>> responses. >>>> >>>> Good luck and regards from >>>> a Tom :) >>>> >>>> >>>> >>>> >>>> On Wed, 8 Aug 2018 at 11:13, Mike Saunders < >>>> mike.saund...@docu

[libreoffice-users] Re: Best practices when working with LibreOffice Impress?

2018-05-11 Thread Gilles
Virgil Arrington wrote > As you already know, LO can export directly to PDF, but I don't > understand your question about merging the PDF files into a single file. > When I save an Impress file as a PDF, it automatically saves it as a > single file. So, I'm not sure what you're trying to

[libreoffice-users] Best practices when working with LibreOffice Impress?

2018-05-11 Thread Gilles
Hello, I have zero knowledge of PDF, and need to make a list of recommendations to users working with LibreOffice Impress so that their presentations will use the same parameters (size, fonts, etc.) and be rendered into nice HTML. I have a couple of newbie questions: 1. Wouldn't it be

Re: [libreoffice-users] LibreOffice - patches

2018-03-22 Thread Gilles Gravier
report available here : http://go.coverity.com/rs/157-LQW-289/images/2014-Coverity-Scan-Report.pdf). Note that in the paragraphs above, I didn't mention what project this applies to. It's because it applies to ALL software projects (open source or not, LibreOffice or others). :) Enjoy the g

Re: [libreoffice-users] getting LO source

2017-11-06 Thread Gilles Gravier
Mike, For me, it's downloading... I'm at 25% and no specific issue. I copy pasted your line directly. Try again now? Maybe a network or a server error that has since been fixed? Gilles On 06/11/2017 15:26, Mike Scott wrote: > There being no answers to the long-standing issues with play

[libreoffice-users] Re: Simple way to draw graphs ?

2017-08-16 Thread Gilles
Found it: 1. Double-click on the chart 2. Format > Axis > Y Axis 3. In the Scale dialog, uncheck Automatic for the Major/Minor interval (count), and assign "1" 4. OK. Thanks ! -- View this message in context:

[libreoffice-users] Re: Simple way to draw graphs ?

2017-08-16 Thread Gilles
remygauthier wrote > You can adjust the scaling of number values by formatting the axis. Select > the axis (click on one of the numbers) on the graph, then right click and > select Format Axis... On the first tab (Scale), you can unselect the > "Automatic" scaling for the major and minor intervals

[libreoffice-users] Re: Simple way to draw graphs ?

2017-08-16 Thread Gilles
Almost there :-) One last thing I didn't figure out: Why does Calc display the Y axis every other data (0-2-4, instead of 0-1-2-3)? https://s27.postimg.org/3uvol2mhf/Libre_Office.calc.empty.x.y.chart.png -- View this message in context:

[libreoffice-users] Re: Simple way to draw graphs ?

2017-08-16 Thread Gilles
Can Calc plot an empty x/y graph with just the labels on the two sides and grid, like this: https://tex.stackexchange.com/questions/278295/how-can-i-draw-an-empty-plot And if it can export it as a vector graphic, I could open it in a paint application and draw the curves manually without trying

[libreoffice-users] Re: Simple way to draw graphs ?

2017-08-15 Thread Gilles
Regina Henschel wrote > Or in case the scan is too ugly, you have to read the scan and enter the > coordinates as data in the table. From the image I guess, that five points > are sufficient. You need an XY-chart, because otherwise the years > are not at the ticks but between the ticks. > >

[libreoffice-users] Simple way to draw graphs ?

2017-08-14 Thread Gilles
Hello I'd like to use LO to redraw graphs scanned from a book, such at this one: Is there a simple way in LO to do this, ideally without using maths (unless it's a no-brainer)? Thank you. -- View this message in context:

[libreoffice-users] Re: Can LO build a TOC from a PDF file?

2017-07-10 Thread Gilles
Thanks much everyone. I naively thought it could simply be done by converting the PDF into text in LO, and run a few regexes to build a TOC :-/ -- View this message in context: http://nabble.documentfoundation.org/Can-LO-build-a-TOC-from-a-PDF-file-tp4217910p4217934.html Sent from the Users

[libreoffice-users] Can LO build a TOC from a PDF file?

2017-07-09 Thread Gilles
Hello, This PDF file has no Table of Contents, and I was wondering if LO could grab all the headers and build a TOC. Thank you. -- View this message in context:

[libreoffice-users] [Win 5.1.6.2] Writer fails reading Win1252-encoded HTML document

2017-01-15 Thread Gilles
Hello I wrote an HTML document using an older release of Nano WebEditor. I guess it saves data as Win1252 instead of UTF8. When opening the file in LibreOffice, all the accents are messed up: https://s29.postimg.org/iicxnws1z/Libre_Office_Writer_How_to_convert_from_Win1252_t.jpg Any idea what

Re: [libreoffice-users] need help off this list - need Linux package choice help

2016-10-24 Thread Gilles Gravier
cribe 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/user

Re: [libreoffice-users] need help off this list - need Linux package choice help

2016-10-24 Thread Gilles Gravier
Hi, Openshot is actually in the default Ubuntu repositories now. :) Gilles On Mon, Oct 24, 2016 at 6:31 AM, tonybsa <tony...@me.com> wrote: > Hi Tim > > There is a very comprehensive Video editor for Linux called OpenShot 2.0. > Runs well on Ubuntu 16.04. (Not sure abo

Re: [libreoffice-users] Windows 10 Anniversary Update found LibreOffice as malware

2016-10-20 Thread Gilles Gravier
ion.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- Gilles Gravier - gil...@gravier.org GSM : +33618347147 and +41794728437 Skype : ggravier | PGP Key : 0x8DE6D026 <http

Re: [libreoffice-users] Goodbye to Open Office (maybe?)

2016-09-03 Thread Gilles Gravier
he number of unpatched vulnerabilities inside)... They are pathetic. And dangerous. And dying... Apache Foundation has many much more great projects that they are working on, and doing a great job of keeping active! Gilles --- This email has been checked for viruses by Avast antivirus software. h

Re: [libreoffice-users] File->Exit LibreOffice doens't work in 5.1.1 on Windows

2016-03-10 Thread Gilles Gravier
Ah. Just saw. Duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=92516 :) Cheers, Gilles. On Thu, Mar 10, 2016 at 2:32 PM, Dries Feys <dries.f...@tvh.com> wrote: > Works fine with me (win7 x64, Version: 5.1.1.3) > > Met vriendelijke groeten, Salutations distinguée

[libreoffice-users] File->Exit LibreOffice doens't work in 5.1.1 on Windows

2016-03-10 Thread Gilles Gravier
oses it. Just the file->Exit LibreOffice menu doesn't. Doesn't happen on Ubuntu Linux... here closing method works. Do you get that behavior too? -- Gilles Gravier - gil...@gravier.org GSM : +33618347147 and +41794728437 Skype : ggravier | PGP Key : 0x8DE6D026 <http://pgp.mit.edu:1137

[libreoffice-users] File->Exit LibreOffice doens't work in 5.1.1 on Windows

2016-03-10 Thread Gilles Gravier
t;Ctrl-Q" shortcut, it properly closes it. Just the file->Exit LibreOffice menu doesn't. Doesn't happen on Ubuntu Linux... here closing method works. Do you get that behavior too? Thanks, Gilles -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.lib

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

2015-09-17 Thread Gilles
anne-ology wrote > Maybe you've found a bug in your version because the slides stay animated > for me; Or maybe it's file-dependent. As a work-around, I just took screenshots from MS PowerPoint Viewer. -- View this message in context:

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

2015-09-17 Thread Gilles
anne-ology wrote > you could 'hide' all the slides except the one you wish to show Didn't know that feature. I'll keep it handy for the next time. Thank you. -- View this message in context:

[libreoffice-users] [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

2015-09-16 Thread Gilles
Hello I'm using LibreOffice 5.0.1.2 to open a PowerPoint file using LO's Impress. I can successfully export all the slides in one go through File > Export as images, but can't find how to export a given slide. I searched through the File menu, through the "Export as images" dialog, by

[libreoffice-users] [LibreOffice 5.0.1.2] How to play an animated slide?

2015-09-16 Thread Gilles
Hello I have another Impress-related question to which I (obviously) found no answer. Some of the slides are animated, but Impress only shows the first part. I notice that those slides an little icon on the left… http://s12.postimg.org/r5u63t771/Libre_Office_Impress_play_animated_slide.png … but

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

2015-09-16 Thread Gilles
Thanks guys. Copy/paste into Paintshop Pro did the trick, although it'd make sense to have that option in the pop-up menu when right-clicking on a given slide. -- View this message in context:

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

2015-09-16 Thread Gilles
As a work-around, I installed MS' free PowerPoint Viewer, and copy/pasted screenshots into (again) Paintshop Pro because PPV's "Copy slide" function doesn't copy screenshots in a format that PSP couldn't understand. Still, I wish Impress could read PowerPoint animated slides, at least show the

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

2015-09-16 Thread Gilles
If I use Slide Show > Start from current slide, it only plays part of the animation :-/ -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-play-an-animated-slide-tp4160509p4160516.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

2015-09-16 Thread Gilles
V Stuart Foote wrote > Glad you got it sorted, but why into Paintshop Pro. Because I'm used to it :-/ But yes, it'd make more sense to paste it into LO's alternative. -- View this message in context:

[libreoffice-users] [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Gilles
Hello I often use Calc to prepare multi-day trips, and have to write series that look like this: Mon 1 Aug Tue 2 Aug Wed 3 Aug etc. Does Calc come with a way to automate this tedious task, or is there some macro that I could copy/paste from somewhere? Thank you. -- View this message in

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Gilles
Found it: What you type in the cell must match exactly the format chosen in the Format Cells dialog, in the Format section. For instance, if you choose Fri. 31 Dec. 99, that is exactly what you must type for LO to figure things out. Thanks a lot! -- View this message in context:

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Gilles
I simply typed Mon 1 Aug and expected LO to figure it out. But I guess the doco should say that user must first start with a simple DD/MM/, before telling LO that it's a date, and clicking to get a series. Computers are not *that* smart ;-) -- View this message in context:

[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

2015-07-15 Thread Gilles
To make matters worse - or more interesting, progammatically speaking -, I could be running the French version of LO and type Mon instead of Lun ;-) -- View this message in context:

[libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-18 Thread Gilles
Thanks everyone. I found an application based on OpenERP that does the job. http://wiklou.org/index.php/Cat%C3%A9gorie:Burette -- View this message in context: http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774p4148848.html Sent from the

[libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-17 Thread Gilles
Thanks. It's a DIY, non-profit bicycle organization. Stock = parts they buy and must keep track of. Membership = people must subscribe to a one-year membership to have access to the location and work on their bikes. Windows. -- View this message in context:

[libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-17 Thread Gilles
Thanks, but the user wants a desktop application, so a web-based CRM won't do (and is overkill). The search goes on. -- View this message in context: http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774p4148805.html Sent from the Users

[libreoffice-users] [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-17 Thread Gilles
Hello Someone I know heads a non-profit organization, and needs a small database to manage membership and inventory (stock). Before building new databases, are there ready-to-use solutions? Thank you. -- View this message in context:

[libreoffice-users] Re: [Base] Ready-to-use solutions to manage membership + inventory?

2015-05-17 Thread Gilles
Which is why I asked about templates so that person can just download, install, and be on his way. http://templates.libreoffice.org/template-center -- View this message in context:

[libreoffice-users] Export all slides from a PowerPoint document?

2014-12-28 Thread Gilles
Hello I need to export all the slides that are part of a PowerPoint document. I don't know which version of PowerPoint was used, but a right-click says Microsoft PowerPoint 97-2003 Presentation (.ppt). The slides contain text and images, but Google only returned infos about how to either export

[libreoffice-users] Re: Export all slides from a PowerPoint document?

2014-12-28 Thread Gilles
Out of band, I was suggested to install the following extension, which worked fine: http://extensions.libreoffice.org/extension-center/export-as-images -- View this message in context: http://nabble.documentfoundation.org/Export-all-slides-from-a-PowerPoint-document-tp4134267p4134273.html

[libreoffice-users] [PDF] Export all pages as PNG in one go?

2014-05-27 Thread Gilles
Hello Someone sent me a presentation where slides are part of a PDF file instead of the more common PowerPoint. When opening the file in LibreOffice Draw, I can select each page and hit File Export to get a PNG file, but it appears that it's not possible to select all the pages with CTRL, hit

[libreoffice-users] Re: [PDF] Export all pages as PNG in one go?

2014-05-27 Thread Gilles
Thanks for the infos. ImageMagick did the trick, so I didn't try the LO extension. convert -density 96 input.pdf +adjoin -alpha remove -alpha off output.png -- View this message in context: http://nabble.documentfoundation.org/PDF-Export-all-pages-as-PNG-in-one-go-tp4110454p4110470.html Sent

[libreoffice-users] Re: Turning spreadsheet data into legible report?

2014-03-20 Thread Gilles
Thanks everyone for the feedback. As I learn more about spreadsheets, I thought merging all the years together into a single sheet and filtering data so that the wordprocessor would only see a subset of it would solve the issue... but it's not such a great idea since some students will attend

[libreoffice-users] Re: Turning spreadsheet data into legible report?

2014-03-20 Thread Gilles
Problem solved: Indeed, putting all the data into a single worksheet works OK. The only drawback is empty documents for kids who didn't attend a given year, but this could be avoided by adding some conditional loop in the Word mail merge document to avoid printing empty sections (eg. If

[libreoffice-users] Turning spreadsheet data into legible report?

2014-03-19 Thread Gilles
Hello A friend is a school teacher and needs to publish a report from the data she keeps in an Excel document. In addition, she only has access to Word/Excel, while Access is not available (she doesn't know databases, anyway.) I originally thought Word's mail merge would do, but without

[libreoffice-users] Re: Turning spreadsheet data into legible report?

2014-03-19 Thread Gilles
Sorry about that. The spreadsheet 1) has too many columns to fit on a document, even in Landscape mode (she wants Portrait), and 2) data are spread on multiple sheets, one by year. She needs to print the data thusly: = Last Name: Doe First Name : Jane Date of Birth: 12/12/2000

[libreoffice-users] Re: Turning spreadsheet data into legible report?

2014-03-19 Thread Gilles
Here's a better illustration of what I mean: http://postimg.org/image/hw6kh9vx1/ -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: [4.0/Win] Edit form?

2013-08-08 Thread Gilles
Thanks for the tip. I don't know where to look in LO to check if a document was saved in read-only. Figuring I'd save time, I filled and saved the DOCX as PDF, uploaded the file to a web site, and provided the URL in my reply. I'm sorry I'm unable to open the Lost in Post Declaration you have

[libreoffice-users] Re: [4.0/Win] Edit form?

2013-08-08 Thread Gilles
Thanks but it's not in read-only mode: http://postimg.org/image/qzs97o3tf/ The issue is that some fields don't work properly, and once, for some reason, LO displays the green squares around a field, it's not obvious how to get back to normal. As to why such a big company doesn't simply ask one

[libreoffice-users] [4.0/Win] Edit form?

2013-08-07 Thread Gilles
Hello LibreOffice Write is unable to let me fill this form: Lost.in.Post.Declaration1.docx http://bagofiles.free.fr/Lost.in.Post.Declaration1.docx Apparently, it's filled with macros. Does someone have an idea how to fill this? Thank you. -- View this message in context:

[libreoffice-users] Re: [4.0/Win] Edit form?

2013-08-07 Thread Gilles
Thanks Brian. After more fiddling, I figured how to enter edit mode and fill that form. What a waste of time. -- View this message in context: http://nabble.documentfoundation.org/4-0-Win-Edit-form-tp4069229p4069250.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Edit PDF to keep just one section?

2013-05-24 Thread Gilles
Hello On page 1, the following PDF contains a map + street names on the left that I'd like to keep, while removing the ads on the right: http://dl.free.fr/voAdI7RGX After opening the file in LibreOffice, I browsed through the menus, but didn't find an option that looked like Crop or something.

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-19 Thread Gilles
One more question: I couldn't find how to tell LO to use a smaller font size than the default 12: http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.font.size.png There's no option in the Labels dialog, Select All doesn't work, and neither does selecting a column or row. Is there no

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-19 Thread Gilles
Thanks for the tip. Indeed, the Labels dialog has a Synchronize contents option in its Options tab, which displays a Synchonize Labels window after creating the sheet. Selecting the first cell, changing its font size, and hitting the button does apply the change to the rest of the labels. Thank

[libreoffice-users] Re: [4.0.0.3/Windows/Write] How to resume single-column?

2013-03-18 Thread Gilles
Thanks Brian. I'll play with sections the next time I need some pages to be formated with either one or two columns. -- View this message in context: http://nabble.documentfoundation.org/4-0-0-3-Windows-Write-How-to-resume-single-column-tp4044138p402.html Sent from the Users mailing list

[libreoffice-users] [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
Hello I bought the following sheets of labels that have some pitches/margins: http://bagofiles.free.fr/libreoffice.labels/microapp.labels.sheet.jpg I tried Writers' File New Labels, and used user-specific settings, but the preview doesn't look like what I expected:

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
Tom wrote Is it easier just to use a table?  Each label corresponding to 1 cell.  Perhaps rows and columns between printable labels in order to create a margin? Thanks for the idea, but is there a way to tell LO to print a table that will cover the whole page, each cell having a specific width

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
sophi wrote May be this FAQ will be helpful Thanks but I did read the FAQ before posting here. The issue is that I don't know how to tell LO that the sheet has outer borders, but no borders between labels themselves (3 columns, 7 rows). I tried setting Horizontal Pitch and Vertical Pitch to 0

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
What I mean, is that LO can't seem to support labels that have no margins between them: http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.pitches.jpg -- View this message in context:

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
Thanks. Is there a way to tell LO that the table should fill the whole page? http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.table.fit.page.jpg -- View this message in context:

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
Thanks all for the input. I'll give it a try, and if it doesn't work, I'll just look for label sheets that have no margins at all. -- View this message in context: http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044613.html Sent from the Users

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
steveedmonds wrote I have just laid out a custom label like yours and it seems to preview correct. I assumed an A4 sheet and centalised label positions. Thanks, looks good. Apparently, it's not a table: How did you create a new style with the required columns + rows? -- View this message in

[libreoffice-users] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

2013-03-18 Thread Gilles
Thanks Steve. -- View this message in context: http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044633.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] [4.0.0.3/Windows/Write] How to resume single-column?

2013-03-15 Thread Gilles
Hello I need to format the first couple of pages in two columns, insert a manual page break, and then have the remainder of the document formated as single-column. After adding a manual page break, the focus is on the new page, formatted as two columns; I select Format Columns 1 column, but

[libreoffice-users] Re: [4.0.0.3/Windows/Write] How to resume single-column?

2013-03-15 Thread Gilles
Problem solved: I selected the new page improperly formated as two columns, told LO to format it as three columns, then formated it back to one column, and presto. Weird. -- View this message in context:

[libreoffice-users] [4.0/Win/Writer] Fold/unfold sections?

2013-02-22 Thread Gilles
Hello It looks like Writer is unable to do this, but I wanted to double-check. When writing longer pieces of text, it's handy to be able to folder other sections so that I only browse through the section I'm working it, à la NotePad++

[libreoffice-users] Re: [4.0/Win/Writer] Fold/unfold sections?

2013-02-22 Thread Gilles
Thanks for the tip. I read the docs, but it didn't display the structure of the document (H1 = Main title, H2 = Chapter1, Chapter 2, etc.) Anyway, it doesn't look like what I had in need, which was to actually fold/unfold the contents of the document within the Writer window itself. I wonder

  1   2   >