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

[Gilles Gravier]

Merci Sophie!

So I played with that. But it happens that the content.xml file itself
is too badly corrupted for me to recover it. :(

Thanks! At least I learned how to unpack and ODF file... check the
content... and repack the file to a working version... But the content
was too damaged this time... 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 an archiver I can see that the directory
> > META-INF contains a vastly corrupted file. The rest of the files
> > inside seem OK.
> >
> > So I'm tempted to remove the META-INF directory and see if I can open the 
> > file.
>
> you cannot remove it, it has to be there
> >
> > Unfortunately 7--zip let's me open the ODF file, and even extract its
> > contents... but not write the updated archive.
>
> See Regina's answer in this thread, and also her hint at the end:
> https://ask.libreoffice.org/t/how-can-i-uncompress-a-libreoffice-document-to-get-its-xml-internals-then-make-a-new-document-from-them/59721/11
>
> Cheers
> Sophie
>
> --
> Sophie Gautier so...@libreoffice.org
> GSM: +33683901545
> IRC: soph
> Foundation coordinator
> The Document Foundation
>
> --
> 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



-- 
Gilles Gravier  - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0xA610DB098DE6D026

-- 
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] Editing contents of an ODS file...

[Gilles Gravier]

Hi!

I have a broken ODS file. LibreOffice can't repair it.

When opening the ODS file in an archiver I can see that the directory
META-INF contains a vastly corrupted file. The rest of the files
inside seem OK.

So I'm tempted to remove the META-INF directory and see if I can open the file.

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-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] Re: [Calc] Convert GPS coords from DMS to decimals?

[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 formula,
> changing my "E" (for east) into "O" (for west). So *of course* the
> longitude signs are now reversed. Reinstate my "E" and everything will
> work.

Because in the document O = West, not East (which I forgot to point out).

https://postimg.cc/QH0q5qmn   

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? 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] Re: [Calc] Convert GPS coords from DMS to decimals?

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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" ("ouest" for West) in the source, I'm not getting a
negative as expected:

https://postimg.cc/V0MgT0X3   



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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-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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 <https://postimg.cc/D43Hm6zj>  



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 attention to that part.

O = ouest = West
E = est = East


Brian Barker wrote
> If 00°05'12"O 42°59'12"N is in A1, then
> =(MID(A1,12,2)+(MID(A1,15,2)+MID(A1,18,2)/60)/60)*((RIGHT(A1,1)="N")*2-1)
> will deliver 42.986667, and
> =(LEFT(A1,2)+(MID(A1,4,2)+MID(A1,7,2)/60)/60)*((MID(A1,10,1)="E")*2-1)
> will deliver -0.086667.

I tried this formula, but get error 509 ("operator expected"). Maybe it's
because the cell contains "Numbers"?

https://postimg.cc/w764P7Rm   



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] [Draw] Colorize SVG?

[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 Potrace to turn the PNM into
SVG:

c:\Apps\ImageMagick\convert.exe logo.png logo.pnm
c:\Apps\potrace\potrace.exe -s -o logo.svg logo.pnm

Problem is, when importing the SVG in Draw, it's black and white, while the
original was orange.

What would you recommend I do to either keep the original color when
converting, and re-colorize the SVG for use in Draw?

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? 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] Re: [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

[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: 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] Re: [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

[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? 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] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 Text, like the
source column.

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? 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] [Calc] Good way to turn hours+minutes into minutes?

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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
Formatting"). If the document contains a ToC, do not select it, as it will
prevent LO from performing that action.

https://postimg.cc/9rVLbVh4



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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? 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] Re: [6.4.2.2] List footnotes in Writer?

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 (that's Format > Clear Direct Formating,
CTRL+M).

Is there a way to turn all paragraphs from Default Style to Text Body in one
go?  Having to do this for all paragraphs over 200 pages doesn't sound like
fun.



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 underlying 
> Text Body style is set accordingly, thus every paragraph with this style 
> is immediately updated.

Thanks but I still don't get it:
1. Selected paragraph set as "Default Style" in Arial Unicode MS 11
2. Styles > Edit Styles
3 . Changed to Liberation Serif 11
4. Hit "Apply": The other paragraphs set as "Default Style" aren't updated
(ie. still in Arial Unicode MS 11)
5. Hit OK
6. Styles > Update Selected Style: No change.

https://postimg.cc/fSYJMKx8

Regardless, is there a way to have LO Writer change all paragraphs set in
"Default Style" to "Text Body"? That's my main issue at this point.



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 all Default Text paragraphs, but nothing
happens.



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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...

Thanks. 

I did copy/paste text from elsewhere (OCR) but used the Pure Text utility
when importing to make sure I only got unformatted text.

However, at some point, I made the wrong decision to use Arial Unicode MS 11
instead of Liberation Serif 12 for paragraphs. It shows when reading the
EPUB on my e-reader (the font is bigger:  https://postimg.cc/4Y9hv6B3
  ).

On closer scrutinity, some paragraphs are Default Text while others are Text
Body: Is there a way to turn all "Default Style" to "Text Body"? This option
seems unavailable in the Find & Replace dialog.



--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: 
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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. 

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? 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] [newbie/Calc] How to mix relative/absolute cells in formula?

[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 cells downward?

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? 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] Re: [newbie/Calc] Why does SUM() not compute?

[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 first format the cell
> to a number format, then empty it and
> finally enter your formula again.

Makes sense. Thank you (and to someone off-band)!




--
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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 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] Libreoffice corrupted by Ubuntu failed upgrade

[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
>
> The only safe way to upgrade from one version of Ubuntu, to another, is
> to wipe the drive, and install the new version of Ubuntu.
>
> > Except Libre Office.
>
> Uninstall LibreOffice.
> Delete _all_ configuration files.
> /home/user_name/config/.libreoffice/*
>
> Delete _all_ files in /opt/libreoffice/*
> from /home/user_name/
> cd ..
> cd ..
> ls -alR | grep offic
>
> Delete all folders and files that have libreoffice as part of their name.
>
> Then download LibreOffice from
> https://www.libreoffice.org/download/download/
>
> Unpack and install LibreOffice.
>
> jonathon
>
> --
> 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
>

-- 
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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[Gilles Gravier]

 With SeaMonkey 2.49.4 on Ubuntu (installed from: https://www.linuxbabe.
com/ubuntu/how-to-install-seamonkey-on-ubuntu-16-04) but running on
18.04.1, it displays fine.


2018-08-08 18:21 GMT+02:00 James Knott :

> Sorry, I should have checked which list I was on.  I'm running OpenSUSE
> 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 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
>



-- 
*Gilles Gravier*  - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[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 testing and found it fails in Seamonkey, but works in
> Firefox & Chromium on 15.0.
>
>
> --
> 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
>



-- 
*Gilles Gravier*  - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[Gilles Gravier]

For me it works fine with Chromium and Firefox... on Windows and on
Ubuntu 18.04.1.


On 08/08/2018 17:37, M Henri Day wrote:
> Den ons 8 aug. 2018 kl 17:22 skrev James Knott :
>
>> I see the same thing.
>>
>> On 08/08/2018 11:13 AM, Paul D. Mirowsky wrote:
>>> FYI
>>>
>>> 11:08 AM EST
>>>
>>> YouTube video is not displaying.
>>>
>>> Results in message "If playback doesn't begin shortly, try restarting
>>> your device" in Firefox.
>>>
>>> Interestingly enough, if you move your cursor over the time line, it
>>> display image from video.
>>>
>>> Hope this helps.
>>>
>>>
>>> On 8/8/2018 7:44 AM, Tom Davies wrote:
>>>> Hi :)
>>>> Mike Saunders and the rest of the marketing team (and translators) have
>>>> made a video showing the new features in LibreOffice 6.1.0.
>>>>
>>>> https://www.youtube.com/watch?v=JvoCpnwGNFU
>>>>
>>>> I think some of the new features are things that have been asked about
>>>> quite recently- and might mean we have better answers for those
>>>> questions
>>>> now.
>>>>
>>>> Be wary though !!  This is the .0 release and it's only just been
>>>> releasedtoday so this is THE point at which the most unexpected and
>>>> unlikely breakages of functionality may occur !  It is also the BEST
>>>> time
>>>> to try out he new version AWAY from your regular install preferably on a
>>>> system you don't rely on for work or in a sandboxed area (Gnu has
>>>> MANY different ways of creating safe-areas to try things out in).
>>>>
>>>> It is THE time that the most devs are focusing on this new release so
>>>> it's
>>>> the best time to find bugs or features that have gone wonky and post
>>>> bug-reports about them.
>>>>
>>>> This is also a good time to join the QA Team to help them with
>>>> filing
>>>> tasks, and perhaps asking bug-reporters for relevant information that
>>>> might
>>>> help the devs handle their request and generally help with first
>>>> responses.
>>>>
>>>> Good luck and regards from
>>>> a Tom :)
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, 8 Aug 2018 at 11:13, Mike Saunders <
>>>> mike.saund...@documentfoundation.org> wrote:
>>>>
>>>>> On 07/08/2018 16:01, Mike Saunders wrote:
>>>>>> 2) There is a new video for LibreOffice 6.1; I'll provide the updated
>>>>>> URL tomorrow just before launch.
>>>>> Here it is:
>>>>>
>>>>> https://www.youtube.com/watch?v=JvoCpnwGNFU
>>>>>
>>>>> Mike
>
> Clicking Mike's link above runs the YouTube video without any problem on
> Firefox on my 64-bit Linux Mint 19 installation
>
> Henri
>

-- 
Signature Home Pro
Gilles Gravier- gil...@gravier.org <mailto:gil...@gravier.org>
GSM : +33618347147  and +41794728437

Skype : ggravier | PGP Key: 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>


-- 
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] Re: Best practices when working with LibreOffice Impress?

[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 accomplish here.

Thanks.

The goal is to merge the work of different presentators at a conference
somehow, so that people can then read the whole thing on the web 1) in one
go (with some kind of bookmarks or separators between each presentation) and
2) as HTML+JPG so they don't have to bother with PDFs.

I assume LO supports templates: Maybe I could build one, and ask all
presentators to use that template and LO so that we end up with a common,
homogenous material that I can merge and turn into HTML+JPG.



--
Sent from: http://nabble.documentfoundation.org/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: 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

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

[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 easier/better to merge and convert LibreOffice files
directly into HTML instead of going through PDF? If that's the case, what
tool would you recommend (Windows or Linux)?

2. If going through PDF doesn't matter, what tool + settings do you
recommend to a) convert the files into PDF (if LO isn't good enough) and
merge them all into a single PDF?

So far, I've used LibreOffice to export files as PDF, and PDFSam to merge
PDF files into one. I've never used GhostView (gv) to convert to PDF.

Thank you.



--
Sent from: http://nabble.documentfoundation.org/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: 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] LibreOffice - patches

[Gilles Gravier]

Liz,

2018-03-22 5:51 GMT+08:00 Miss Lizzy <lizbeth...@gmail.com>:

> I'm about to get a new laptop as my current one is not in compliance with
> the new General Data Protection Regulations (it's just over 10years old
> with Windows 7 so no longer supported by Microsoft regarding patches).
>
> It has been suggested I use LibreOffice rather than Microsoft Word, Excel
> etc.
>
> I've read a few articles on Libre, but what I would like to know is - you
> say Libre is an 'open
> Source software', and input/ patches is by anyone, that's the way I've
> digested it. So my concern is, do you actually mean 'anyone' or are the
> patches development by your own team of software developers?  You can
> obviously see where I'm going with this.
>
> I also noticed the software package name has changed over a relatively
> short period of time. Is it just in name or do folk have to keep down
> loading new packages?
>
> Would appreciate your comments as soon as you can please.
>
>
A (good) open source project is managed the same way as a good proprietary
software. In the sense that when new code is written, it gets reviews
according to predefined project governance, and then accepted or rejected.
That's the difference (in the open source world) between the contributors
(people who write code, patches, or even documentations, or participate in
driving community activities...) and the committers, who are the people who
can accept new contributions into the code base.

So when somebody writes a patch for a bug (you can, too, if you want, and
have the skills) and contributes it, it gets fully reviewed and (possibly)
approved and committed.

This happens for patches correcting issues, as well as all new code
bringing new functionality. This ensures that the project also keeps on
track with what the project strategy team is looking for.

Does it mean that no bugs get missed? No, of course. But that's the same as
for any software project. What it means is that there is the same type of
quality control mechanisms as for proprietary projects... but many many
more eyes looking at the code for bugs. So in average (COVERITY 2014
report) open source code tends to actually be higher quality than
proprietary with a density of 0.61 bugs per thousand lines of code for open
source versus 0.76 for proprietary (page 6 of the 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 great software LibreOffice from The Documentation Foundation !

Gilles
-- 
*Gilles Gravier*  - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] getting LO source

[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 playing
> videos, I thought I'd take a look at the source for myself. Possibly a
> hopeless task, but anyway...
>
> I fell at the first :-{ and couldn't even download the source. Not a
> promising start!
>
> The page at
> https://wiki.documentfoundation.org/Development/BuildingOnLinux
> recommends using git, so I tried the suggested
>
> git clone git://anongit.freedesktop.org/libreoffice/core libreoffice
>
> only to be told
>
> "Cloning into libreoffice'...
> fatal: remote error: access denied or repository not exported:
> /libreoffice/core"
>
> (I also tried git clone -n  with the same result. I suspect the
> web page should show the -n ???)
>
> Help please?
>
>

-- 
Signature Home Pro
Gilles Gravier- gil...@gravier.org <mailto:gil...@gravier.org>
GSM : +33618347147  and +41794728437

Skype : ggravier | PGP Key: 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>


-- 
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

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

[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: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553p4220693.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Simple way to draw graphs ?

[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 and then place the
> value of your choice.

Thanks, I don't know where to click: "Select the axis" → In the data in the
grid? Somewhere In the Wizard? On the graph in the grid?

https://s3.postimg.org/jgyvun80j/Libre_Office.calc.empty.x.y.chart.how.to.change.y.png





--
View this message in context: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553p4220689.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Simple way to draw graphs ?

[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: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553p4220680.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Simple way to draw graphs ?

[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 to guess the
original maths.



--
View this message in context: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553p4220676.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Simple way to draw graphs ?

[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.
> 
> Generate the chart in Calc. Uncheck the option to use "Source Format" in
> the Numbers tab of the axis properties dialog. That makes it easier to
> copy the chart to Writer.

Thank you.




--
View this message in context: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553p4220609.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Simple way to draw graphs ?

[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: 
http://nabble.documentfoundation.org/Simple-way-to-draw-graphs-tp4220553.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Can LO build a TOC from a PDF file?

[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 mailing list archive at Nabble.com.

-- 
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] Can LO build a TOC from a PDF file?

[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: 
http://nabble.documentfoundation.org/Can-LO-build-a-TOC-from-a-PDF-file-tp4217910.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [Win 5.1.6.2] Writer fails reading Win1252-encoded HTML document

[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 I could try when opening the file, or afterwards?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Win-5-1-6-2-Writer-fails-reading-Win1252-encoded-HTML-document-tp4205399.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] need help off this list - need Linux package choice help

[Gilles Gravier]

So... for version 2.0, you need the PPA (version 1.4 is in the default
repositories).

And... 16.10 isn't yet in the PPA.

And the command isn't apt-get-repository but add-apt-repository ... :)

Appart from that the idea is great.


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 about previous ubuntu systems, but am
> pretty sure will run on 14.04 plus).
>
> The program is a Kickstarter success.
>
> OpenShot Video Editor is a free, open-source video editor for Linux
> licensed under the GPL version 3.0.
> http://www.opnshot.org
>
> sudo apt-get-repository ppa:openshot.developers/ppa
> sudo apt-get update
> sudo apt-get install openshot-qt
>
>
>
>
> Tony Bray
> tony...@mac.com
> MacBook Pro 15 inch Mid 2009
> 2.8 GHz Intel Core 2 Duo, 4 GB RAM,
> Mac OS X  10.11.3
> LibreOffice 4.4.5
> Scribus 1.4.4
> Libre Project 1.5.19
> Parallels Desktop 11.02
> Ubuntu 16.04
> LibreOffice 4.4.4
>
>
>
>
>
>
>
> --
> 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
>
>


-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] need help off this list - need Linux package choice help

[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 about previous ubuntu systems, but am
> pretty sure will run on 14.04 plus).
>
> The program is a Kickstarter success.
>
> OpenShot Video Editor is a free, open-source video editor for Linux
> licensed under the GPL version 3.0.
> http://www.opnshot.org
>
> sudo apt-get-repository ppa:openshot.developers/ppa
> sudo apt-get update
> sudo apt-get install openshot-qt
>
>
>
>
> Tony Bray
> tony...@mac.com
> MacBook Pro 15 inch Mid 2009
> 2.8 GHz Intel Core 2 Duo, 4 GB RAM,
> Mac OS X  10.11.3
> LibreOffice 4.4.5
> Scribus 1.4.4
> Libre Project 1.5.19
> Parallels Desktop 11.02
> Ubuntu 16.04
> LibreOffice 4.4.4
>
>
>
>
>
>
>
> --
> 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
>
>


-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] Windows 10 Anniversary Update found LibreOffice as malware

[Gilles Gravier]

Or switch to a real antivirus. :)

On Thu, Oct 20, 2016 at 4:59 PM, RODRIGUEZ FONSECA JORGE ALBERTO <
jrodrigue...@cpcecr.com> wrote:

> Hi:
>
> I suggest you to unable window defender (I don't think it is a bug). Then
> download LibreOffice, install it and then activate again wd.
>
> Regards,
>
> Jorge Rodriguez
>
> - Original Message -
> From: "dam4rus" <rfrostkal...@gmail.com>
> To: users@global.libreoffice.org
> Sent: Thursday, October 20, 2016 1:44:03 AM
> Subject: [libreoffice-users] Windows 10 Anniversary Update found
> LibreOffice as malware
>
> So, i have Windows 10 with Anniversary Update and today Windows Defender
> quarantined soffice.bin, because it thinks it's a Trojan. Is this a known
> issue? Should i report it as a bug? I haven't found anything about this
> with
> google search.
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> Windows-10-Anniversary-Update-found-LibreOffice-as-malware-tp4197678.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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
>
>
> --
> 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
>



-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] Goodbye to Open Office (maybe?)

[Gilles Gravier]

Hello!


On 03/09/2016 15:01, Xen wrote:
> CVAlkan schreef op 03-09-2016 13:50:
>> For those who haven't seen this:
>> http://arstechnica.com/information-technology/2016/09/openoffice-after-years-of-neglect-could-shut-down/
>>
>> Is this a case of "Where there's smoke ..."
>
> The LibreOffice developers that split off refused to contribute code
> under the "Oracle" license and according to the words of Mark
> Shuttlworth "made their work hell". (Made the work hell of the
> remaining paid Oracle employees).
>
> Since also LibreOffice was allowed to take code from ApacheOffice but
> not in reverse (due to it restrictive license) (LibreOffice had a
> license that forbade it from being given back to Apache/Oracle
> OpenOffice) any updates only flowed in one way and provided the doom
> for OpenOffice.
>

The LibreOffice software is published under the Mozilla Public License
Version 2.0... Not a particularly restrictive license.
LO License : https://www.libreoffice.org/about-us/licenses/
MPL 2.0 : https://www.mozilla.org/en-US/MPL/2.0/

In fact it's a great license to enable combining with other software.

Now, when Oracle (I used to work there) gave the OOo code to Apache,
they were really hoping to kill LO. But to their big surprise (and
contrary to all the bullshit I was given by the (at the time) head of
software strategy there), LO dit way better than OOo. OOo suffers from
many problems, from structural (Apache has taken an unreasonable amount
of time to clean up all the code - in particular licenses - but not the
actual algorithmics of the app) to project-wise (developers not adhering
to the idea, not committed to contributing enough, and as a result, new
versions comming out drop by drop, one  every year and a half - when LO
has new versions every few months or more often).

So the good guys here are LO. They're doing great work. They're keeping
alive software that Oracle did its best to "not kill" (it was a
commitment from Oracle to the European Commission when they acquired
Sun)... while still doing its best to make it disappear (they are really
upset that they never found a way to make money from it, and that they
never could control the community the way thew would have wanted to -
case in point, The Document Foundation is the exact opposite of what
Oracle wanted to achieve - including limiting sponsorship amounts so
that no single entity can claim to have overwhelming financial impact to
justify imposing directions to the project).

It would be a good thing FOR EVERYBODY if Apache decided to officially
call it quits on OOo, and put out one last version that had links for
next updates to the LibreOffice web site. Of course they have too much
pride to even accept the idea of doing this, so instead, they are
leaving their users with software that is terribly outdated (last build
4.1.2 is dated October 28th, 2015, and I'll let you imagine the 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.
https://www.avast.com/antivirus


-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[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ées, Kind Regards,
>
> DRIES FEYS
> CORPORATE SERVICES • Specialist Software Developer
>
> TVH GROUP NV
> Brabantstraat 15 • BE-8790 WAREGEM
> T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
> Watch our company movies on www.tvh.tv
>
>
>
> Business Innovation
> through
> Information Technology
> bi2t.tvh.com
>
>
> On 10 March 2016 at 14:19, Gilles Gravier <gil...@gravier.org> wrote:
>> Hi!
>> (resent now that I have subscribed)
>>
>> Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example
>> LibreOffice Write. It opens. I click on File->Exit LibreOffice ...
>> NOTHING HAPPENS.
>>
>> If I click on the red cross top right corner of the window, it properly
>> closes it.
>> If I use the "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.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
>
> --
>
>
>  DISCLAIMER 
>
> http://www.tvh.com/glob/en/email-disclaimer
>
> "This message is delivered to all addressees subject to the conditions
> set forth in the attached disclaimer, which is an integral part of this
> message."



-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026

-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Gilles Gravier]

Hi!

Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example LibreOffice
Write. It opens. I click on File->Exit LibreOffice ... NOTHING HAPPENS.

If I click on the red cross top right corner of the window, it properly
closes it.
If I use the "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?

-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026
<http://pgp.mit.edu:11371/pks/lookup?search=0x8DE6D026=index>

-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Gilles Gravier]

Hi!
(resent now that I have subscribed)

Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example
LibreOffice Write. It opens. I click on File->Exit LibreOffice ...
NOTHING HAPPENS.

If I click on the red cross top right corner of the window, it properly
closes it.
If I use the "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.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] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

[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: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-play-an-animated-slide-tp4160509p4160577.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

[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: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-export-a-single-file-from-a-PPT-file-tp4160501p4160576.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

[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
right-clicking on the slide, all to no avail.

Google didn't help either.

Is there really no way to export just a single slide?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-export-a-single-file-from-a-PPT-file-tp4160501.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [LibreOffice 5.0.1.2] How to play an animated slide?

[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 I found no item in the menu that offered a way to split an animated
slide into its different steps.

Is there a way, at least, to see the different steps on an animated slide?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-play-an-animated-slide-tp4160509.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

[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: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-export-a-single-file-from-a-PPT-file-tp4160501p4160510.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

[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 final output.



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-play-an-animated-slide-tp4160509p4160521.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [LibreOffice 5.0.1.2] How to play an animated slide?

[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 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] Re: [LibreOffice 5.0.1.2] How to export a single file from a PPT file?

[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: 
http://nabble.documentfoundation.org/LibreOffice-5-0-1-2-How-to-export-a-single-file-from-a-PPT-file-tp4160501p4160519.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [Calc] Automate creation of series of full date (ie. Day name, Date)?

[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 context: 
http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

[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: 
http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586p4154589.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

[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: 
http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586p4154591.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?

[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: 
http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586p4154593.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Base] Ready-to-use solutions to manage membership + inventory?

[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 Users mailing list archive at Nabble.com.

-- 
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] Re: [Base] Ready-to-use solutions to manage membership + inventory?

[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: 
http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774p4148786.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Base] Ready-to-use solutions to manage membership + inventory?

[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 mailing list archive at Nabble.com.

-- 
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] [Base] Ready-to-use solutions to manage membership + inventory?

[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: 
http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [Base] Ready-to-use solutions to manage membership + inventory?

[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: 
http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774p4148797.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Export all slides from a PowerPoint document?

[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 a single slide, or all the /images /or all the /text/.

In LibreOffice Impress, File  Export only exports the /current slide/.

Is there an easy way to export /all the slides/ in one go?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Export-all-slides-from-a-PowerPoint-document-tp4134267.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Export all slides from a PowerPoint document?

[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
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [PDF] Export all pages as PNG in one go?

[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 Export, and get the pages as independant
files as eg. Page1.png, Page2.png, etc.

Acrobat Professional can do this:
www.wikihow.com/Extract-Pages-from-a-PDF-Document-to-Create-a-New-PDF-Document

Is there a work-around in Draw?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/PDF-Export-all-pages-as-PNG-in-one-go-tp4110454.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [PDF] Export all pages as PNG in one go?

[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 from the Users mailing list archive at Nabble.com.

-- 
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] Re: Turning spreadsheet data into legible report?

[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 more than one year, so they'll end up having
more than one document in their name :-/

I guess it's an illustration that using a spreasheet as poorman's database
only works for basic, one-dimensional needs.



--
View this message in context: 
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102293.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Turning spreadsheet data into legible report?

[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
Trimester1-2013 is empty, don't display list).

Thanks all.



--
View this message in context: 
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102306.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Turning spreadsheet data into legible report?

[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 programming, it
only supports reading data from a single sheet, while data is kept in
multiple sheets (one by year). Here's a screenshot of a mock document I
re-created in LO:
http://postimg.org/image/v2au21zsh/

Unless someone knows of a good, programming-free, Excel-based solution, it
looks like the right way to solve this problem is to stop using Excel as
poor man's database, and write a real database application with tables,
relations, input forms and report output... but she obviously doesn't have
the skills, doesn't have internal resources available for help, and I can't
spend time on this.

I know it's akward to ask this in an LO mailing-list, but can someone
experimented confirm that there's no MS Office-based solution (either
internal or third-party), and that moving to LibreOffice Base is the way to
go?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Turning spreadsheet data into legible report?

[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

Year 2012-2013
Trimester 1
Col1 | Col2 | Col3
Trimester 2
Col1 | Col2 | Col3
...
Year 2013-2014
Trimester 1
Col1 | Col2 | Col3
Trimester 2
Col1 | Col2 | Col3
=

So she needs some way to turn the spreadsheet into the above *while keeping
data in different tabs* (one per year) since the list of students is
different every year.

Ideally, it should be doable with a spreadhseet (Excel or Calc) and some
programming-free tool, but Word can't handle more than one tab in a
spreadsheet. Like I said, she can't work with a database.

Incidently, this problem is very common since a lot of users rely on Excel
as poorman's database. I wonder how they all manage once they hit this type
of issue.

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102153.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: Turning spreadsheet data into legible report?

[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 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] Re: [4.0/Win] Edit form?

[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 sent in
 to ourselves.

No comment.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-Win-Edit-form-tp4069229p4069335.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [4.0/Win] Edit form?

[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 of their web developer
to write an HTML form to handle this is beyond me... but it's consistent
with the rest of the issues I had with them. Last time I order from them.

Anyhow, thanks for the help.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-Win-Edit-form-tp4069229p4069339.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] [4.0/Win] Edit form?

[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: 
http://nabble.documentfoundation.org/4-0-Win-Edit-form-tp4069229.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [4.0/Win] Edit form?

[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 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] Edit PDF to keep just one section?

[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.

Does someone know if LibreOffice supports this type of feature?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/Edit-PDF-to-keep-just-one-section-tp4057601.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 way to tell LO to use a given font size when creating labels?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044741.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044762.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.0.3/Windows/Write] How to resume single-column?

[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 archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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:

http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.params.jpg
http://bagofiles.free.fr/libreoffice.labels/libreoffice.labels.output.jpg

Before I ditch the pack and find some labels that have no pitch/margins, has
someone successfully printed labels with LO that look like that?

Thank  you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 and height?

Otherwise, it's going to take forever to get it right.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044529.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 and
Width/Height to the label's size, but LO won't let me (sets HZ/VT Pitch to
0,10cm).

Before I spend more time on this, does someone know if LO is able to handle
sheets that look like the one I bought, namely those that have outer borders
but none between the labels proper?



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044532.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044536.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044558.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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 context: 
http://nabble.documentfoundation.org/4-0-1-2-Win-Writer-Printing-labels-with-odd-sheets-tp4044517p4044625.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.1.2/Win/Writer] Printing labels with odd sheets?

[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
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] [4.0.0.3/Windows/Write] How to resume single-column?

[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 is stuck
with two columns.

Any idea?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-0-3-Windows-Write-How-to-resume-single-column-tp4044138.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0.0.3/Windows/Write] How to resume single-column?

[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: 
http://nabble.documentfoundation.org/4-0-0-3-Windows-Write-How-to-resume-single-column-tp4044138p4044146.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] [4.0/Win/Writer] Fold/unfold sections?

[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++
http://screenshots.en.sftcdn.net/en/scrn/31000/31829/notepad-21.jpg  .

Can Writer be made to fold/unfold sections, eg. fold all Heading2 sections?

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-Win-Writer-Fold-unfold-sections-tp4039442.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Re: [4.0/Win/Writer] Fold/unfold sections?

[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 what writers use to write long documents. Maybe some word processor
in Mac does this.

Thank you.



--
View this message in context: 
http://nabble.documentfoundation.org/4-0-Win-Writer-Fold-unfold-sections-tp4039442p4039494.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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