Re: [libreoffice-users] Compress images

[Cley Faye]

>
> The odt file is a compressed zip archive. Compressing the contained
> pictures would hardly reduce the file size.


That's not true. The point was (if I remember this thread correctly) that
when designing the document, you have high-definition pictures, say
1200dpi, and those takes a lot of space. Now, if you want to output this
for a projector you'll only need pictures at 90dpi, or for printing with a
medium quality you only need 150dpi, and doing a poster you'll need the
whole 1200dpi.


Sending the same file with the original 1200dpi pictures to everyone sure
is a solution, but you'll see the waste of space. It doesn't have anything
to do with odt file being compressed; there's juste *more* informations
with bigger images. Other (impractical) solutions could be to maintain
multiple version of the same file, or keep the images linked to multiple
folder, and swap them outside of LibreOffice. Not good when you manipulate
large documents.

Now, what would be nice is a way to take an odt with such large pictures,
and produce different versions suited for different needs. You keep the
"original", and with the press of a button, produce a separate odt file
where the pictures are scaled down appropriately (like the option in PDF
export). From the discussion, it looks like MS Word have something like
this, and while mimicking Word is not a necessity, I clearly see the need
for such an option for LibreOffice power users.

2014-11-02 22:36 GMT+01:00 Tom Davies :

> Cley seems to have created something like an Extension or maybe
> independent program to automatically re-scale the byte-size of all images
> in a document and i'd forgotten all about it.


​It was (is? I probably left it online) a separate tool. You could feed it
an ODT, and produce a (hopefully) smaller ODT where all pictures are scaled
to a given dpi.
It was only a proof of concept: I didn't read the whole ODT spec or
something. It works by looking in the XML for pictures links, and retrieve
their "printing" size (in centimeters). It then scale down all linked
images in the ODT archive, so that their size in pixels exactly meet their
printing size for the specified DPI.

For example, if you have a document with a picture set to 10x10cm, and the
picture source is 4700x4700 pixels, the image is roughly at 1200dpi. When
modified for printing at 150dpi, the picture would be scaled back to
590x590 pixels, drastically reducing the file size while keeping the
expected output quality.

(this also depend on scaling methods and other things, but it was the
general idea).

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: rtf files

[Cley Faye]

2014-11-19 16:58 GMT+01:00 Virgil Arrington :

> That's one of the things I've always liked about RTF. In a pinch, one
> could open an RTF file in Notepad and strip out all of the RTF coding and
> be left with a document's contents. I've never had to do it, but it's nice
> that it can be done. With a binary file, you're left with smiley faces and
> no visible content.


​Now, add a picture to your rtf file and see how fun it is to have all
things in a "plaintext", notepad friendly​ file format...

More recent format like odt (and docx for that matter) are *WAY* better.
(is there a way to emphasis this more?). They are in fact a collection of
files in a simple ZIP, but the core of it (the text and structure) is in a
straightforward XML file which is as "plaintext" as an RTF file. In fact,
it's easier to strip the extra tags out of an XML file, since tools to
manipulate/reformat XML are extremely common.

With recent format, you get the possibility, should an issue arise, to
​extract the plaintext content, and even the attached files (pictures and
other embedded OLE stuff) with common tools. This is even demonstrated on
this list, when sometime someone get a corrupted file, and it is possible
to recover it with stuff like notepad and windows' zip file explorer.

There's no comparison between these format, heavily documented in case of
ODT, that put a clear separation between content and format, and an RTF
file that want to cram everything (content, format, and binary blobs for
image) in a single "plaintext" file.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: rtf files

[Cley Faye]

Huhu. Someone needs to write an extension that save odt files as
base64-encoded. Tadaa, full plaintext files ;)

I'm joking of course. But although rtf is "technically" plaintext, in
practice it's not always straightforward to read with notepad, even when
the text isn't mangled away in some way. The only advantage I can see is
that it's easier to generate a "simple" RTF file from any program than to
generate an odt. Beyond that, the actual content of an RTF file is at best
as useful as the content of the content.xml file in an odt. Slightly more
even, as tools to manipulate xml are more common.

-- 
Cley Faye
http://cleyfaye.net

2014-11-19 19:25 GMT+01:00 Tom Davies :

> Hi :)
> Ahh, right.  Now i'm kinda regretting using 4-6 random letters but not
> enough to repeat the experiment.  I suspect my adfs (or whatever) is
> probably something like
>
> E0\85\9F\F2\F9Oh \AB\91
>
> Regards from
> Tom :)
>
>
> On 19 November 2014 17:40, Andreas Säger  wrote:
>
> > Am 19.11.2014 um 17:33 schrieb Tom Davies:
> > > I'm really not getting plain text.  When i right-click and open in a
> > > text-editor i get this sort of thing;
> >
> > Which is plain text in plain 7 bit ASCII. I can paste your rtf into any
> > plain text editor, save as tom.rtf and open tom.rtf with any rtf capable
> > word processor. Now I save this in binary .doc, open the doc in a text
> > editor and what I see is this:
> >
> > > \D0\CF ࡱ \E1\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00;\00
> > \00\FE\FF\00 \00\00\00\00\00\00\00\00\00\00\00 \00\00\00
> > \00\00\00\00\00\00\00\00 \00\00 \00\00\00
> >
> \00\00\00\FE\FF\FF\FF\00\00\00\00\00\00\00\00\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\F
> >
> F\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FD\FF\FF\FF\FF\FF\FF\FF\FE\FF\FF\FF
> > \00\00\00 \00\00\00 \00\00\00 \00\00\00 \00\00\00   \00\00\00
> > > \00\00\00 \00\00\00 \00\00\00 \00\00\00 \00\00\00\FE\FF\FF\FF
> >
> \00\00\00\FE\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\F
> >
> F\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FFR\00o\00o\00t\00
> >
> \00E\00n\00t\00r\00y\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00
> > \00
> >
> \00\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\FF\00\00\00\00\00\00\00\00\00\00\00\00\00\00\

Re: [libreoffice-users] Re: rtf files

[Cley Faye]

2014-11-20 6:02 GMT+01:00 Urmas :

> "Cley Faye":
>
>  is in a straightforward XML file which is as "plaintext" as an RTF file.
>> In fact,
>> it's easier to strip the extra tags out of an XML file
>>
>
> Sure. Now tell us what 
> {urn:oasis:names:tc:opendocument:xmlns:office:1.0}binary-data
> element is for, and what kind of 'plaintext' it does contain.
>
>  heavily documented in case of
>> ODT, that put a clear separation between content and format
>>
>
> Really? And where, for example, this element is 'documented'?
> {urn:oasis:names:tc:opendocument:xmlns:style:1.0}num-format
>

​There:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1415854_253892949
and there:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1417966_253892949
​

Also, from the *name* that you so easily got out of the file, anyone can
tell that binary-data will, indeed, hold a binary data (and the properties
you omitted, as well as the position in the file will indicate the nature
of it). Same logic with num-format. Only someone seriously thickheaded
would go saying "geez, I wonder what style:num-format can be".

Your turn now, where is
"\cf0\kerning1\dbch\af6\langfe2052\dbch\af7\afs24\alang1081\loch\f4\fs24\lang1036"
documented? And do you really find this easier to understand than tags like
"num-format" and "style:name"?

You can ignore the fact that RTF was changed on numerous occasion in
non-retrocompatible ways, and ignore the fact that some features of RTF
are, to this day, not officially documented by MS, and also ignore the fact
that accross several MS tools (namely MS Word and Wordpad) you get
completely different results for the same file, and still ignore when these
are pointed out, but it won't magically make it true.

A RTF file is less "human-readable" than the content.xml file in an ODT (or
a docx for that matter).

-- 
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] Lost Pass Word

[Cley Faye]

2014-11-26 17:32 GMT+01:00 Tom Davies :

> I've only done it the other way around though.  An MS Office document
> opened in LibreOffice just by double-clicking it, and later i found the
> document had supposedly been password-protected (but not encrypted).
>

​It will only ever work this way, not the other.

For reference, old .doc where simply flagged as "password protected", which
of course got us OpenOffice/LibreOffice simply opening them without warning
;)

On the other hand, open password for .odt (and other open document formats)
always implied some form of encryption. Granted, previous versions might
have used what is now weak encryption, but still it is not something that
can be opened easily without password, especially if the file is
manipulated on a regular basis, as recent versions of LibreOffice might
simply have overwritten the old encryption with something more up to date.

I'm afraid that beside brute-force (using a dedicated program) or an
unencrypted backup there is no much hope.

-- 
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] Lost Pass Word

[Cley Faye]

2014-11-26 21:41 GMT+01:00 jonathon :

> The time required to brute force a solution can be reduced if:
> * The length of the password is known;
> * Part of the password is known;
> * Which glyphs the password uses are known;
>
> This issue comes up often enough, that I'm surprised I can't find an
> open source tool to brute force ODF passwords. It is a straightforward
> algorithm.
>
> Guess_password
> Throw_at_document
> If fails Guess_password
> If success read_document
>
> Guess_password is simply repeat until loops.
>

If you're motivated, here's a piece of code that attempt a very poor
bruteforce, but have all the pieces needed to make a real brute-force app.
(disclaimer: this is like the monster from frankenstein, I cut & pasted
code from all around the web, as I have zero knowledge about Java bindings
for UNO).
http://pastebin.com/cQJnA8F6

​It will try to open a file located at e:\test.odt, and use passwords from
"tota", "totb", "totc"... to "tott" (more or less). Still, it is probably
very easy to change it so that it use proper, parametrized passwords
guess​, and have some form of UI. If no one else look into this, I might
give it a go.

(for this stub to work, you need a running instance of libreoffice started
with the command line "$ soffice.exe -accept=socket,host=0,port=2002;urp;")
It is 100% possible to integrate this better, in a way that would
automatically launch an invisible instance of LibreOffice. In fact the
first SDK sample does this, but as I run a 64-bit version of Java, I had to
go this way. YMMV.


-- 
Cley Faye
http://cleyfaye.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Problem Installing/Updating LO

[Cley Faye]

LibreOffice Manager does not seem directly related to LibreOffice (or to
this mailing list). Maybe you'll have better chances of getting help about
it on a dedicated forum.

Now, if you want to install LibreOffice by hand, you can always grab an
archive containing all the application packages from
https://www.libreoffice.org/download/libreoffice-fresh/. This will most
likely result in a complete and working installation of LibreOffice on your
system.

-- 
Cley Faye
http://cleyfaye.net

2014-12-08 14:37 GMT+01:00 Ian Whitfield :

> *Hi All*
>
> Since I upgraded to LO 4.3.4 I have a problem with LO Manager!!
>
> Whenever I start it it shows the error -
>
> /Please close your package manager 'synaptic' //
> // and then run LibreOffice Manager again.//
> //
> // Exiting../.
>
> Synaptic is _*NOT*_ running - So am unable to update the package.
>
> * I  tried re-installing LO Manager - still get the error.
> * Then I 'Completely Removed' all LO files with Synaptic and re-installing
> LO with but still get the same error.
> * I then removed the hidden .config/libreoffice files and reinstalled the
> Manager but still get the same error.
>
> I'm now stuck with no LO on my system at all!!
>
> My system runs PClinuxOS (latest) 32-bit.
>
> Any suggestions please??
>
> IanW
> Pretoria RSA
>
> --
> 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

[libreoffice-users] ODT/ODS/ODP import in Google Drive

[Cley Faye]

Hi,

A good news for people working with Google Drive, it is now possible to
"properly" import open document in it:
https://plus.google.com/u/0/+GoogleDrive/posts/f8icit6jYJK

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

[Cley Faye]

And since some people do have difficulties to unsubscribe, consider this:
- You have to send the mail *from* the address you used to subscribe, even
if you redirect your mail afterward
- You have to send the mail *to* "users+unsubscr...@global.libreoffice.org",
the + part is important. Some (bad) client mangle it, or skip part of the
address when you click. In doubt, type it by hand, it's the only way to be
sure :)

Also note that it his possible to unsubscribe from the list and subscribe
to a "digest" version, that produce less mails and allow oneself to follow
some discussions.

-- 
Cley Faye
http://cleyfaye.net

2014-12-18 18:24 GMT+01:00 Tom Davies :
>
> Hi :)
> To unsubscribe e-mail to:
>
> users+unsubscr...@global.libreoffice.org
>
> Regards from
> Tom :)
>
>
> On 18 December 2014 at 16:57, juliejohn scott  >
> wrote:
> >
> > Please unsubscribe me now (if you can) because I have had my question
> > answered and my e-mails are becoming excessive.Happy Christmas,John
> Scott.
> >
> >
> > --
> > 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
>

-- 
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] Dot separated date in YYYY.MM.DD format

[Cley Faye]

I tried this, which seem to work: specifying the cell format with a custom
format .MM.DD. When I input a date in this form, it is kept this way,
and is recognized as a date (possible to use it in formula).

Is that not enough? Maybe I misunderstood the question.

-- 
Cley Faye
http://cleyfaye.net

2014-12-19 16:27 GMT+01:00 C. H. D. :

> Hello all,
> When I enter 2015.01.01, it is recognized not as a date. How do I make it
> one step only? I enter it and it is detected as a date.
>
> 01-01-2015 is recognized as a date. Then I need to format this. Two steps
> are required.
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
> --
> 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

Re: [libreoffice-users] PDF Extnension for Libre Office/Writer or Open Office

[Cley Faye]

A recent installation of LibreOffice is able to open almost any PDF through
the Draw module. From there, it is possible to redo the placement and
extract part of the file.

Note that it won't open in Writer (or other modules), and that opening a
PDF for editing is not a pixel-perfect process; there can be some issues
with the import (but if all you want is get a picture it's alright).

-- 
Cley Faye
http://cleyfaye.net

2014-12-27 19:36 GMT+01:00 charles meyer :

> Hi All,
>
> I hope everyone is enjoying Christmas and all the holidays.
>
> I was reading there is an extension you can download for Open Office
> which allows you to import a PDF file and then edit that PDF file.
>
> I have a form sent to me in pdf and I wish to import an image file
> into that pdf form.
>
> Does Libre Office have a similar PDF extension? Have you actually used
> it and not just read about it? Can you please share the official link
> to that extension?
>
> If Libre Office does not offer such a PDF extension, has anyone used
> the Open Office PDF extension in Libre Writer/Office?
>
> Thanks so much.
>
> Charles.
>
> --
> 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

Re: [libreoffice-users] Recommendations for an Android app?

[Cley Faye]

Short of something very new and kept secret by its dev, Andropenoffice is
the best way to go for now.

LibreOffice is (was?) working on an Android version that would be more than
a direct port, but it is not available yet as it it a tremendous task.
There's a wiki page about this:
https://wiki.documentfoundation.org/Development/LibreOffice_on_Android

-- 
Cley Faye
http://cleyfaye.net

2014-12-29 12:51 GMT+01:00 Gordon Burgess-Parker :

> Hi all,
> Has anyone got recommendations for an Android app for ODF?
> I've currently got Textmaker for ODT but their spreadsheet doesn't do ODS
> for some reason. Andropenoffice does all types but has adverts!
>
> Cheers
> Gordon
> --
> 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

Re: [libreoffice-users] PDF Extnension for Libre Office/Writer or Open Office

[Cley Faye]

​About removing blank pages, there are tools for that :)

The other things, anything involving elements position, is trying to fight
against the format and will always rely on black magic.​ Remember that
while word processing software sees paragraph, a PDF sees only symbols
placed on a page. Sometime these symbols are whole sentence, sometime
single letters with no relation to others beside behing relatively close to
each others.

-- 
Cley Faye
http://cleyfaye.net

2014-12-29 19:34 GMT+01:00 anne-ology :

>oops ... nuts ... ... ...  ;-)
>
>When I responded to his message, I was hoping there might now be a
> good program which would eliminate all the gobbledegook which happens
> through this method;
>will there ever be a program which will allow for editing these
> inane PDF files without messing up the original intent???
>one which would allow the simple deletion of those excessive blank
> pages ...
>the ability to fix the margins allowing for less wasted space
> ...
>   the ability to eliminate the extraneous lines which criss-cross
> throughout the document ... ... ...
>
>
>
> From: Jean-Baptiste Faure 
> Date: Sat, Dec 27, 2014 at 1:57 PM
> Subject: Re: [libreoffice-users] PDF Extnension for Libre Office/Writer or
> Open Office
> To: users@global.libreoffice.org
> Cc: reachmepl...@gmail.com
>
>
> Hi,
>
> Le 27/12/2014 19:36, charles meyer a écrit :
> > [...]
> > I was reading there is an extension you can download for Open Office
> > which allows you to import a PDF file and then edit that PDF file.
>
>
>
> This extension is part of the default installation of LibreOffice. You
> only have to try to open your pdf file from the File > open menu of
> LibreOffice to open the file in the Draw module
>
> Best regards.
> JBF
>
> --
> 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

Re: [libreoffice-users] Hey there I can't install LanguageTool 2.8 on LibreOffice

[Cley Faye]

I just checked with LibreOffice 4.3.5.2 and it works fine.

LanguageTool relies on Java7. What version of Java does LibreOffice use?
(this is visible in the options dialog)

-- 
Cley Faye
http://cleyfaye.net

2015-01-07 4:45 GMT+01:00 Gabriel Paulo :

> Hey there I can't install LanguageTool 2.8 on LibreOffice with French
> Menus and Dictionaries.
>
> Here is the version of LibreOffice I'm using:
> Version: 4.2.7.2
> Build ID: 420m0(Build:2)
>
> I'm using this software on on Ubuntu 14.04 LTS:
>
>
> --
> 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

Re: [libreoffice-users] What is the current best ODF editing Android Package?

[Cley Faye]

2015-01-13 10:04 GMT+01:00 Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> So any help with choosing the best ODF editing package, would be nice.


​I'm affraid the situation on the Android front is moving slowly. Really
slowly. And AndrOpen Office​ is your best (and almost only) solution. It
works offline, as it is basically the whole open office app, but your
mileage may vary. Some people have good results with it, others can't get
it to run at all.

The status of Android development and LibreOffice is explained here:
https://wiki.documentfoundation.org/Development/LibreOffice_on_Android but
"it's not there yet". Help wanted, you might say.

Note that for some "dirty" work, Google Doc now support importing and
exporting opendocument files, so it might be worth a shot.

-- 
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] Spurious derby.log file in $HOME created by LO

[Cley Faye]

Or, maybe a less radical solution, you could notify the developer of this
extension about this behavior. This issue might have gone completely
unnoticed, seeing the mess some dev harbor in their home directory. It
might be helpful for other users too.

Of course if the dev answer something like "wontfix" then...

-- 
Cley Faye
http://cleyfaye.net

2015-01-13 11:00 GMT+01:00 Tom Davies :

> Hi :)
> Is it really worth keeping the Extenion/Add-on?  I'd be really tempted
> to uninstall it and find some other way to do whatever it does.
> Regards from
> Tom :)
>
>
> On 13 January 2015 at 09:17, Malte Starostik 
> wrote:
> > Hello Dries,
> >
> > thanks for the pointer.  In fact German Post's online stamping extension
> is
> > causing it.  Not being a Java guy I'll now have to try and distill the
> below
> > link (that I found before but didn't see how to make use of it) into
> some way
> > to set the log file path for that extension - if there is such a way
> without
> > access to the source.
> >
> > Kind regards,
> > Malte
> >
> > Am Freitag, 9. Januar 2015, 12:53:29 schrieb Dries Feys:
> >> Hello Malte,
> >>
> >> It's probably because you use some Java-component in LO.
> >>
> >> I found the following discussion which will be very helpfull for you.
> >>
> >> http://stackoverflow.com/questions/1004327/getting-rid-of-derby-log
> >>
> >> 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
> >>
> >> On 9 January 2015 at 11:46, Malte Starostik 
> wrote:
> >> > Hi,
> >> >
> >> > for some time, whenever I used LibreOffice, I'm left with an empty but
> >> > annoying file called "derby.log" in my home directory.  As I never
> told LO
> >> > to create this - to me - useless file, I obviously don't want it
> >> > polluting my $HOME, especially as it very rudely gets in the way of
> tab
> >> > completion to "devel" ;-)
> >
> >
> > --
> > 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
>

-- 
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] What is the current best ODF editing Android Package?

[Cley Faye]

2015-01-14 16:09 GMT+01:00 Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> I am "worried" that MS Office now has apps for their Office packages that
> runs on Android 4.4 [and better].  I do not want to see LO and AOO loose
> out of the mobile market.
>

​From the (quick) glimpse I just had about Office on Android, I wouldn't
say that they are better or worse​. It *will* open your document, but say
goodbye to almost all of your formatting; even text size is inconsistent
with the original. Images are nowhere to be found, no pagination, no
header/footer... and that's for the "viewing" functionnality. When hitting
the "edit" button, I get a message saying that it can NOT edit .doc files.
Opening a .docx got me a "sorry, this file can not be opened, it might be
damaged" (this same file works on the desktop version).
And it could not open a file with a dash in its name, be it on the device,
or from either dropbox and onedrive.

Just to be complete on this short, somewhat negative review, I did create a
new docx from the app. There's not much more, still no pictures, and no
style support at all.

From this short experience, you're better of loading Andropenoffice, at
least the document sort of looks like what you expect. I'll admit such a
quick test is not enough to get all the possibilities of the application,
but from it I'm not too "worried" about their presence on Android.


> I do not know if I want to deal with Google Docs either.
>

​Are you sure about that? From what I've read about open document suite on
Android, and from what I got when trying the msoffice stuff​, it sound way
more reliable and you get roughly the same editing capabilities than
msoffice.



> What I really want is a package that does not need to be connected to "the
> cloud" to use.  Most places I would be using the tablet will not have any
> "guest" access for me to use.  I want to be able to modify my documents -
> Word or Calc - at meetings or while I am waiting for appointments.  That
> way, I can show the modifications then and there for "approval".
>

​All the options (Andropenoffice, MSOffice, and Google Docs) can manage
offline documents. For GDocs you have some planning to do (mark some files
as available offline), but it's also a possibility.

Just to be clear, I'm not saying that one product is better than another;
it's more that none of them is complete as it is today. For now you'll have
to cut on your expectations if you want to edit "real" documents on a pure
Android tablet. I made all three options choke at various level with a
.docx containing a single sentence and a picture :(

-- 
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] Backups?

[Cley Faye]

It should be somewhere along this path:
Tools Menu->Options->LibreOffice->Paths. I see a "Backup" entry there.

-- 
Cley Faye
http://cleyfaye.net

2015-01-22 18:53 GMT+01:00 Thomas Taylor :

> LO  4.3
> I haven't been able to find where to set backup folder location/path.
> Haven't
> been able to locate that setting in any of the menus or under "options".
>
> Would one of the list users please be able to provide that information or
> direct
> me where to change backup settings?
>
> Thanks,  Tom - list moderator (no, not that Tom :>)
>
> --
> I must be getting absent-minded.  Whenever I complain things aren't what
> they
> used to be, I always forget to include myself.
>   -  George Burns
>
> ^^  --...  ...--  / -.-  --.  --...  -.-.  ..-.  -.-.
>
> 
> Tom Taylor  KG7CFC
> openSUSE 13.1 (64-bit), Kernel 3.11.6-4-default,
> KDE 4.11.2, AMD Phenom X4 955, GeForce GTX 550 Ti (Nvidia 337.19)
> 16GB RAM -- 3x1.5TB sata2 -- 128GB-SSD
> FF 27.0, claws-mail 3.10.0
> registered linux user 263467
>
> --
> 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

Re: [libreoffice-users] Re: compatibility with Microsoft Access

[Cley Faye]

2015-01-31 18:26 GMT+01:00 Urmas :

> fosstards


We can all thanks Urmas for raising the level of discussions here. That's
outright aggressive, for those that still have doubt.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Split Screen in Writer?

[Cley Faye]

2015-02-02 9:10 GMT+01:00 Alex Thurgood :

> Symphony, IBM's OOo-like offering (now abandoned) also had a tabbed
> document management interface more akin to browser tabs.
>

​For what it's worth, some Window Manager do have this feature. It's easily
accessible in KDE, and I suppose similar things are available with other
stuff​ like Unity (which is, if I recall correctly, the "default" desktop
on Ubuntu).
Something like this: https://i.imgur.com/AwnykY7.png (look at the title
bar). Of course it is very different from having the feature integrated
within LO, but it can still be useful.

An interesting (?) feature beside split view could be synchronized
scrolling, but that does not sound like a quick thing to do.

-- 
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] ### signs in Calc

[Cley Faye]

I'm pointing the obvious, but anyway...

### as a formula result usually mean that the cell is too narrow for the
result to be displayed. Is that a possibility here?

-- 
Cley Faye
http://cleyfaye.net

2015-02-19 14:57 GMT+01:00 Dave Asaibene :

> Help.
> I thought I was doing something wrong and have working on this situation
> for a few days or nights.
> I take two cells, create a formula in a third cell and the calculation
> results in a ###.
>
> First I thought it was a field not formatted for numbers. Tried formatting.
> Closed Libre. Restarted Same. Rebooted Mac, Same.
> Then I thought it was the sheet. Tried a simple formula like the number 2
> in A1 and the number 2 in B1. Went to cell  C1 clicked SUM and picked the
> default suggestion and pressed enter. Same result.
> Went to the Frugal Computer guy to review but did not discover anything
> glaring wrong in what I was doing.
> Thought it was my recent install of Libre from a few weeks ago. Erased and
> Downloaded again. Same issue.
> At this point I thought that I was really doing something dumb!
> Tried the same process in Apples Pages, like two cells and SUM. Works OK.
> Went to another Mac running an older version of Libre and Tiger. Works OK.
> It really seems like I am doing something dumb. Can anyone offer any
> suggestions?
>
> Thanks
> Dave
> --
> 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

Re: [libreoffice-users] ### signs in Calc

[Cley Faye]

What you're describing sort of sounds like the feature that prevent
computing formula if the file originate from another office suite if it
could cause issues, but that's probably not it as it should not prevent you
from typing new formula.

Could you upload such problematic file somewhere so we can look at it?

-- 
Cley Faye
http://cleyfaye.net

2015-02-19 21:11 GMT+01:00 Dave Asaibene :

> Brian. Thanks
> Gee I wish it was that simple.
> I reduced the font size from 10 to 6 changed the font style and increased
> the column with to the rest of the page. While I do not get ### any longer,
> I now see the formula =SUM(A1:A2). What is also interesting is on the
> format cells menu, in the box on the lower right I see the correct result.
> I am doing this on a blank sheet with single digits like adding 1 and 2 to
> get the result of 3. I feel pretty dumb in not getting the result.
> Thanks
> Dave
>
> > On Feb 19, 2015, at 10:44 AM, Paul D. Mirowsky 
> wrote:
> >
> > Doesn't it seem time that this become a new feature with a default
> setting.
> > -Automatically expand width of column.-
> >
> > On 2/19/2015 9:18 AM, Brian Barker wrote:
> >> At 08:57 19/02/2015 -0500, Dave Asaibene wrote:
> >>> I take two cells, create a formula in a third cell and the calculation
> results in a ###.
> >>
> >> As you can see from the help text (under "### error message"), this
> means "The cell is not wide enough to display the contents." You need
> either to
> >> o (simplest) increase the column width, or
> >> o reduce the font size, or
> >> o possibly modify the cell formatting so that the displayed result is
> narrow enough to fit.
> >>
> >> Remember that the result that is too large to be displayed may itself
> be an error message.
> >>
> >>> Went to the Frugal Computer guy to review but did not discover
> anything glaring wrong in what I was doing.
> >>
> >> Sack him and find a better computer guy(/gal).
> >>
> >> I trust this helps.
> >>
> >> Brian Barker
> >>
> >>
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> deleted
> >
>
>
> --
> 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

Re: [libreoffice-users] Use Java for macros in Base

[Cley Faye]

2015-02-28 21:18 GMT+01:00 Stefan v. Wachter :

> the class com.sun.star.uno.UnoRuntime is missing.


​Side note: you have to add ridl.jar in your classpath for that. Some
online tutorials are out of sync with these kind of requirements.​

-- 
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] exporting calc as csv but keeping ods form

[Cley Faye]

Doesn't the File->Save a copy... do the job?

-- 
Cley Faye
http://cleyfaye.net

2015-03-13 16:52 GMT+01:00 Eric :

> I have an application that takes input formatted as csv.  my source form
> is calc sheet with computed cells.  if I save as csv, I need to re open the
> sheet's ods file when I make changes.  is there any way to export as csv
> but keep the original ods in calc??  macro? bit o'python?
>
> --- thanks
>
>
> --
> 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

Re: [libreoffice-users] Re: E-mail Account Verification

[Cley Faye]

2015-03-16 15:42 GMT+01:00 anne-ology :

>is this for real or not?
>I cannot believe this is for real therefore I'm ignoring it;
>   yet I'm curious as to how these inane ideas occur to some folks.
>

​Looks like a 101 Phishing attempt.​ And yet enough people keep falling for
them :(


-- 
Cley Faye
http://cleyfaye.net

-- 
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] Notice to Appear in Court

[Cley Faye]

2015-04-19 20:48 GMT+02:00 toki kantoor :

> The scary thing is that despite being sent to the wrong email address, the
> intended recipient is presumed to have been legally served, n most parts of
> the United States.


​I doubt that anyong was the intended recipient. I got the exact same mail
as spam, outside of the LO list.

-- 
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] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

[Cley Faye]

Discussion about open formats aside, I've looked at the file and it looks
like when saving as xlsx each sheet grow huge (some goes to ~20MB before
compression).

Could you also post the xlsx file obtained when saving with MSO, for
comparison? My guess is that either LO saves *a lot* of empty/dummy cells,
or that it saves in an older xlsx format that is less compact.

btw this is only a "by curiosity" request, but it could help the dev
pinpoint an issue if my first guess is correct.

-- 
Cley Faye
http://cleyfaye.net

2015-04-23 17:28 GMT+02:00 Tom Davies :

> Hi :)
> Yeh, i don't know a good way around that :(  other than the way you already
> use! :))
>
>
> People used to be quite happy with the idea of downloading Adobe Acrobat to
> read Pdfs with.  It used to be that almost any website that shared any kind
> of document tended to only have them as Pdfs and also then 'had to' have a
> button to help people download and install an Adobe Pdf Reader.  We hardly
> see any of that these days but that is quite a recent change.
>
> There were objections from people working in the council, or other
> government offices or in big companies that they couldn't install anything
> and thus couldn't use the format that everyone else seemed to be using so
> much.  Now they seem to use Pdf more than everyone else, and even demand
> that other people use it!
>
> Regards from
> Tom :)
>
>
>
>
>
> On 23 April 2015 at 16:08, Ramon Tavarez  wrote:
>
> > Hi:
> >
> > Thanks for your attention.
> >
> > The fact with this file is that can't be supported by .XLS format, and my
> > coworkers doesn't work with LibO, and that is the only way I can use to
> > "keep in touch" with them and their jobs. It may be a pain .. ... ... ,
> > but while it work I'll keep using this method to share my jobs with them!
> >
> > In  use LibO for every document  I  create, even I update every version
> of
> > LibO  as the module for my Linux distro: Porteus.
> >
> > On the other hand,I can understand the situation with MSOffice and how
> > they refuse the OpenDocument formats, but I still worry about   the big
> >  file size for those files not supported by the "classical" file type.
> >
> > This can lead erroneously, as you said,  to people to believe that
> > everyone else made bad spreadsheet programs and everyone should stick
> with
> > MS.
> >
> > Thanks.
> >
> > *Ramón E. Tavárez B.*
> >
> > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies  wrote:
> >
> >> Hi :)
> >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> >> different version of MS Office uses slightly different versions.  There
> are
> >> at least 3 different "transitional" versions of the format and they are
> not
> >> always compatible with each other.
> >>
> >> If you take the XlsX that was saved by MS Office 2013 and try opening it
> >> in another version of MS Office, say 2010 or 2007, or even 365 then you
> may
> >> well find it's been opened in "Compatibility Mode" or even that it
> doesn't
> >> work at all in extreme cases.  Chances are that some things will have
> moved
> >> around or vanished, especially if you have anything in a frame (such as
> >> images).
> >>
> >> It makes a bit of sense that a file created with newer software might
> not
> >> fare too well on older versions of the same program but with XlsX and
> the
> >> other OOXML formats it even seems to happen the other way around.  Save
> a
> >> file in MS Office 2007 and you get the same problems trying to open that
> >> file in more recent versions of MS Office.
> >>
> >>
> >> MS keep the specs for their formats secret.  There is an ISO definition
> >> of OOXML but that doesn't seem to work in any version of MS Office.  MSO
> >> 2013 was the first that allowed people to save in "strict" but the
> >> resultant files don't seem to be able to be opened in any version of MS
> >> Office.
> >>
> >> So pretty much all programs struggle with trying to read or write XlsX
> or
> >> other OOXML files in any reliable way.  Which version of MS Office
> should
> >> they aim for?
> >>
> >> Actually we had a few times where the LibreOffice user in an office has
> >> been the only person able to open files from colleagues using different
> >> versions of MS Office and has then become a kinda stepping stone for
> >> 

Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

[Cley Faye]

That's interesting. Examining the beginning of one of the "big" sheets in
both case, we see that LibreOffice is *very* verbose with what it save. If
I understand it correctly, LO save informations about *every* cells,
including empty ones. Which is very odd, since it does not do it with
*every* sheets.

This does not explain why MSO have to "repair" the files though. Maybe the
devs would be interested in this test case.

-- 
Cley Faye
http://cleyfaye.net

2015-04-23 20:12 GMT+02:00 RamonTavarez :

> Check the post,  I've uploaded the requested file.
>
> Thanks for your interest.
>
> Regards
>
> *Ramón E. Tavárez B.*
>
> On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail
> Archive]  wrote:
>
> > Discussion about open formats aside, I've looked at the file and it looks
> > like when saving as xlsx each sheet grow huge (some goes to ~20MB before
> > compression).
> >
> > Could you also post the xlsx file obtained when saving with MSO, for
> > comparison? My guess is that either LO saves *a lot* of empty/dummy
> cells,
> > or that it saves in an older xlsx format that is less compact.
> >
> > btw this is only a "by curiosity" request, but it could help the dev
> > pinpoint an issue if my first guess is correct.
> >
> > --
> > Cley Faye
> > http://cleyfaye.net
> >
> > 2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=0>>:
> >
> > > Hi :)
> > > Yeh, i don't know a good way around that :(  other than the way you
> > already
> > > use! :))
> > >
> > >
> > > People used to be quite happy with the idea of downloading Adobe
> Acrobat
> > to
> > > read Pdfs with.  It used to be that almost any website that shared any
> > kind
> > > of document tended to only have them as Pdfs and also then 'had to'
> have
> > a
> > > button to help people download and install an Adobe Pdf Reader.  We
> > hardly
> > > see any of that these days but that is quite a recent change.
> > >
> > > There were objections from people working in the council, or other
> > > government offices or in big companies that they couldn't install
> > anything
> > > and thus couldn't use the format that everyone else seemed to be using
> > so
> > > much.  Now they seem to use Pdf more than everyone else, and even
> demand
> > > that other people use it!
> > >
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > >
> > > On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=1>> wrote:
> > >
> > > > Hi:
> > > >
> > > > Thanks for your attention.
> > > >
> > > > The fact with this file is that can't be supported by .XLS format,
> and
> > my
> > > > coworkers doesn't work with LibO, and that is the only way I can use
> > to
> > > > "keep in touch" with them and their jobs. It may be a pain .. ... ...
> > ,
> > > > but while it work I'll keep using this method to share my jobs with
> > them!
> > > >
> > > > In  use LibO for every document  I  create, even I update every
> > version
> > > of
> > > > LibO  as the module for my Linux distro: Porteus.
> > > >
> > > > On the other hand,I can understand the situation with MSOffice and
> how
> > > > they refuse the OpenDocument formats, but I still worry about   the
> > big
> > > >  file size for those files not supported by the "classical" file
> type.
> > > >
> > > > This can lead erroneously, as you said,  to people to believe that
> > > > everyone else made bad spreadsheet programs and everyone should stick
> > > with
> > > > MS.
> > > >
> > > > Thanks.
> > > >
> > > > *Ramón E. Tavárez B.*
> > > >
> > > > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=2>> wrote:
> > > >
> > > >> Hi :)
> > > >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> > > >> different version of MS Office uses slightly different versions.
> > There
> > >

Re: [libreoffice-users] Re: Unzipped opendoc files

[Cley Faye]

The functionality doesn't seem to be present in LibreOffice itself (at the
very least, it's not in obvious places).

But if you really want to use an SVC on the content, you could probably set
things using fuse-zip or something similar. It might not work very well
however, as LibreOffice enjoy having files in a certain order inside their
zip (especially the mimetype at the beginning).

All things considered, you might as well go with using the flat XML format,
which is slightly more SVC-friendly.

-- 
Cley Faye
http://cleyfaye.net

2015-05-13 14:04 GMT+02:00 mkrbins :

> Oh, I'm not sure I made myself clear.
> What I was asking is
> Can soffice use a directory resulting from an unzip as if it were an odt
> document?
> Presumably all information of the document is in the directory.
>
> So given the right starting point soffice or swriter or scalc should be
> able
> to treat the directory as an odt document.
>
> so normaly I would do something like
>
> swriter thedocument.odt
>
> but I could unzip "thedocument.odt" as otherplace/thedocument.odt
> (directory
> name)
>
> and do
>
> swriter otherplace/thedocument.odt
>
> and just be editing an unzipped odt document
>
> Ok, it doesn't work like that but is there a way that it would?
> So you might think.
> What the f... is this guy thinking about?
> Well I was thinking about using a standard SVC on such a directory.
> Ok so LibreOffice does have a document version tracking functionality.
> I was just wondering if there would be a way to do it 'old-style'.
> Of course there would be a lot of  problems working this way.  (Most of all
> the influence of any change would not be very clear)
> I did not say it would be a smart way to work.
> I just wanted to check if it would be possible at all.
> :-)
>
>
>
> -
> Michel K.
> --
> View this message in context:
> http://nabble.documentfoundation.org/Unzipped-opendoc-files-tp4148436p4148533.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

Re: [libreoffice-users] Re: Unzipped opendoc files

[Cley Faye]

I believe the idea is to have a file structure like this:

/home/foldername/Configurations2
/home/foldername/content.xml
/home/foldername/layout-cache
/home/foldername/manifest.rdf
/home/foldername/META-INF
/home/foldername/meta.xml
/home/foldername/mimetype
/home/foldername/Pictures
/home/foldername/settings.xml
/home/foldername/styles.xml
/home/foldername/Thumbnails

And to directly "open" it with libreoffice, using /home/foldername, without
zipping/unzipping the odt file.

-- 
Cley Faye
http://cleyfaye.net

2015-05-13 14:23 GMT+02:00 James Knott :

> On 05/13/2015 08:04 AM, mkrbins wrote:
> > Oh, I'm not sure I made myself clear.
> > What I was asking is
> > Can soffice use a directory resulting from an unzip as if it were an odt
> > document?
>
> If I understand what you're saying, you may be able to edit it, but
> unless you save it elsewhere, your changes won't be saved.  You can't
> just open a zip, change something and then expect the changes to be
> saved when you close the zipped file.  You'd have to save the contents
> somewhere and then zip them.
>
>
> --
> 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

Re: [libreoffice-users] open files automatically

[Cley Faye]

2015-05-27 15:15 GMT+02:00 Gary Dale :

> Put that into a script or a link to a script in your "Autostart" folder
> (.kde/Autostart on my KDE system).
>
> To open all the files in a folder, just use a loop like this:
>   for f in *; do; libreoffice --calc -o $f; done
>
> We don't need no stinking features when we've got a real command line.  :)
>

​Nitpicking, but for that you can just do:
$ libreoffice ​*.ods

The -o is only needed if you want to open template for edition, and --calc
is redundant if the file are spreadsheet :)
(also, this will be noticeably more efficient: your for loop start a new
process for every file, which can lead to race condition and stuff).

This is only if your shell is up to the task though. On windows, using
wildcard like * doesn't work with libreoffice. You can still open multiple
file with a single command by passing them one after another. But, on
windows, you also have to pass the full soffice.exe path to the command
line as it is not in the path :\

-- 
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] open files automatically

[Cley Faye]

2015-05-27 19:46 GMT+02:00 Brian Barker :

> No, he doesn't want it at start-up, it seems, but instead when he starts
> LibreOffice. But something like this as a desktop shortcut or menu item
> (not in the start-up folder) is no doubt ideal.
>


​Since we're talking windows (I missed that information from previous post,
sorry), making a shortcut that open multiple files is trivial. ​The only
"obstacle" would be to easily get all the file paths.

To create the shortcut (on the desktop or anywhere else really): in the
start menu, go to the LibreOffice entry (no need to use "calc"
specifically), and right-click-drag (drag with the right click) where you
want the shortcut. When releasing the mouse button, a menu show up giving
the occasion to create a shortcut.

At this point, the new shortcut can be edited (right click->properties). In
the "target" box, there's something that end with soffice.exe". You can put
file names after this. For example, the whole box could read like this
(including the quotes):

"C:\Program Files (x86)\LibreOffice 4\program\soffice.exe"
"E:\Documents\smth1.ods" "E:\smth2.odt"

Then click ok. That link will cause LibreOffice to open all the given
document.

As a final hint, there's a way to *easily* get all the files you want, with
their path.
- Open a shell (no, it won't hurt) by pressing Win+R, and typing "cmd" as
the command
- In the shell, type (without the quotes of course): "more >
Desktop\filelist.txt"
​- Drag'n'drop all your files one by one in the shell window​, pressing
space after each files
- When done, press return, then ctrl+c
- type "exit" to leave the shell

At this point, you have a file named "filelist.txt" on your desktop,
containing all files with full path. You just have to copy/paste this
string in your shortcut :)


​As said by others, I'd rather not see LibreOffice itself getting this
"feature". It is something that can be achieved rather easily in any OS.
One could argue that it's even *the point* of modern systems...​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: open files automatically

[Cley Faye]

Something I'm not getting there...

To launch LibreOffice, you either use a shortcut of some sort, or directly
run a command in a run dialog. That's true for any OS.

There where solution proposed for either cases, on different OS. You can
either create a new shortcut to open documents to your liking, or even
alter the default one in the start menu in the exact same way. If you need
more advanced functionalities, it is even possible to point the default
shortcut to a script that will cook things the desired way.

How does that not answer the question at hand? Is there really a hard
necessity to add inside LibreOffice an option that can be handled with a
*lot* of flexibility directly from the OS? What I don't get is, what's the
difference between clicking an LO shortcut that open lots of documents, and
clicking an LO shortcut that open LO that opens lots of documents?

The only thing that isn't obvious from this thread is if you want to open
files, from a directory, where the actual list of files vary from time to
time, under windows. That's the cornercase that noone wants to touch, but
still easily feasible if that's really what is desired here (although it's
more a windows issue than a LibreOffice issue).

Unless I totally missed the point, and the question wasn't about
automatically opening a set of document when starting LibreOffice... in
that case, please ignore me.

-- 
Cley Faye
http://cleyfaye.net

2015-05-28 18:57 GMT+02:00 James Knott :

> On 05/28/2015 12:38 PM, James Knott wrote:
> > On 05/28/2015 12:21 PM, Andreas Säger wrote:
> >> I don't understand why any application should do this.
> >> Put your files into your assumed auto-start folder. I would use links
> >> instead of the real files.
> >> Open that folder, hit Ctrl+A and Enter to open all the files with the
> >> default application.
> > That was possible in OS/2, but I haven't seen it anywhere else.  With
> > OS/2, you could create a "Work Area" folder and whenever that folder was
> > opened, whatever was in it would also open.
> >
>
> Forgot to mention, closing the folder also closed the open documents.
> So, you could create a work area folder for a project, place all the
> files for that project in the folder and then open or close them all at
> once.   You could also create shadows for those documents in the work
> area folder, but leave the originals elsewhere.  A shadow is another
> instance of the exact same file, so changes in a shadow automagically
> appear in the original.
>
>
> --
> 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

Re: [libreoffice-users] Editing new line when pressing enter

[Cley Faye]

I am not sure if I understand your issue correctly. I'll assume this is in
Writer.

When you press enter, it insert a new paragraph. Using default styles, each
paragraphs have a small border that separate them. Is that the "another new
line" you are mentioning?
If that is the case, it is not really a "new line", only spacing between
paragraphs. There is no real concept of "individual lines" in modern text
processor.

I think it is better to learn to use styles and more generally how text
blocks are handled, as it provide much more flexibility regarding usability
and formatting.

But, if you want the ability to precisely put your text "line by line"
without spacing, there are two fast way to do so:
- Change the paragraph style to not have any spacing over and under
- Press Shift+Enter. This will not insert a paragraph break, but a newline.

Note that using the second approach can still lead to issue on page break,
where LibreOffice might try to keep a paragraph's lines together (again,
this is configurable in styles).

-- 
Cley Faye
http://cleyfaye.net

2015-07-01 2:10 GMT+03:00 dworldjumper :

> Hi
>  I am an old fashioned guy that remembers the days when typewriters were
> used on a regular basis. I want to know how to get to a new line w/press
> enter w/out getting another one added on as well. I have also discovered
> that if I copy and paste an amount of text from another source it will keep
> the extra line adding feature into my document I am currently working on.
> The only way I have found how to remove it is just type all the stuff I
> want
> new added instead of copying it from somewhere else. Is there an easier way
> to do this? Thanks for any help you can give.  dworldjumper
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Editing-new-line-when-pressing-enter-tp4153232.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

Re: [libreoffice-users] spreadsheet not calculating correctly

[Cley Faye]

Do you have a sample file with this error?

Using an older version (4.4.1.2) I can't seem to reproduce this behavior.

-- 
Cley Faye
http://cleyfaye.net

2015-07-09 15:01 GMT+02:00 Mike Scott :

> An oddity that's popped up, but I can't repeat the effect in another
> spreadsheet.
>
> My spreadsheet (freshly loaded) has 3 particular cells:
> B5  completely empty
> C5  33520
> D5  =SUM(B5:C5)
>
> D5 currently wrongly displays 0, and F9/recalculate doesn't change this.
>
> Now, if I set B5 to 0, D5 changes to 33520 (at last correct!), and if I ^Z
> to undo the change, D5 remains showing 33520. Likewise, changing C5 makes
> D5 update correctly, or indeed if I retype the SUM() expression. (The only
> way of getting the wrong result back is to reload the spreadsheet from disk)
>
> So, I have a spreadsheet showing a wrong calculation result. Thankfully, 0
> was a pretty obvious error.
>
> Any thoughts?
>
>
>
> (This is LO 4.4.4.3 on Mint 17)
>
>
> The relevant row from the contents.xml file contains:
>
>  table:number-columns-repeated="2"/> office:value-type="float" office:value="33520"
> calcext:value-type="float">33520 table:style-name="ce2" table:formula="of:=SUM([.B5:.C5])"
> office:value-type="float" office:value="0"
> calcext:value-type="float">0 table:number-columns-repeated="1020"/>
>
>
>
> --
> Mike Scott (unet2  [deletethis] scottsonline.org.uk)
> Harlow Essex England
>
> --
> 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

Re: [libreoffice-users] v2.0 Images copied to Libre Office Writer from Shutter look so pixelated

[Cley Faye]

It might be related to this existing bug report:

https://bugs.documentfoundation.org/show_bug.cgi?id=86675

Could it be possible to test with LibreOffice 5 just to see if it really
fix the issue?

-- 
Cley Faye
http://cleyfaye.net

2015-07-31 21:53 GMT+02:00 Joel Madero :

> Seems like this is a bug report and not a request for help...please report
> (with steps, attachment, and your system specs) to
> bugs.documentfoundation.org.
>
>
> Thanks
>
> On Fri, Jul 31, 2015 at 11:12 AM, WMID  wrote:
>
> > Attach:
> >
> >
> https://mega.co.nz/#!C1kC0QKT!Ya1WV5X05LMfBqEY0ULQge7IKSjYovWMsnihS_WSt9s
> >
> > This picture are made with shutter 0.93.1 on UbuntuStudio 14.04 i386, I
> > used LibreOffice 4.4.5.2 from PPA
> >
> > ppa:libreoffice/libreoffice-4-4
> >
> > This picture when I insert to libreoffice see bad quality
> >
> > The same when I insert this picture on WPS Office from:
> >
> > http://wps-community.org/download.html
> >
> > this picture see very fine, good quality.
> >
> > Only SVG on Libreoffice 4.4.5.2 are very fine, very good quality. The
> > problem is that shutter only working with png, jpg, bmp on the fly, and
> to
> > make my work faster I need drag and drop from shutter to libreoffice to
> > make a tutorial faster, I know that shutter can export to svg in the
> editor
> > mode but the same happen, the picture not see cleary, even if it worked
> it
> > would mean that I would have to give more clic, is this not good to
> > productivity, With WPS not happen this, working fine
> >
> >
> > --
> > Ingeniero en Alimentos
> > Washington Indacochea Delgado
> >
> > --
> > 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
> >
>
>
>
> --
> *Joel Madero*
> LibreOffice QA Volunteer
> jmadero@gmail.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

Re: [libreoffice-users] porting macros to 5.0

[Cley Faye]

Hi,

The way it worked previously (from LO3 to LO4), LibreOffice imported your
previous profile when creating the new one.

Now, I've just installed LibreOffice 5 to check, and I didn't get any
.config/libreoffice/5 directory; instead it seems that new changes are
still saved in the .config/libreoffice/4 directory... maybe this is a bug,
maybe it is by design...

Anyway right now it seems there's nothing to do to keep settings from 4 to
5.

2015-08-06 10:23 GMT+02:00 Tim Lloyd :

> Hi,
>
> I assume that when I install 5.0 I get a new directory in my home area -
> .config/libreoffice/5? Linux user BTW.
>
> Could someone pls advise how to copy my macros from 4 to 5? I had a browse
> through the existing directories and nothing leapt out at me. 4 looks like
> this:
>
>[tim@lizard ~]$ ls .config/libreoffice/4/
>cache  user
>[tim@lizard ~]$ ls .config/libreoffice/4/user/
>autocorr  basic extensions  registrymodifications.xcu uno_packages
>autotext  configgallery store wordbook
>backupdatabase  psprint temp
>
>
> Thanks
>
> --
> 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

Re: [libreoffice-users] Error message when inserting rows

[Cley Faye]

Would that insertion push your sheet to more than 1M rows?

-- 
Cley Faye
http://cleyfaye.net

2015-09-02 13:39 GMT+02:00 Russ Butler :

> Hello,
>
> I am trying to use the "insert rows above" function to insert around 70
> rows at a time.
>
> I keep getting the following error: "Filled cells cannot be shifted beyond
> the sheet."  Closing the sheet and program and re-opening does not resolve
> the issue.
>
> Spreadsheet is not very big and there appears to be thousands of rows
> available.
>
> LibreOffice: Version: 4.4.5.2
> Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
> Locale: en_US
>
> Windows 8.1
>
> Any ideas?
>
> --
> 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

Re: [libreoffice-users] Writer - footer on last page only?

[Cley Faye]

2015-09-11 13:23 GMT+02:00 Gordon Burgess-Parker :

> Is there any way of inserting a footer on the last page only of a document?
>
>
​Yes. Define a different page style, and apply it to the last page. Footers
are different for each page style​, so by doing this you can add a footer
only to the page having this style, and leave the other untouched.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: mimetype=text/csv opened in writer

[Cley Faye]

2015-09-16 10:50 GMT+02:00 Kamil Jońca :

> Are there any rules which decide "this csv is to open with writer, and
> that by calc?"
>

​On what OS ?​
At least on Windows and most Linux, it' the OS that decide what application
is used to open a file. On Linux it's mostly driven by mime types, while on
Windows the filename extension play a major role.
As far as I know, after installation, LibreOffice will not register itself
to handle different file types.
​For example, on one of my installation (Debian Linux with KDE), the
text/csv file type is associated with, in that order, LOCalc​, some basic
text editors, LOWriter, some file viewers. LibreOffice have no saying in
this.

​To help, it would be useful to know more about your system, and if you did
install/uninstall software recently that might have caused this behavior.
In any case, the fix most likely lies in the system configuration.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: mimetype=text/csv opened in writer

[Cley Faye]

2015-09-16 14:53 GMT+02:00 Kamil Jońca :

> I understand. So now question is why some CSV files are open by calc,
> while the others by Writer.
>

​If you have the xdg-mime command installed​, could you test the offending
files with it using "xdg-mime query filetype "?
As CSV files have little to nothing to identify them beside the file
extension, it is possible that some character sequences trick the system
and associate them with something else.

-- 
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] Multi Copy Prints as Separate Jobs

[Cley Faye]

2015-10-13 4:14 GMT+02:00 Mark LaPierre :

> I see a setting in LO that says I should be able to combine multiple
> print jobs into one but I can't get it to work.
>

​What happen if you check the ​"Create single print jobs for collated
output" box in the Options tab from the Print dialog?
Unfortunately I can't check this as I don't have a printer available, but
it feels like it should help.

-- 
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] Dear Libre Office team

[Cley Faye]

2015-10-13 14:47 GMT+02:00 Alexander Y Lee :

> The reason why I write this letter is to ask you about the security of
> this software, I think since it is open source, so I am worrying about the
> security and possibility of being attacked by hacker and virus. I am very
> sensitive toward security and I do not want my documents sent to the hacker
> later. Can I make myself easy about the concern?
>
> And, does this software work independently  like MS office and is it
> Off-line program? or Does it work through cloud service system, API, and
> Online based system?
>

​Hi,

I'll try to address these specific points​.

Yes, LibreOffice is an open source project. However, I have difficulties
seeing the link between the open source status and the actual security.
As a quick summary of things, all software have the potential for security
issues; the only difference between open source and closed source is that
for the former, it is possible to run a security audit on the code to find
these defects, while in closed source you just have to trust some vendors
for their words.
That aside, LibreOffice itself have no (as far as I know) disclosed
security issues at the moment. It have happened (and will happen, as with
any kind of software), and usually such issues are fixed quickly by the
developers.
As long as you download the software from a trusted source (as in, the
official LibreOffice website) there is nothing to worry about on this front.

Also, LibreOffice is a completely offline package, and does not require any
kind of internet connection to run (beyond the initial download of course).
Unless you explicitely use such functionalities, there is no communication
at all coming from the software, with the exception of the update-checking
mechanism.

-- 
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] Capitalise every word

[Cley Faye]

A likely culprit is a specific paragraph style (default key F11 to see
styles).
Check the "Font Effects" tab. The "Effects" entry there allow you to change
the text to Capitals, Lowercase, etc.

-- 
Cley Faye
http://cleyfaye.net

2015-10-14 13:06 GMT+02:00 Malcolm Moore :

> A student has just asked for help and I am stumped.
> As she types Writer automatically capitalises every word.
> How did she do that?
>
>
> Ta
>
>
> Mal
> --
> 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

Re: [libreoffice-users] Re: LEBRE VERSION STILL

[Cley Faye]

2015-11-05 1:28 GMT+01:00 Ken Springer :

> If you want to go head to head with with MS or Corel, then you'll have to
> fix the problems your uses have with the program.


​It's been pointed out already, and I'll reproduce it here:

If this is a bug your options are:
> 1. Fix it yourself;
> 2. Pay for a fix;
> 3. Find a friend/family member to fix it;
> 4. Wait patiently until a volunteer *chooses* to fix it.

​
​Really, as with any opensource project, every resource is finite,
including dev time. What get prioritized by the main devs is (in no
particular order, this is a general remark not specific to LibreOffice)
bugs affecting a very large part of the userbase, trivial issues to fix
(those are rare!), and things that devs are interested in. This also mean
that problems users have with the program do get fixed (just check the
bugtracker).

Beyond that, asking for an opensource project to dedicate resources to fix
a minor issue that is unnoticed by almost everyone (or, in the case of this
thread, something that is not even a bug in LibreOffice) is not reasonable.
If one encounter a particularly nasty issue and can't raise interest in it,
there are companies that can fix them for a price. It have happened before,
and I don't doubt that it will continue to happen.

Note that I'm not even touching the subject of those big corporations
reactivity with minor issues; commercial products might have more
ressources, but I'm sure there's a fair number of minor bugs that have left
some users disgruntled ;)

-- 
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] CONGRATULATIONS!!1!

[Cley Faye]

I usually don't reply to these kind of posts (I keep my rare contributions
in trying to help others...) but there's something to say here.

You forgot to say exactly what's wrong. You didn't even allude to it. Your
whole message can be summed up by "Useless". From the tone of it I guess
that you don't want at all to be constructive, but maybe I'm mistaken; in
that case please tell us what issues, precisely or in general, you have,
and most likely people here (maybe me too) will try to help you out.
For the record, right now, I'm using LibreOffice on my office computer
running Debian without issues, and I'm fairly certain that a lot of people
out there are too, so your "make the software practically useless"
statement is rude, and borderline offensive to the people that work both
with and on LibreOffice.

The purpose of this list is to provide help to users, and it's working as
fine as LibreOffice itself. It is not here so you can vent out and just
drop random, non-constructive nonsense.

Sorry for the noise,

-- 
Cley Faye
http://cleyfaye.net

2015-11-19 15:21 GMT+01:00 O'Shea Keiron :

> Hello everyone,
>
> I am by no means a negative person, so can I just congratulate you all
> on your recent achievements in making LibreOffice completely and
> utterly unusable on the Linux platform!!
>
> It is said by many in the FOSS community that the 'one' thing (of
> many) holding Linux back as an actual usable OS is that it lacks a
> comprehensive office suite.
>
> LO and OO promised to solve this issue. A unified office suite, with
> the ease of use and format compatibility of MS Office.
>
> Instead, we're seeing the software package regress.
>
> It's all well and good chuffing yourselves up about code clean ups,
> but if these clean ups make the software practically useless for the
> end user - then you might as well throw the towel in.
>
> Working software first.
>
> Regards,
>
> --
> Keiron O'Shea 毛毛
>
> Aberystwyth University
> PhD Student, IBERS
> k...@aber.ac.uk || keironteilo.os...@kaust.edu.sa ||
> http://users.aber.ac.uk/keo7
>
> --
> 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

Re: [libreoffice-users] Cannot run Libre Office on the new Microsoft Surface Computers

[Cley Faye]

2015-12-03 5:58 GMT+01:00 Allan :

> Having problems running Libre Office on both the new Surface Pro 4 and on
> the
> new Surface Book. After installing the application and clicking on the
> application, all I get is a black window for the any application in Libre
> Office. This does not happen on the older Surface computers. Only the new
> ones. I have tried deleting and re-installing the program without any
> success. Also tried installing in compability mode without any luck.
> Contacted Microsoft and they stated that they think that the error is in
> the
> way Libre Office is handling OpenGL. Sorry to state that answer was greek
> to
> this new user. Any one have any ideas on how I can solve this problem?
>

If the issue really lies in the way LibreOffice use OpenGL, you can try
disabling it.
If you don't even get access to the application menu, try locate the
registrymodifications.xcu file in your AppData folder
(if I remember correctly, it should be in something like [user
folder]/AppData/Roaming/LibreOffice/4/user).

Open this file with something like notepad or notepad++, search for the
"UseOpenGL" property and set it to false. It should look something like
this:
false

If you can't find the value in the file (probably because it is set to the
default value, which seems to be "true" on windows), you can insert this
whole line:
false
after any "" tag and it should work.

To be on the safe side, make a backup of the file before, in case something
goes wrong.

-- 
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] a question about libreoffice and txt files:

[Cley Faye]

It is not a permanent solution, but you can open txt files through the
File->Open menu of LibreOffice itself.
In the Open dialog, manually select the file type "Text - Choose encoding".
It will let you choose the file encoding.

...if anyone know how to permanently set LibreOffice to open .txt as UTF-8,
I'm all ears ;)

-- 
Cley Faye
http://cleyfaye.net

2016-01-09 12:52 GMT+01:00 nasrin khaksar :

> hi every one.
> i tried both libreoffice and open office.
> fortunately libreoffice recognizes the incoding of the txt files and
> open them without asking about which incoding should is use, and also
> about phont and language.
> its a very great feature that even microsoft office has not and its
> realy unique for libreoffice!
> but in some cases when i want to open a persian txt file with
> libreoffice, unfortunately libreoffice does not recognize the incoding
> and does not open my txt in utf-8 incoding!!!
> as the result, libreoffice desplays this kind of files like chinese or
> japanese characters and its becomes completely unreadible!
> the persian txt files characters are not display correctly in persian
> and becomes unreadible!
>
> in these cases, is it possible to make change in libreoffice settings
> to libreoffice recognizes unicode and utf-8 correctly or at least
> libreoffice asks to which incoding should it use?
> as i mentioned, only the cases that libreoffice does not recognize the
> incoding correctly, i want libreoffice to asks like open office.
> but if it becomes possible to show unicode and persian files always
> correctly, its a very great and unique feature that recognizes without
> asking any questions!
> thanks for your help and god bless you all.
>
> --
> 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

Re: [libreoffice-users] Re: R1C1 reference style with LibreOffice

[Cley Faye]

If it's only a matter of rewriting R1C1 in A1 notations, a simple function
could read the Rx and put the appropriate letter, then remove the C.
If you want to reference cells from the basic code, functions alreay exist
to get cells from their numeric coordinates, as said by others.
I think this cover most cases; also know that you can use the INDIRECT()
function directly in a cell with the R1C1 notation.

-- 
Cley Faye
http://cleyfaye.net

2016-01-20 11:35 GMT+01:00 pacopyc pacopyc :

> Excuse me, I don't understand. Can I rewrite the formulas in R1C1 reference
> style with LibreOffice basic code? How?
>
> 2016-01-20 11:14 GMT+01:00 Andreas Säger :
>
> > Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc:
> > > Ok, but the problem is that I must do it from LibreOffice basic code.
> > >
> >
> > If you would spend more than an hour or two with this matter, you would
> > not have to wait days for the answer.
> >
> >
> >
> >
> > > https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=49294
> >
> > >
> >
> http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html#details
> >
> > > http://www.pitonyak.org/oo.php
> >
> >
> >
> >
> >
> >
> > --
> > 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
>

-- 
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] COUNTIF() with more than one conditions

[Cley Faye]

What I would do is to add a column, fill it with AND() statement to mark
row to add or not, hide it, then use a COUNTIF() using this column as a
condition.

As far as I know, the COUNTIFS() function should do the job but for some
reason I have difficulties to make it works right now :\ you might want to
look into it.

-- 
Cley Faye
http://cleyfaye.net

2016-01-26 20:20 GMT+01:00 csanyipal :

> Hi,
>
> in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
> there is just one of these characters.
>
> I want to count howmany cells are in a range that contains either of these
> characters.
>
> Can I do this in a more elegant way than by using this function bellow?
>
>
> =COUNTIF(C152:C228;"=H")+COUNTIF(C153:C229;"=K")+COUNTIF(C154:C230;"=Sze")+COUNTIF(C155:C231;"=Cs")+COUNTIF(C156:C232;"=P")
>
>
>
>
> -
> Best Regards from
> Pál
> --
> View this message in context:
> http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143.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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

[Cley Faye]

2016-01-28 14:24 GMT+01:00 Philip Rhoades :

>
> You call it "attacking", I call it pointing out logical, childish errors
> of thinking.


​This will be my first and LAST message on this thread, for obvious reason.

The fact that one did something, someone else replied, or attacked, or
whatever, can happen. Once it has been pointed out that it is really,
clearly, without ambiguity, completely, totally and utterly (enough
superlatives yet?) offtopic for the list, it should stop.
If someone feels the need to have the final word in this discussion, do a
favor to *everyone else*, remove the users@global.libreoffice.org address
from your mails on this subject and deal with it like grownups. The fact
that multiple people keep sending mass replies so out of the scope of the
list is way more aggravating than whatever the topic is.

EoT for me.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Libreoffice 5.0.5 with PDF testing..result not correct..need to check to team developers ok?

[Cley Faye]

Hi,

LibreOffice is not a PDF reader at all; it can export content to PDF, but
reading is better done with a dedicated PDF reader.

The only exception to this is if you export PDF using the "hybrid" format
that also save the OpenDocument file in the PDF.

-- 
Cley Faye
http://cleyfaye.net

2016-02-20 13:06 GMT+01:00 :

> hi to all world
> i wish to say you, i find a PDF from online, i checked: open with
> libreoffice 5.0.5 worked but not full correct format and style..
>
> so i want to show you here mail list group users libreoffice for develop
> to best read pdf..ok?
>
> file pdf:http://www.ensmilano.it/public/upload/2008/11/19/Offerta_Tim.pdf
>
>
> i hope for developing best for libreoffice future ok?
> thank you
>
>
>
>
> --
> 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

Re: [libreoffice-users] Problem compiling LibreOffice on Ubuntu Server 14.04

[Cley Faye]

You might get more help from the developers mailing list:
https://lists.freedesktop.org/archives/libreoffice/

Good luck,

-- 
Cley Faye
http://cleyfaye.net

2016-02-24 23:04 GMT+01:00 Robbe Wilkens :

> Hello,
>
> Receiving the error:
>
> root@node1:~/office/core# make
> mkdir -p /root/office/core/instdir
> /root/office/core/solenv/bin/install-gdb-printers -a
> /root/office/core/instdir -c
> make -j 4  -rs -f /root/office/core/Makefile.gbuildall
> /root/office/core/desktop/CppunitTest_desktop_lib.mk:34: ***
> gb_LinkTarget_use_external: unknown external: cairo.  Stop.
> make: *** [build] Error 2
>
> I've got all deps installed and autogen.sh is nog giving any errors.
>
> Trying to compile headless  (./autogen.sh --without-java --without-x
> --with-theme=no)
>
> The external cairo is included in the folder
>
> root@node1:~/office/core# cd external/cairo/
> root@node1:~/office/core/external/cairo# ls
> ExternalPackage_cairo.mk   ExternalProject_pixman.mk
> README cairo
> ExternalPackage_pixman.mk  Makefile
> UnpackedTarball_cairo.mk   pixman
> ExternalProject_cairo.mk   Module_cairo.mk
> UnpackedTarball_pixman.mk
> root@node1:~/office/core/external/cairo# cd cairo/
> root@node1:~/office/core/external/cairo/cairo# ls
> cairo-1.10.2-oldfontconfig.patch  cairo-1.10.2.no-atsui.patch
> cairo.GL_RGBA.patch  no-flto-clang.patch
> cairo-1.10.2.android.patchcairo-1.10.2.patch
> cairo.dlsym.lcdfilter.patch
> cairo-1.10.2.ios.patchcairo-1.10.2.wntmsc.patch
> dummy_pkg_config
>
> Anybody know how to solve this?
> The goal is to set up an libreoffice server to enable editing in OwnCloud.
>
> Kind regards,
> R.W.
>
> --
> 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

Re: [libreoffice-users] Easy rotate in draw.

[Cley Faye]

An alternative solution you might find useful is simply clicking twice on
an object. The "resize" handles will turn into "rotate" handles. From that
point you can rotate an object by clicking one of the corner handles, and
holding Shift will lock the rotation to 15° increments. This will be
relative to the object initial orientation.

So, if you have something at 5.4° and use this method, you can rotate it to
20.4°, 35.4°, 50.4°, etc.

-- 
Cley Faye
http://cleyfaye.net

2016-02-29 0:09 GMT+01:00 Steve Edmonds :

> Hi.
> Is there an easy way to rotate an object in draw 90 degrees or 180 degrees.
>
> I select the object and right click Position and Size. The angle is
> usually some obscure number (156.24) and I have to do some maths to
> calculate the new angle.
> I can't type in 156.24-24 (some software evaluates simple formulae in
> input fields).
>
> Cheers, steve
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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] Encrypted Calc file got corrupted

[Cley Faye]

2016-02-29 12:20 GMT+01:00 Adam Bujdoso :

> Does anyone have an idea how the file could be repaired? I am happy to
> forward the file if someone has a tool to examine it, or perhaps to recover
> it.
>

​Unfortunately, I can't do it myself because I lack the time to do so, but
if someone's up to the task, it could be interesting to have an "extractor"
for secured files.

From my understanding of the specification, password-protected files are
"just" like regular files, meaning that they still are ZIP containing
multiple files. The password-protection is not at the ZIP level, but
instead relevant files are encrypted before they are stored in the ZIP
file.​ To remain efficient, these files are compressed using deflate (the
same algorithm used in zip files) *before* encryption, and then simply
stored in the ZIP file.

An extracting tool could extract the content of the ODT/ZIP file, and using
the password decrypt the relevant files. This would make the file
"components" available for further examination. Since sometimes file
corruption can merely mean a malformed closing tag in the XML that makes up
the core of a document, it could be helpful.

This could also make for a useful side-tool for LibreOffice, since these
corruptions, as rare as they are, still happens sometimes even on
unencrypted files.

-- 
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] Libre Office und IE, Webseiten

[Cley Faye]

(this is a google translated text, english version below)

(Dies ist eine Google übersetzt Text, Englisch Version weiter unten)

Vielleicht möchten Sie
https://wiki.documentfoundation.org/Local_Mailing_Lists#German über lokale
Version der Libreoffice -Mailinglisten für Informationen zu überprüfen.
Diese Liste ist in erster Linie für Englisch-Nachrichten, so sind Sie
wahrscheinlich mehr Hilfe, um die Deutsch-Version verwenden zu bekommen.
Oder Sie können Ihre ursprüngliche Nachricht in Englisch auf dieser Liste
erneut einreichen, um mehr Menschen zu erreichen.


You might want to check
https://wiki.documentfoundation.org/Local_Mailing_Lists#German for
information about local version of the LibreOffice mailing lists.
This list is mainly for english messages, so you're likely to get more help
using the german version.
​Or you can resubmit your original message in english on this list to reach
more people.​

-- 
Cley Faye

2016-03-01 8:05 GMT+01:00 Peter Heinicke :

>
>
> Gesendet von Mail für Windows 10
> Hallo
>
>
> Ich habe meinen Acer Aspire 5742G auf win 10 umgestellt. Seit diesen Tag
> gibt es Probleme mit dem IE, beim suchen im Internet las ich das, das ´ich
> nicht der einzige bin und dies auch mit anderen Browsern ist.
> Folgendes ist bei mir, ich kann Webseiten ins Word Pad
> schieben(kopieren/einfügen) aber das funktioniert nicht mit Libre Office.
> So wird auch mein Drucker nur beim Drucken von Webseiten nicht gefunden.
>
> Meine Frage gibt es eine Lösung, Einstellung  für Libre?
>
> Eine Telefongespräch mit dem Support Microsoft brachte nichts. Die meinen
> ich muss über Microsoft Office gehen und es liegt an meinen System selbst.
> Ich müsste immer ein Gerät haben was nicht älter als zwei Jahre ist und
> mich an Acer wenden.
> Das wäre dann wohl die größte Abzocke.
> Ich hoffe das es eine Lösung gibt die nicht Neukauf heißt.
>
> Danke schon mal
>
> Gruß….Peter H.
>
> --
> 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

Re: [libreoffice-users] about unicode txt documents:

[Cley Faye]

2016-03-11 10:24 GMT+01:00 nasrin khaksar :

> hi every one.
> a person gave me some txt documents stored with microsoft word with
> the unicode encoding.
> but when i activate libreoffice open dialog box and select txt choose
> encoding, libreoffice has not unicode alone and has only unicode utf-8
> for this reason i cant open them properly and my documents which
> stored with microsoft word in unicode encoding, its completely
> unreadible via libreoffice unicode utf-8 and the characters are not
> display in persian!
> what should i do to solve them?
> the problem is very critical for me and my documents are very valuable for
> me.
> thanks for your help and god bless you all.
>

​Are you sure that the file is actually unicode ? MS Word have a history of
not doing what he's told with file encodings...

If it is, you might want to try UTF-16, some quick search (
http://www.herongyang.com/Unicode/Word-Save-File-in-Unicode.html) suggest
that the label-less "unicode" settings can be UTF-16 with BOM​. Now, BOM
support in LibreOffice is another matter. The UTF-16 encoding should be
right below UTF-8; at least it is with LibreOffice 5.0.5.2

(Also, your signature is ill-formed; it should begin with "-- ", two dashes
and a space, followed by a newline. This way people that don't care about
signature can easily filter them out).

-- 
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] do screenshots survive?

[Cley Faye]

2016-04-04 13:00 GMT+02:00 Tanstaafl :

> image formats that cannot contain a hidden payload


​If we're talking about security issue, I'm not aware of any image format
that is absolutely 100% certain to not be able to contain any hidden code
;) as long as it gets decoded, there's a (limited) risk.

But I believe this is not only a security issue; attachments takes space,
and letting them through a mailing list would multiply the bandwidth
requirement by as many subscribers the list have, while hosting the images
somewhere and putting links to them will limit the bandwidth usage to only
people actually looking for them, along with not cluttering limited
mailboxes (yes, they still exist).

If required, there are a lot of hosting sites that can be used for images,
and for convenience the nabble interface will actually do that for you I
believe.​

-- 
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] LibreOffice Online

[Cley Faye]

The usability issue might be related to the fact that it is an online
service, and is subject to bandwidth and computing power restriction.

To truly evaluate such service, it might be better to just grab the code
and deploy it in local. If it works well enough, I can see this being
useful in corporate environments.

-- 
Cley Faye
http://cleyfaye.net

2016-04-25 3:49 GMT+02:00 Marc Grober :

> At least on-line at open365.io it seems completely unusable. Though you
> can access the KDE, the application simply never comes up.
> And documentation requires that you open the application, rofl...
>
>
> On 4/24/16 3:19 PM, Pedro wrote:
> > Hi all
> >
> > Sharing exciting news
> >
> >
> http://nabble.documentfoundation.org/libreoffice-l10n-LibreOffice-on-the-cloud-Open365-tp4181681.html
> >
> > It links to the brand new
> >
> > https://open365.io/
> >
> > I just opened an account and it behaves exactly like the offline version.
> > You can even change the icon theme or add extensions like dictionaries
> (and
> > they work!)
> >
> > The only limitation is that the interface is in US English only.
> >
> > Have fun!
> >
> > (I'm not affiliated to the company providing the service, in fact I
> couldn't
> > find any information about it so I wouldn't recommend uploading any
> > sensitive information...)
> >
> >
> >
> > --
> > View this message in context:
> http://nabble.documentfoundation.org/LibreOffice-Online-tp4181840.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

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

[Cley Faye]

2016-05-11 21:43 GMT+02:00 shirish शिरीष :

> Now non-plussed how to tell libreoffice to tell it to treat them as
> 'real numbers' ?
>

​Short answer: it should work :)

If a cell is somehow stuck in the "text" type, you could try clearing all
formatting on this cell (defaults to Ctrl-M), or select the affected cells,
do right-click/properties, then select an appropriate number format.
However, LibreOffice should recognize number automatically unless
explicitely instructed to treat them as text; this can happen from weird
copy/paste, when opening files in exotic formats, or by doing it by hand.
It is also possible (although we didn't see a sample file) that there are
extra characters in the cells, or maybe an invalid decimal separator for
the file's locale.

​If you could upload a sample somewhere, we might get a better look at it
:)​

-- 
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] Simple sum in column getting zero in libreoffice calc 5.

[Cley Faye]

Ok; having seen the file from a direct message, the problem is way simpler
than a formatting/data type problem :)

The SUM() function works to add values from cells. The problem is that you
have something in your cell that is not *a* number (things like
"3,94,700"). There is no way (that I know of...) to interpret that as a
number, so it is seen as a string.

Since the sample file seems to have three values in each cell, I assume
that the goal is to sum multiple tuples of "x,y,z" to get, in the end, the
sum of three series of values.
You can (and should...) put each group of values in separate columns and
sum them separately.

If your input data comes from a CSV file, make sure that the comma is used
as a separator, so the input gets split into separate columns. It is the
best course of action IMO; if you need the output in a specific format it
is always possible to merge the results.

I upload the sample file so people can get a look at it:
https://www.dropbox.com/s/qm03gjw3wwlpby9/example.ods?dl=0

Anything more would require knowledge of where your input comes from, or
what kind of output you need.

-- 
Cley Faye
http://cleyfaye.net

2016-05-12 7:46 GMT+02:00 Cor Nouws :

> Hi,
>
> Piet van Oostrum wrote on 12-05-16 00:40:
>
> >> Now non-plussed how to tell libreoffice to tell it to treat them
> >> as 'real numbers' ?
> >
> > One way you can get numbers as text is when you import a CSV file,
> > 
>
> This is another option:
>
> http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
>
> Kind regards,
> Cor
>
> --
> Cor Nouws
> GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
> - vrijwilliger http://nl.libreoffice.org
> - volunteer http://www.libreoffice.org
> - The Document Foundation Membership Committee Member
>
> --
> 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

Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5

[Cley Faye]

2016-05-12 17:04 GMT+02:00 Brian Barker :

>
> Such numbers are interpreted correctly (and can be displayed similarly) if
> the cells are formatted according to an appropriate language, that language
> either inherited from the locale or set explicitly in the Format Cells
> dialogue. LibreOffice is cleverer than you think!


​Well, I was familiar with quite a few ways to represent numbers, but not
that one. We learn everyday it seems. So it comes back to what was said
previously, setting the correct locale for the cells.​

-- 
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] document confidentiality failure

[Cley Faye]

At least on 5.1.1.3 (Windows x64) this "bug" doesn't happen. I can see the
recent document lists in the combobox, but if I clear the document history
autocompletion will not show them back; it merely does autocomplete on file
path and not on the document history...

-- 
Cley Faye
http://cleyfaye.net

2016-05-13 0:13 GMT+02:00 message :

> Readers,
>
> Please be aware of the following bug:
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=99187
>
> --
> 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

Re: [libreoffice-users] Writer Hyperlink Oddity

[Cley Faye]

2016-05-14 9:23 GMT+02:00 Tom Davies :

> I've never understood why underscores are so popular.


​On that particular topic: ​even if almost all OS got support for spaces in
file names (some later than others...), remember that spaces are also used
as a separator in a lot of things.

Obviously, good programming and carefulness can avoid almost all issues,
but the amount of code that's either quickly written, or old, or
unmaintained, or anything, that will not handle spaces in filenames is
frightening. Shell scripts are a major contender of course, but some
"higher level" programs can also mess things, if only by passing arguments
to other programs or ignoring some FS-specific restrictions, etc.
Add to that the inconsistencies (mainly from ONE os though... cough cough)
and avoiding spaces in filenames (as well as avoiding other uncommon
characters) is a sure-fire way to avoid any issue when working with all
that.

Not later than today I found myself giving the path of a file to a program,
only to find out that that specific program will cut arguments *itself* on
the spaces, in addition to taking multiple arguments. The developer
probably never understood why he gets multiple values in argv[], but still.

​If only we could fix all the bad code out there​... ;)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: undo functionality

[Cley Faye]

2016-06-02 0:20 GMT+02:00 V Stuart Foote :

> Personally I can envision a mechanism of incremental document saves and
> linked to the auto-save settings.
> Where now--we can *only* choose to abandon all changes by quitting the
> document. With an incremental save capability, if I wanted to back up
> 10-minutes I'd restore the edit session to that document state.  And I
> would
> assume it could be extended to be able to split out a new document based on
> the incremental save--while continuing with current edits.
>

​A bit of personal opinion here: this can be done completely outside of
LibreOffice, in a program-agnostic way that might be more useful since it
could be applied to other stuff.
A script/program set to monitor a directory/file, and create a new backup
with timestamp every time the file change would suit that purpose. Simply
activate the auto-save feature of your favorite tool and it can take
advantage of it.
Of course, it could also be done *in* LibreOffice/any tool, and provide
better integration (no need to close/reopen file for example). But I'm
cautious when too many unrelated features find their way in a program...

I might write some lightweight python script to do just that, for fun :)
and to make everyone happy, I'll add a settings where you can limit the
amount of backup to keep ;)

-- 
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] more errors, libreoffice on amd64 debian, starts now but immediately aborts.

[Cley Faye]

2011/1/9 baldwin linguas 

> There is no /usr/bin/libreoffice
> LibreOffice is installed in /opt/libreoffice
> the bin file is
> /opt/libreoffice/program/soffice
> (and, of course, there are swriter, scalc, etc. in there to run
> individual components).
> This was the result of installing the 64bit .deb files.
>

Hi,

I have installed libreoffice on a debian 64bits system by pulling the
package from the experimental repository, and they do install binaries in
/usr/bin, nothing in /opt. You should try this.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] more errors, libreoffice on amd64 debian, starts now but immediately aborts.

[Cley Faye]

2011/1/9 baldwin linguas 

> On Sun, Jan 9, 2011 at 12:45 PM, baldwin linguas
>  wrote:
> > Oh wait...it saw that stuff, because I had it installed from the debs.
> > When I remove said installation, apt-cache search libreoffice shows
> nothing.
>
> Oh, I found this:
> http://wiki.debian.org/DebianExperimental
> but it doesn't seem to be making any difference.
>
>
>
Well, if you added the experimental repository and install libreoffice
packages from here, you do get the binaries in /usr/bin etc... :
http://packages.debian.org/experimental/amd64/libreoffice-writer/filelist
These package works out of the box (at least for me...).

You have to be careful to not upgrade your whole system with packages from
experimental, but aside from that, I can assure you that those package works
on a "fresh" install, so if they don't work with you, there might be
something on your system that prevent them from working.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] more errors, libreoffice on amd64 debian, starts now but immediately aborts.

[Cley Faye]

2011/1/9 baldwin linguas 

>
> Work for me?
> They don' t seem to exist!
> apt-cache search libreoffice shows me nothing.
>
>
Well, since I gave you a link to the package content from the official
debian repository (and I have them installed), I'll assume they DO exist.
Maybe you forgot to add them to your system, like explained in the link you
found : http://wiki.debian.org/DebianExperimental or maybe you're using a
mirror that doesn't contain the experimental branch or is not up to date.
Also, although the unofficial .deb from the LibreOffice websites do install
in /opt, I'd recommend you using the packages from Debian, although in
experimental, because:
 - they put the files in more "common" places
 - they are more likely to be maintained this way, as there is a LibreOffice
maintainer for Debian.

Also, you should stop stressing that ubuntu isn't debian. I think most
people on the list know this, but regarding installation methods and general
file locations (libraries, binaries, etc), they are very similar.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] more errors, libreoffice on amd64 debian, starts now but immediately aborts.

[Cley Faye]

2011/1/10 baldwin linguas 

> Oh wait.
> I did find the link you mention.
> Also, for some reason, aptitude and apt are not getting a file list
> from the experimental repo (and a couple others).
> (getting this:
> W: GPG error: http://debian.dc-uoit.net stable Release: The following
> signatures couldn't be verified because the public key is not
> available: NO_PUBKEY 07DC563D1F41B907
> W: Failed to fetch http://ftp.debian.org/debian/dists/lenny/Release
> Unable to find expected entry  experimental/binary-amd64/Packages in
> Meta-index file (malformed Release file?)
> and seeing Ign: in front of several repositories when updating).
> Server down?
> Likely if I can get that resolved (or wait for the server to be back up?)
> then I can solve this problem as you mention, with the debian
> experimental files.
>
>
Although I can't find http://debian.dc-uoit.net in the debian mirror list,
it still seem reasonably up to date, at least regarding libreoffice, see:
http://debian.dc-uoit.net/debian/pool/main/libr/libreoffice/
and
http://debian.dc-uoit.net/debian/dists/experimental/main/binary-amd64/Packages.bz2
which do contain the packages listed.

Also, the error you get from ftp.debian.org is kind of weird, since it's
telling that it can't find experimental in the lenny release, which is
normal, since it's two different release. Can you past exactly the line
you're using to enable the experimental repository here ? Or at least check
if it looks like this:
deb ftp://ftp.debian.org/debian experimental main contrib non-free
and not like
deb ftp://ftp.debian.org/debian lenny experimental main contrib non-free
for example ?

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Linux Distros using LO?

[Cley Faye]

Hi

For Debian: Since LibreOffice is somewhat recent, and still in beta, the
package are only available from the "experimental" repository (reminder:
there is stable, testing, unstable, and... experimental) and so are not
"ready" for public use, but they work like a charm, so I think it's worth
mentionning that there will be libreoffice available from official debian
repositories soon.

However, like with Ubuntu, I don't know if they will replace openoffice or
coexist. But I believe that being available is more important.

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] more errors, libreoffice on amd64 debian, starts now but immediately aborts.

[Cley Faye]

>
> I haven't tested LibreOffice Debian AMD64 yet but I have tested both
> Trisquel and Ubuntu on 64-bit without such problems. Now that the
> problem seems solved, can someone summarize (if any) the differences
> between this and the usual (manual) install instructions ?
>
> If there is anything that specifically works for Debian now I'd like to
> document it properly for others to test too.
>


Aside from my own tendency to push for the official repository, it seems
that the main issue this time was an old preference folder in
~/.libreoffice, so a new install using the debs from the libroffice website
should go smoothly anyway.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with rc on Windows 7

[Cley Faye]

2011/1/14 

>
> I was running rc1 on Windows 7 with no problem. However both rc2 and rc3
> crash during launch giving an error: "The application cannot be
> started. [context="user"] caught unexpected exception!" . There's a bug
> report (32133) from early December, but no action on it.
>
>
> The problem occurs on a 64-bit W7 machine. I have no problems running on
> 32-bit or 64-bit Linux machines.
>
>
> Has anyone seen this problem? How to fix or troubleshoot?
>
>
>
I had no such issue running the RC2 on a 64-bit windows 7 system (I've yet
to try the RC3).

For a start, you should try to delete/rename your libreoffice configuration,
in your windows profile, uninstall, reinstall, and check if it still happen.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with rc on Windows 7

[Cley Faye]

I've installed for All Users and it worked fine.


2011/1/14 

> Did you install for a single user or all users?
> P
>
>
> - Original Message -
> From: "Cley Faye" 
> To: users@libreoffice.org
> Sent: Friday, January 14, 2011 2:39:33 PM
> Subject: Re: [libreoffice-users] Problem with rc on Windows 7
>
> 2011/1/14 
>
> >
> > I was running rc1 on Windows 7 with no problem. However both rc2 and rc3
> > crash during launch giving an error: "The application cannot be
> > started. [context="user"] caught unexpected exception!" . There's a bug
> > report (32133) from early December, but no action on it.
> >
> >
> > The problem occurs on a 64-bit W7 machine. I have no problems running on
> > 32-bit or 64-bit Linux machines.
> >
> >
> > Has anyone seen this problem? How to fix or troubleshoot?
> >
> >
> >
> I had no such issue running the RC2 on a 64-bit windows 7 system (I've yet
> to try the RC3).
>
> For a start, you should try to delete/rename your libreoffice
> configuration,
> in your windows profile, uninstall, reinstall, and check if it still
> happen.
>
> --
> Unsubscribe instructions: E-mail to 
> users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
> --
> Unsubscribe instructions: E-mail to 
> users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Printing at 80% with LibreOffice on MacOS X

[Cley Faye]

2011/1/18 Christian Oïhénart 

> Hi,
>
> As in OO, it¹s still not possible to fix format of printing (paysage or
> portrait, scale of printing), the command is not available. In NeoOffice,
> when we choose ³Paramétrages de l¹imprimante² (in english perhaps Options
> of
> Printer), the first window which appears allows to fix format of printing.
> Would it be possible in a next build ?
>

I can't test it myself (don't have a mac), but I remember in some older
discussions about a setting that would allow to use the system printer
dialog instead of LibreOffice one... maybe you should look for that.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Can't save to .doc or .docx

[Cley Faye]

2011/1/19 Olwe Melwasul 

> I just installed LO3.3 from Ubuntu repo on Ubuntu 10.04. I followed the
> instructions at
>
> http://drupal.txwikinger.me.uk/content/libreoffice-now-available-ppa-ubuntu-1010-and-1004#comment-620
>
> Install went fine. I pull up a document in Writer, but can't seem to save
> it
> as a .doc or .docx. However, .odt saves work.
>
>

Can you be more precise ? the format doesn't appear in the file format list,
or does it crash when you save ?

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Fatal Error on DOCX file

[Cley Faye]

2011/1/21 Eduardo Cuomo 

> This file cause LibreOffice close inmediatly, without message about the
> error or cause.
> (I Speak Spanish really! Sorry!)
>
>
Hi,

Attachement will not show on the list; use a file hosting service to send
files.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Macro recorder option grayed out in menu

[Cley Faye]

2011/1/24 Gianluca Turconi 

> Hello *,
>
> I'm back using LibO RCs after a couple of months and I've seen that the
> macro recorder option is grayed out in the menu of my installation (Windows
> Vista HE).
>
> Is it normal? How can I enable it?
>
>
If i remember correctly, you can enable it by checking the  "enable
experimental functionality" in options->LibreOffice->General (not sure about
the exact name since my install is in french, but you should find it
easily).

As stated, it's not stable, so keep it in mind if you heavily depend on
this.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Desktop icon

[Cley Faye]

2011/1/25 Andy Brown 

> On Tue Jan 25 2011 11:43:49 GMT-0800 (PST)  Luuk wrote:
>
>>
>> On 25-01-11 20:38, J Huntemann wrote:
>>
>>> You can delete the desktop shortcut as well. Rite click select delete.
>>>
>>>
>> But the question remains
>> *WHY* was it put there in the first place?
>> Because i know i can delete it ;-)
>>
>>
> Would you rather it be hidden deep on the hard drive somewhere that you can
> not find it to delete it?  Where would you suggest that it be placed?
>


The desktop shortcut is pretty standard, and can be avoided with a checkbox,
but the installation folder, where the installer inflate itself to really
install the app could be located in the temp folder, and deleted after
installation; at least on windows it's the most usual way to install
software, instead of dropping the installer on the desktop.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Desktop icon

[Cley Faye]

2011/1/25 Luuk 

>
>
> On 25-01-11 21:58, Cley Faye wrote:
> > 2011/1/25 Andy Brown 
> >
> >> On Tue Jan 25 2011 11:43:49 GMT-0800 (PST)  Luuk wrote:
> >>
> >>> On 25-01-11 20:38, J Huntemann wrote:
> >>>
> >>>> You can delete the desktop shortcut as well. Rite click select delete.
> >>>>
> >>>>
> >>> But the question remains
> >>> *WHY* was it put there in the first place?
> >>> Because i know i can delete it ;-)
> >>>
> >>>
> >> Would you rather it be hidden deep on the hard drive somewhere that you
> can
> >> not find it to delete it?  Where would you suggest that it be placed?
> >>
> >
> > The desktop shortcut is pretty standard, and can be avoided with a
> checkbox,
> > but the installation folder, where the installer inflate itself to really
> > install the app could be located in the temp folder, and deleted after
> > installation; at least on windows it's the most usual way to install
> > software, instead of dropping the installer on the desktop.
> >
> And the checkbox, to put the icon on the desktop, should default to NOT
> checked.
>
> I mean, 99.999% of the time when i do something with 'office', its an
> attachment i open directoly frm mail, of a document from the 'my
> documents'folder.
> Almost NEVER do i need to check the 'start menu' fro a link to start
> 'office/writer' to create a new document


The default state of the checkbox is more open to discussion; personnaly,
I'd agree with the default being not checked, because I usually can't reach
shortcuts on my desktop anyway; but there is a (probably large?) part of the
user that are somewhat lost when their favorite applications are not
available directly on the desktop, and those users tend to be less attentive
during installation (if they are doing them at all).

All in all, it all come down to a minor annoyance, that is unchecking a box
one time only (unless the icon is added back on update, I don't remember the
behavior we had before about updates).

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] LibreOffice not matching other windows

[Cley Faye]

Libreoffice does not use qt, so it's normal that it don't follow your system
settings. There is a libreoffice-kde package on debian to do this; maybe
there is an equivalent thing available on opensuse.
Le 26 janv. 2011 01:00, "Wolf"  a écrit :
> I just installed LO 3.3 on OpenSUSE, running KDE 4.4.4. The
> LibreOffice window does not follow the colour scheme I've set up for
> KDE --- I have everything set to be moderately dark, and LO is very
> bright white. I can't find anything under Options -> General ->
> Appearance to change it (application background only changes the
> background of the area that actually displays the document). How do I
> get it to look right?
>
> Thanks
>
> --
> Unsubscribe instructions: E-mail to 
> users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] LibreOffice not matching other windows

[Cley Faye]

2011/1/26 Wolf 

> Well, there's a detail I'd have liked to know before installing.
>
> The only package like libreoffice-kde I could find was in the unstable
> repositories and it wanted to break dependencies.
>
> Thanks for your time. Back to OOo for me.
>
>
Well, in Debian last time I updated it pulled stuff from experimental... The
LibreOffice release is relatively recent, you should give it some time.

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Desktop icon

[Cley Faye]

2011/1/26 Tom Davies 

> Hi :)
>
> If you are using Firefox as your web-browser then try clicking on
>
> Tools - Preferences - Main (or General)
>
> About halfway down the page is a browse button to help you choose where to
> setup
> a "Downloads" folder.  In Windows i tend to create a new folder in "My
> Documents" and rename the new folder to "Downloads".
>
>
I think the issue was more related to the installation folder created BY the
installer on the desktop, not the downloading of the installer itself :)


-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Help File

[Cley Faye]

2011/1/26 crl64 

> >From my own experience, word processors that try to detect which language
> you're in always get it wrong. Defining user requirements is quite
> difficult. I suppose one solution would be to indicate which languages are
> in use in Document Properties. Another would be to have a way to set the
> language of each paragraph.
>
>
Well, as far as I can tell, you can choose language for paragraph, or even
for selection, on Tools>Language (or something like that, my UI is in
French). It seem to affect at least the spell checker, which is enough for
my use anyway.

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] horrizantal ruler measurement in pixels instead of mm,cm,inch

[Cley Faye]

2011/1/27 arun kumar 

> yes,but my blog's post-body width  always remains same  because the
> template is designed like that. What i'm trying to tell you is that i
> want to set the ruler to be in the same measurement  of pixels. Almost
> every webpage or blog template  has pixels as units. Unfortunately we
> dont have pixels scale in Libre Offfice .
>
> I think we should have the pixel scale because we have an option of
> HTML document in the File>New>.
>
>
The thing is, good design practice tend to avoid doing things with pixel as
the measurement units, for the reason explained in this thread.
For example, if your display is set to a specific DPI, having a pixel
settings in libreoffice would allow you to set the text exactly like you
want... but if someone browsing your website have another settings, your
text will be all off for this user.
For those reason i don't think it make much sense to add a "pixel" unit in
LibreOffice, as it will be dependant of a given DPI setting anyway. For your
issue, you might want to either translate your "pixel" settings in cm (or
anything) while editing the document, or properly design your site to use
those unit instead of fixed pixel settings...

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Software problem

[Cley Faye]

Hi,

This is more like a Windows and browser issue than an libreoffice issue, so
this list is not the best place to look for advice.

Anyway,
Usually, this mean that your browser couldn't save the file in it's temp
folder; check that you have enough space, and also check for an over zealous
AntiVirus that could prevent download of big executables.
Le 27 janv. 2011 23:26, "John Deveraux"  a écrit :
> Hi,
>
> Please add me to your mailing list, I have a problem I would like to post
>
> Has anyone said they have had this happen when trying to download your
> software.
> When download your software
> LibO_3.3.0_Win_x86_install_multi.exe<
http://download.documentfoundation.org/libreoffice/stable/3.3.0/win/x86/LibO_3.3.0_Win_x86_install_multi.exe
>215
> MB, I keep getting
>
> C:\Documents and Settings\David Hoffman\My
> Documents\Downloads\LibO_3.3.0_Win_x86_install_multi(2).exe could not be
> saved, because the source file could not be read.
>
> Try again later, or contact the server administrator.
>
> Any advice?
>
> Thanks,
> John
>
> --
> Unsubscribe instructions: E-mail to 
> users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] welcome window bug

[Cley Faye]

2011/2/1 kranthi.t2000 

>
> Hi guys,
> Libreoffice welcome screen has a bug as you can see
> is there anything that we can do?
> http://nabble.documentfoundation.org/file/n2395681/llibreoffice_bug1.png


That looks more like a compositing/window manager issue than a LibreOffice
issue... Have you tried disabling any advanced stuff (like compiz or kde
desktop effect) ?
Also, if you're using the libreoffice-kde integration package, try without
it to see if the issue remain...

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Windows bug? Opening OTT does not create new document.

[Cley Faye]

2011/2/1 Neil 

> No idea whether this is the right place to report this, but I have had a
> search to see if this bug has previously been reported and not found
> anything.
>
> Double-clicking on a OpenDocument Text Template (OTT) in windows opens the
> template file rather than creating a new document based on the template.
> I am running LibreOffice 3.3.0 OOO330m19 (Build:6) on Windows 7. The
> template in question is one I created and is nothing fancy, just has some
> sub-headings in it.
>
>
Well, unfortunatly my windows install is old (build:3), but at this point,
it did create a new document based on the template when you double-click an
OTT file.
Maybe at some point file associations were modified in your windows install
? Try right-clicking on the OTT file to see if there is a "New" option, or
only an "Open" option. On my system I have both, and "New" is the default.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Windows bug? Opening OTT does not create new document.

[Cley Faye]

2011/2/2 Neil 

> Right-clicking on the file does display a 'New' option as well as 'Open'
> but
> it defaults to 'Open'. How do I go about changing the default behaviour?
>
> Thanks for your help and quick responses.
>
>
You can change file associations using the windows control pannel. However,
this part got really dumbed down in windows vista/seven. On this page is the
procedure to follow, as well as another little program that seem closer to
what we had in XP, letting you choose easily the default action:
http://www.winvistaclub.com/t19.html

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Windows bug? Opening OTT does not create new document.

[Cley Faye]

2011/2/2 Luuk 

> In stead of installing this extra software, i DO want this in standard
>  Windows.
> I'll post a squestion on a microsoft-forum...
>


Well, if you find out how to get the old dialog (from XP) back in Seven,
please tell back. It worked well and was easy to use; maybe it was too much
for windows :(

-- 
Cley Faye
http://cleyfaye.n <http://cleyfaye.net/>et

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Windows bug? Opening OTT does not create new document.

[Cley Faye]

It's never a good idea diving through the registry when there is a frontend
for it, even if it's badly done. The link I gave you to alter the default
choice with windows control panel is not optimal, but I think less
hazardous.

-- 
Cley Faye
http://cleyfaye.net


2011/2/2 Luuk 

>
> Because after looking into this problem, i had the same problem on my
> Windows7 computer,  thought well it should be easy to solve by
> uninstalling/installing LO But that did not work
>
> So i dived into REGEDIT   . (of course obeying the rules Microsoft has
> for this)
>
> After a lot of .time i did find a key which is the cause of this
> problem.
>
> It can be show on the commandline when doing:
> REG EXPORT
>
> HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.ott\UserChoice
> ott.reg
>
> When you get an error like this:
> "ERROR: The system was unable to find the specified registry key or value."
> you should not have this problem
>
> The file "ott.reg" is a backup of the piece we are going to delete:
>
> Easiest way to delete this key was via REGEDIT
> (other option gave "ERROR: Error accessing the registry."
>
> Start REGEDIT
> Find the key where HKCU is HKEY_CURRENT_USER
> Whith "UserChoice" selected, press the Delete button, and confirm deletion.
> Close REGEDIT
>
> double-clicking on an .ott-file should now open a new document based on
> that
> template.
>
>
> -
> Windows7 / LibreOffice  3.3 330m19(Build:6)
> --
> View this message in context:
> http://nabble.documentfoundation.org/Windows-bug-Opening-OTT-does-not-create-new-document-tp2396899p2406508.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> Unsubscribe instructions: E-mail to 
> users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Windows bug? Opening OTT does not create new document.

[Cley Faye]

2011/2/2 Luuk 

>
>
> On 02-02-11 17:32, Cley Faye wrote:
> > It's never a good idea diving through the registry when there is a
> frontend
> > for it, even if it's badly done. The link I gave you to alter the default
> > choice with windows control panel is not optimal, but I think less
> > hazardous.
> >
> maybe i would have looked at it if you posted this link:
> http://types.sourceforge.net/
>
> and not:
> http://www.winvistaclub.com/t19.html
>
> But i hate it to install another tool for something which i use rarely,
> that should be possible with standard tools in Windows.
> and, of course that might not be the easiest way ;)
>
>

The third-party tool is only the second option on the link I gave you (which
I shamelessly stole from google search :D). The very same page describe how
to do it with only the windows control panel, although it's quite harder to
do than in XP, it's still possible. That was the point of my last message.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Question

[Cley Faye]

>
> > After the install on WinXP I ran the Help files installer supposedly
> > successfully. My problem is that I cannot for the life of me figure out
> how
> > to get the offline help to work. F1 or the Help menu always brings up the
> > online help. I am not always connected to the Internet so getting the
> offline
> > help working is important to me. I've spent quite a bit of time searching
> for
> > answers online, but with no joy. Have I just overlooked something simple?
> > Thanks for any help anyone can give.
>
> Which version did you install? Did you also install the corresponding
> language pack? If I remember correctly, you have to install
>
> 1. software package
> 2. language package
> 3. help package
>
> In this order.
>
> I agree, that this is unfortunate. I don't know, if this is well explained
> on the download page or not. If not, it should be added there, so that the
> user doesn't get a "surprise" of a not working local help.
>
>
Also, be sure that Libreoffice language settings are set accordingly, or it
might not try to pull the corresponding local help file.

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Font embeding

[Cley Faye]

2011/2/5 Hane Tsukasa 

> Hi there!
>
> It seems to be a question which has been talked about for a long time in
> the days of Openoffice. That is, could it be possible to embed the Truetype
> fonts used in a document(esp. Writer/Impress) when we save the file?
>
> Personally I think it's a very practical and useful funtion. A
> fantastically formatted document could turn out to be nothing at all when it
> is opened on another machine that doesn't have certain fonts installed.
>
> I don't think this function may lay a finger on the issues of copyright.
> The Microsoft Office has done so in their counterpart product.
>
> So, could the function be implemented in future release? Many thanks.
>

I don't know how it's done in MS office, but this will most likely raise
issues for some fonts that are not free. Sometime, you only have a license
to use a font to produce a document, and not redistribute it; embedding it
in a document might become a big issue in this case, no ?

-- 
Cley Faye
http://cleyfaye.net

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Open pps as ppt

[Cley Faye]

If it's working as originally intended it wouldn't classify as a bug, but it
can be a good feature request, to add another switch to open them in editing
regardless of the extension.
Le 10 févr. 2011 16:15, "David Griffiths"  a
écrit :
> Charles Marcus  Media-Brokers.com> writes:
>
>>
>> On 2011-02-10 5:41 AM, Mihai Dobrescu wrote:
>> > From: Mihai Dobrescu  gmail.com>
>> >> On Wed, Feb 9, 2011 at 11:15 AM, David Griffiths <
>> >> dave.griffiths62  gmail.com
>> >>> wrote:
>> >>> Mihai Dobrescu  gmail.com> writes:
>>  I have installed OpenOffice about two years ago. I don't
>>  remember hoe I set it to open .pps files as they were .ppt. How
>>  could I get that in my brand new LibreOffice - to open .pps
>>  files in edit mode instead of running the slideshow and without
>>  changing the extension?
>>
>> >>> If you rename the file from .pps to .ppt it opens for editing in
impress
>> >>> without
>> >>> issue.
>>
>> >> HI :) Have you tried the obvious
>> >> 1. just double-click on the file
>> >> 2. Right click and choose "Open with ... " (might be in "Properties"
>> >> on that right-click menu) and choose LibreOffice or Impress in there
>> >> 3. In LibreOffice's Impress go up to the menus and click on
>> >> File - Open and navigate to the file.
>>
>> > Yes, I did. It plays the presentation, then closes.
>>
>> Just change the extension from .pps to .ppt...
>>
>> Also, please don't top-post in an already bottom/inline posted thread,
>> it totally screws up quoting...
>>
>
> Hi Charles,
>
> I already suggested this a while ago to Mihai, but he does not want to
> change the extension. The man page for LO suggests that the -show
> option should play the slideshow then revert to editing. I tried today,
> but it only plays the slideshow, then closes the application. In your
> opinion is this a bug that needs raising? Personally I have no issue
> with changing the extension, it works :-)
>
> Best regards
> Dave
>
>
>
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Website security and encryption

[Cley Faye]

2016-08-22 1:57 GMT+02:00 Eric Scherer :

> I'm amazed and surprised none of your webpages -- including the downloads
> -- are via secure/encrypted connections ("https://"; or otherwise).
>
> There's absolutely no reason ANY website should be doing this.
>
> I refuse any site, not to mention download anything from them, if
> connections aren't secure and encrypted.
>
> BIG oversight on your behalf.
>

​The libreoffice.org website is served through both http and https.​

For what it's worth, I doubt it's an oversight at all: in some
circumstances, people can have difficulty to access websites through TLS
connections (sadly). Still, the secure alternative is available. In fact,
the first answer in google for "libreoffice" is the https version.

Keep in mind that using https by itself just mean that the server's
identity is verified by a third party and that the connection isn't
tampered with. The trust to give to this "third party" is another matter :)

-- 
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] Website security and encryption

[Cley Faye]

2016-08-22 23:11 GMT+02:00 Paul Steyn :

> As all the information is being downloaded, and not uploaded, and is
> publicly available, there is no security from the encryption; anybody
> can get the same data you are accessing. The verification of the domain
> is useful, but does still rely on trusting the DNS servers. The download
> itself can be verified through other, better means to ensure it is good,
> although this does again rely on the website not having been hacked,
> which https does nothing to ensure.
>

​HTTPS does some stuff to make the download safer: assuming the server's
private key itself was not accessed by an attacker, AND assuming the third
party certificate authority didn't issue a bogus certificate.
In that case, we can reasonably think that what is shown accessing
https://libreoffice.org really originate from libreoffice.org. This
includes the files and the hash fingerprints provided as a way to check the
downloaded files.
One could argue that the download themselves could be served over HTTP for
efficiency, and only the hashes needs to go through HTTPS, but pushing
everything through TLS is not that troublesome.

Of course, we assume that some bases are correct. And that's ignoring other
ways of attack: corporate "nosey" decrypt-all routers, ​user accepting
invalid certificates, browser hijacking, etc.
All in all, providing HTTPS access with a verified certificate does add
something, even for a public project that only provide files to the users,
but it's not completely secure just because of the https green thingy.


> PS. I find the tone of the message to be a little strong,
>

​Agreed.​

-- 
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] LibreOffice on a Chromebook?

[Cley Faye]

2016-08-25 20:07 GMT+02:00 Kevin O'Brien :

> I have been thinking about getting a Chromebook, but the one thing
> holding me back is that I need to be able to run LibreOffice. Is that
> something I can do now? And if so, how well does it run?
>

​Unfortunately, I can't speak exactly about how LibreOffice behave on a
chromebook, but it is possible to have LibreOffice run on it through
various mean. In my opinion, a good way to do so is by using "crouton",
which allow running a full Linux on top of ChromeOS (at the same time, not
in a dual-boot setting). Obviously this can be leveraged to run LibreOffice.

One thing to keep in mind is that some chromebook have very limited disk
space available, so you may want to change that.

-- 
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] F-Droid

[Cley Faye]

2016-10-04 0:31 GMT+02:00 toki :

>
> > therefore why is it up to LO users to update their directory.
>
> F-Droid only lists FLOSS that specifically requests to be included. One
> of the few responsibilities of the requester, is that both app updates,
> and program descriptions are kept current.
>
> As such, it is legitimate to ask why the app has not been updated at
> F-Droid.


​There's nothing on the F-Droid page for the viewer or in the submission
thread that indicate submission from the LibreOffice​ foundation. As far as
I can tell, it was submitted by someone at Collabora, who isn't there
anymore.

-- 
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] Libra Office and MS Word compatibility query

[Cley Faye]

2016-10-17 16:07 GMT+02:00 Tanstaafl :

> On 10/15/2016 7:02 AM, toki  wrote:
> > For my part, I point blank refuse to use MS Word (any version), because
> > it is completely, utterly and absolutely incompatible with itself (the
> > same version but on a different computer)--- to the point that they
> > might as well have been written by two different companies, with
> > different development teams.
>
> While I would agree there can be problems - sometimes big ones, between
> *different* versions of Word (or Excel or Powerpoint), I call BS on your
> the above. It simply is not true.
>
> FUD like this does nothing to help with the spread of open file formats.
>

​While the initial statement is exaggerated, moving a file between two
computers using the same version of MSO can produce different results, with
no obvious reasons. Of course after digging enough an explanation can be
found, but I've seen it happen often enough to be noticeable. This was in
the beginning of the docx format, but I would not be surprised if things
didn't change much in it's ~10 years of existence.

-- 
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] libreoffice developers please answer my question about security!

[Cley Faye]

2016-10-18 15:38 GMT+02:00 nasrin khaksar :

> does it mean that libreoffice which is one branch of openoffice, is
> extremely secure and it does not have any security Vulnerability to
> fix in the every new release version?
>

​No. As stated by others, LibreOffice and OpenOffice are two different
project, even if they share the same origin, and as such do things
differently.
Regarding vulnerabilities, they exist and get fixed, but these fixes are
just part of the regular development of the project. No need to highlight
them, except for some rare cases (I might be wrong, but some times ago such
issue was raised and discussed, I believe).



> all versions are the same in security and its no different which
> version i desire to use. is it true?
>

​Absolutely not. In fact, It is false for a lot of project. Security fixes
are part of a project, and are integrated in each new versions. Except for
projects that maintain a LTS version (or similar), backporting security
fixes​ to older releases is resource intensive. Some linux distributions
that maintain LTS versions of their releases might work on backporting
security fixes to older LibreOffice version, but it is dependent on them.


> i use and wish to use 4.4.6, is it completely secure like the oldest
> and newer versions?
>

Nope. Since older versions are not maintained, if a vulnerability is found
in a newer version it might affect older versions. It is recommended to use
either the latest version, or a long-term support one, as they are the only
one that are sure to get all security updates.

In general, there is little to no incentive to use older versions: newer
versions should not go back in term of functionalities, and get a lot of
bug fixed (not only security ones). If you have a specific issue with newer
version, it might be interesting to get it fixed instead of using an old,
insecure version.

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