Re: [libreoffice-users] Newbie help needed please.

[Cley Faye]

Le lun. 23 juil. 2018 à 04:23, Diamondblack  a
écrit :

> I am a complete novice and I do not want to come on the forum and upset
> anyone with such a simple task.
>
> I have Downloaded and installed LibreOffice 5.4.7.
>
> I have two PDF Files and all I need to do is change the text and I can not
> ever work out how to do a simple edit.
>
> All I have to do is change 2017 to 2009 on the first PDF file and change
> 1967 to 1959 on the other PDF file.
>

​Hi,

For that kind of changes LibreOffice might not be your best option.
You should look into InkScape (it's also free software: ​
https://inkscape.org/en/ ). It can open PDF file with much more fidelity
than LibreOffice and allow very simple text changes (just double-click on
the text you want to edit).

LibreOffice is more of an authoring tool, and as said by others PDF is
*not* a format designed to be easily editable.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Failure: repeated attempts to unsubscibe

[Cley Faye]

2018-06-06 16:13 GMT+02:00 :

> Hi all, I've attempted to unsubscribe my father repeatedly, following the
> instructions at the bottom of each email -to no avail. Message says there
> is no user called "unsubscr...@global.libreoffice.org".
>
>
>
​Hi,

You have to send an email to the following address:
users+unsubscr...@global.libreoffice.org

You need the whole users+unsubscribe. Pay extra attention to the plus sign,
and make sure your email client isn't interpreting it as something else,
but really send the email to that exact address.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] embedding fonts?

[Cley Faye]

2018-04-20 1:33 GMT+02:00 Tim-L :

> How to make specific fonts embedded into the .odt file that has been
> exported to a PDF file.
>
>
​This point is not clear. Do you want to embed fonts in a PDF (easy-ish,
see later) or in a ODT that is itself embedded in the PDF (as far as I
know, not feasible right now)?​



> So, how do you make sure Export to PDF will embed the needed fonts for all
> your specific fonts needs?  I do not want to uninstall the fonts buried and
> protected in some system folder, or use some package like Synaptic Package
> Manager. I cannot go to my systems and play a game with my installed fonts
> every time I need to use a new one.
>
> This may be a simple answer, like it is no issue at all anymore, but I
> need to make sure.


​From recent discussions on either this list or the french one, subsets of
required fonts should be automatically embedded into a PDF export EXCEPT if
the font file explicitely sets a flag to not be embeded. It is something
font specific and made to accomodate licensing issues. That's why there are
no option to actually embed fonts. Some viewers (okular comes to mind)
allows you to easily know what is embedded in the PDF and what isn't.​

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

Re: [libreoffice-users] video issue -- thinking out loud and could do with help please

[Cley Faye]

2017-11-09 10:02 GMT+01:00 Mike Scott :

> OK. I'm well out of my depth, but this problem has been around too long
> unfixed and it needs fixing. If I 'think out loud' here, maybe others could
> chip in? Sorry this is a bit lengthy.
>
> The problem: a video on an Impress slide starts and finishes with an
> inappropriate frame displayed. I've made a series of test videos, the
> frames simply containing the frame number from 0N-1, and in a selection
> of formats (.mp4, .flv and ".avi") using avconv. I then embed that video
> into a slide using Insert|Audio or Video.
>
>

> A placeholder frame from the video is displayed during editing. This is a
> frame from within the video, but it isn't always the same one.
>


> The big deal-breaker is that this placeholder frame is shown during the
> slide show when the slide appears and before the video plays (a long time
> if there's a slow transition), and also when the video has finished. This
> means at the very least an annoying flicker at the start, and a usually
> totally inappropriate ending.
>


> Sorry that's so long, but I think the symptoms need documenting somewhere.
> Any thoughts at all would be most welcome - thanks.


​Some thoughts about this.
Inserting video is finicky. At least your problem isn't that it randomly
stop working sometimes or that some formats are unsupported. These two
issues alone pushes a lot of people to simply have their video file at hand
during presentation, and switch to that instead of embeding it, which in
turns means that less people embed video, so issues are harder to diagnose,
etc.

About the thumbnail: on most of my (not so thorough) tests, LibreOffice
always showed the first frame as the preview, so it was not an issue. My
version is 5.3.1.2, but I'm afraid the preview picture is more a matter of
OS and media package than LibreOffice itself.
An "immediate" solution would be to surround your slides with video, with
slides with static images and no transition.

Here's what I did:
- Create a presentation with three slides: dummy1, video, dummy2
- Have long transitions on them. This shows that going from the video slide
to the dummy2 slide, the video preview image (in my case the first image of
the video) shows during the transition, which is not good
- Add a slide after the video with no transition. Place a capture of the
video's last frame at the exact same place the video should be (using
placement properties it's quite easy, even if tedious)

This way, when I move to the next slide after the video, the transition
looks smooth. I suppose the same thing could be done before the slide to
show the correct first frame in every case. One last issue I found there is
that the video flicker slightly when it starts playing; again, this is
probably OS/Library dependant.

This is obviously not an ideal solution. Ideally, you could specify on
which frame/timestamp the video should initially be, or simply just always
display the first frame one entering, and the current frame on exiting the
slide. Maybe there's even a suggestion about this, but obviously it' not
high priority since it's been around for so long.

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

Re: [libreoffice-users] encryption Q

[Cley Faye]

2017-10-31 22:00 GMT+01:00 John R. Sowden :

> which encryption algorithm is used by Libreoffice?  Neither Libreoffice
> nor Google seem to be my friend.
>
> Is it different by OS?
> Is it different by type of file (write, calc, etc?)
> Can the base databases be encrypted, like a calc file?
>

​Aside from reading the source code, a good place to look would be the
specification of the file format; for example:

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part3.html#__RefHeading__752811_826425813
https://en.wikipedia.org/wiki/OpenDocument_technical_specification#Encryption
​
Reading more of these would probably provide an answer about the database
files.

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

Re: [libreoffice-users] Which was the last version of LO able to run on Win XP?

[Cley Faye]

2017-10-13 14:41 GMT+02:00 DaveB :

> Please let's not have discussions about MS having ended support for XP.
> There are still an enormous number of machines out there running XP SP3
> POS Ready 2009, which MS are still actively supporting. MS most recent
> XP update (October 2017) added support for TLS 1.1 and TLS 1.2 to XP POS
> Ready 2009, See Microsoft Secure Blog: http://bit.ly/2ylRGDo
>
> I have successfully screwed up LO on a client's XP POS Ready machine (my
> fault for not testing on a VM first), by installing LO 5.4.2 over the
> previous 4.4.7.2 install. The 5.4 installer completes without any
> complaint, gleefully removing the old version, but on start up the
> splash screen flashes and soffice dies without a murmur. Would have been
> nice if the devs had added the very simple system check call to
> installer and blocked the install. Yes, the information is there for
> anyone who wants to dig down into the release notes:
> http://bit.ly/2yjj2Ir But how many users read software release notes or
> EULAs? It's also about time we updated the misleading "/System
> Requirements/" page http://bit.ly/2yh0SHo which still reads
> "/LibreOffice on a Windows system are as follows: Microsoft _*Windows
> XP*__*SP3*_, Vista, Windows Server 2008, Windows 7, Windows 8, Windows
> Server 2012, or Windows 10/".
>
> Two questions:
>
>  1. Which was the last version able to run on Win XP?
>  2. Are there any known security issues with that version?
>

​After a quick test, I found that the 5.3.7.1 version works fine in XP​.
The latest 5.4 doesn't, but I'm not sure exactly which subversion started
to fail. I can confirm however that it doesn't output any error message,
neither on the GUI or on the command line. The splash screen just flash. No
error or warning in system logs either.

The website should probably be updated (or, if possible, the issue causing
a crash fixed instead). I'm tempted to say that losing XP compatibility
wasn't done on purpose.

I can't provide an answer for known security issues, although common sense
says that it's more likely to have some (there's always security issues)
and that they might be fixed in more recent versions. However, not talking
too much about the end of support of XP, it is itself a large attack vector
at this point, so I'm not sure that obscure security issues with
libreoffice would be relevant. Beyond the usual "disable script by default"
advice, it's most likely safe enough to use in such conditions.

-- 
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] Calculating the Nth weekday of a month.

[Cley Faye]

2017-09-28 14:31 GMT+02:00 Michael Tiernan :

> Instead of my breaking my neck trying to figure it out, I thought I'd ask.
>
> Has anyone come up with a macro/formula/method for deriving the date
> (-mm-dd) of the Nth weekday of a month?
>
> Example:
> The second Tuesday of each month of 2017 would be:
> 2017-01-10
> 2017-02-14
> 2017-03-14
> etc.
>
> Thanks for your time in advance
> ​.
>

​This would probably be trivial using macro, but I think writing macro in
LibreOffice isn't​ as fun as it could be.
If you can spare some spreadsheet cells, the following method should work.
I didn't check every details but the general idea sound correct.

The "second X of each month" can only fall between day 8 and day 14.
Similarly, each weekday happens only once in this interval (as long as a
week is 7 days long…). One can use the WEEKDAY() function to determine
which day is a given date, and using seven rows and twelve columns, one can
get a matrix of weekdays for the "second weekdays" of each month.
Once this is done, using VLOOKUP() and an extra column for the actual
result, it is possible to look for occurence of a specific weekday and
return the day of the month associated with it.

This is roughly implemented in the following file:
http://www.cjoint.com/c/GICneLdQnUI

First sheet display all the intermediate values, second sheet shows only
the result.

I often end up using a few cells together and just hide them, it allows
some pretty fun stuff to happen.

-- 
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] "sudo apt-get purge libreoffice-gtk " ????

[Cley Faye]

>
> I suspect that the gtk stuff is the integration stuff that used to have to
> be installed separately for the right-click menus to have more relevant
> options and to make the window decorations look more like the rest of your
> OS.
>
>
>
​It's exactly that: it provides gtk look This change the visuals for
menu, borders, buttons, etc. to match your current gtk theme. It might also
provide a few different dialog boxes (especially the open/save dialogs).
There's also a libreoffice-kde package, that does the same but for KDE. If
none of these package are available, LibreOffice will still work but really
look out of place on most DE.​

-- 
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] convert xlsx to CSV

[Cley Faye]

>
>
> So, the issue seems to be twofold.  My macro gunked up LO and caused the
> conversion to fail, and having LO open requires use of the -env option as
> noted.
>

​If something's borked in the user profile, telling LO to use another one
(or even create one for the occasion, who cares) will indeed fix the issue
:)
I've been giving this some thought; and for an automated/independant
process​ it might be better to to it this way anyway; to avoid weird
interaction with various user settings, even non-crashy ones.



>
> Wouldn't you agree the real fix is to get the LO crash fixed in which case
> my macro - buggy or not - shouldn't affect anything?
>

​Yes, that would be the best solution: not crashing, or at least providing
some output about an error​. But debugging weird interactions between such
big piece of softwate and user code might require more work than redoing
the macro a different way, unless the right guy happen to check it and
pinpoint the issue very fast :(


>
> Thanks for all your and everyone else's help & suggestions!
>
>
​Glad you got it working :)​

-- 
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] convert xlsx to CSV

[Cley Faye]

2017-08-29 12:20 GMT+02:00 A <publicf...@bak.rr.com>:

>
>
> On 08/29/2017 01:23 AM, Cley Faye wrote:
>
>> Some things seems wrong on that command line:
>>>>
>>>> - On most system you can directly call "libreoffice" instead of
>>>> providing
>>>> the full path
>>>>
>>>> Yes, but then I get /usr/bin/libreoffice since /usr/bin is in my path.
>>> /usr/bin/libreoffice is a symlink to ../lib/libreoffice/program/soffice*
>>>
>>> Note the file sizes and timestamps.  I don't know what the difference is
>>> between the two or which is correct to use.
>>>
>>> ll /usr/lib/libreoffice/program/soffice*
>>> -rwxr-xr-x 1 root root 6012 Apr 28 07:59 /usr/lib/libreoffice/program/s
>>> office*
>>> -rwxr-xr-x 1 root root 6304 Apr 28 12:36 /usr/lib/libreoffice/program/s
>>> office.bin*
>>> -rw-r--r-- 1 root root  789 Apr 28 13:32 /usr/lib/libreoffice/program/s
>>> officerc
>>>
>>>
>>> ​The "libreoffice" command/link is there to avoid issues when/if the way
>> LibreOffice is installed change. Suppose in a future release the binary is
>> renamed to loffice, you could still use the ​libreoffice command without
>> issue.
>> The "soffice" script manage some extra command line parameters and launch
>> the actual LibreOffice program; but for your purpose it should make no
>> difference using one or the other, except that directly calling stuff in
>> /usr/lib/libreoffice is not as futureproof.
>>
>>
>>
>
> I use the full path because it's the only one that gives output as you can
> see:
>
> apb@yellow:/usr/local/src/greetonix/src$ /usr/lib/libreoffice/program/soffice
> -h
> apb@yellow:/usr/local/src/greetonix/src$ /usr/bin/libreoffice -h
> apb@yellow:/usr/local/src/greetonix/src$ 
> /usr/lib/libreoffice/program/soffice.bin
> -h
> LibreOffice 5.1.6.2 10m0(Build:2)
>
> Usage: soffice [options] [documents...]
> [snip]


​Maybe THAT should be fixed before investigating further, because it should
work. This means that somehow​ libreoffice can't find it's installation
directory. It might or might not be related to your difficulties, but
there's no doubt that something's wrong here.

-- 
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] convert xlsx to CSV

[Cley Faye]

>
>
>> Some things seems wrong on that command line:
>>
>> - On most system you can directly call "libreoffice" instead of providing
>> the full path
>>
>
> Yes, but then I get /usr/bin/libreoffice since /usr/bin is in my path.
> /usr/bin/libreoffice is a symlink to ../lib/libreoffice/program/soffice*
>
> Note the file sizes and timestamps.  I don't know what the difference is
> between the two or which is correct to use.
>
> ll /usr/lib/libreoffice/program/soffice*
> -rwxr-xr-x 1 root root 6012 Apr 28 07:59 /usr/lib/libreoffice/program/s
> office*
> -rwxr-xr-x 1 root root 6304 Apr 28 12:36 /usr/lib/libreoffice/program/s
> office.bin*
> -rw-r--r-- 1 root root  789 Apr 28 13:32 /usr/lib/libreoffice/program/s
> officerc
>
>
​The "libreoffice" command/link is there to avoid issues when/if the way
LibreOffice is installed change. Suppose in a future release the binary is
renamed to loffice, you could still use the ​libreoffice command without
issue.
The "soffice" script manage some extra command line parameters and launch
the actual LibreOffice program; but for your purpose it should make no
difference using one or the other, except that directly calling stuff in
/usr/lib/libreoffice is not as futureproof.



>
> - I'm not sure the -env:UserInstallation part is needed, unless you have
>> some specific requirements
>>
>
> Yes.  I typically have LO open 24/7 with other documents.


​It should not​ matter when doing a convert-to. This command is useful if
you want to launch an instance of LibreOffice using a different place to
store your configuration/etc. You can have many document open in
LibreOffice and use the command line at the same time.



>
>
> ​- ​the \(encoded\):UTF8 part is not linked to anything, and thus is used
>> as an input filename. This is most likely not what you want.
>>
>
> Could you elaborate what you mean by not linked to anything?  This is
> probably the key to what I'm doing wrong.  To what would I link it, and how?


​The command line is parsed argument by argument. An argument is a single
string, and arguments are separated by a space.​ Sometime an argument
expect a parameter in place of the next argument. This is common practice
for command lines.

In your case, you had: --convert-to csv:Text \(encoded\):UTF8
Which mean that you have three strings: "--convert-to", "csv:Text" and
"(encoded):UTF8". "--convert-to" is the argument, "csv:Text" is a parameter
to the argument, and "(encoded):UTF8" is "nothing", meaning it is
interpreted as an input filename, so your initial command was trying to
open a file named "(encoded):UTF8".



> - the --infilter might not be needed, as xlsx files should have enough
>> informations about themselves to load properly.
>>
>
> OK, I'm all for simplicity.  But I couldn't find anything in the docs that
> specifies that, which is why I used it.  Plus the fact that all of the
> examples scattered around the Net use it, else I likely wouldn't have been
> able to decipher the docs.
> ​​
>

I was able to convert an xlsx to a csv in UTF-8 using the following simple
>> command:
>>
>> $ libreoffice --headless --nolockcheck --convert-to csv
>> --infilter=CSV:44,34,76,1 a.xlsx
>>
>
> I tried exactly as you stated  (I of course replaced with the proper file
> to convert) but for me, that had no result.  There were no messages of any
> kind, and the file was not created.
>
> infilter does refer to the source file, yes?  As my input/source file is
> .xlsx, I tried changing CSV in your --infilter, to MS Excel 97, but that
> made no difference in the result.
>
>
--infilter does not necessarily related to the input; order is important.​

It's hard to say what went wrong, but here's my own result (with
LibreOffice version):

$ ls -l

total 16

-rw-rw-r-- 1 cleyfaye cleyfaye 5374 août  29 10:05 a.xlsx

$ file a.xlsx

a.xlsx: Microsoft OOXML

$ libreoffice --headless --nolockcheck --convert-to csv
> --infilter=CSV:44,34,76,1 a.xlsx

$ ls -l

total 28

-rw-rw-r-- 1 cleyfaye cleyfaye   25 août  29 10:13 a.csv

-rw-rw-r-- 1 cleyfaye cleyfaye 5374 août  29 10:05 a.xlsx

$ file a.csv

a.csv: UTF-8 Unicode text

$ cat a.csv

"a",

"b",

,"c"

,"héhé"

$ libreoffice --version

LibreOffice 5.3.1.2 30m0(Build:2)


​There's no need for other parameters to do an xlsx->csv(utf8) conversion.​
If that simple command doesn't work, maybe there's another issue.
You could even remove the --nolockcheck if you're sure that the file isn't
open anywhere else and remove the --headless if you're not running this
command on a server, it should still work.


> The "76" is responsible for generating an UTF-8 CSV output. If that is not
>> one of your requirements, you can slim this down even more:
>>
>
> I do in fact prefer UTF-8 CSV output.
>
> ​
For information, the "44,34,76,1" thing come from this page (the CSV part
is still applicable to LibreOffice):
https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options
​

-- 
To unsubscribe e-mail to: 

Re: [libreoffice-users] convert xlsx to CSV (and utf8?)

[Cley Faye]

2017-08-29 9:40 GMT+02:00 A :

> Thank you.  I may end up doing that, but I'm trying to avoid it. I picked
> one direction (before I knew about unoconv) and I want to see it through to
> the end.  It's supposed to work.  I may be forced to revisit this solution
> if all else fails.
>
>
>
​Out of curiosity, did you try with my solution? Or did I miss something?​

-- 
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] convert xlsx to CSV

[Cley Faye]

2017-08-28 2:59 GMT+02:00 A :

> I'm trying to convert a file from .xlsx to CSV.  After googling until my
> eyes were bleeding, the below is the best I could come up with.  I've tried
> various incarnations of the below this is just the latest.  Any ideas
> what's wrong here?  The input file clearly exists.  ubuntu 16.04
> LibreOffice 5.1.6.2 10m0(Build:2)
>
> Thank you in advance!
>
> ~
>
> apb@yellow:/usr/local/src/greetonix/src$ 
> /usr/lib/libreoffice/program/soffice.bin
> -env:UserInstallation=file:///tmp/libreoffice-1 --headless --nolockcheck
> --convert-to csv:Text \(encoded\):UTF8 --infilter=MS Excel
> 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx
> Error: source file could not be loaded
> Error: source file could not be loaded
> Error: source file could not be loaded
> convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx ->
> /usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text
> Error: Please verify input parameters... (SfxBaseModel::impl_store
>  failed: 0xc10)
> apb@yellow:/usr/local/src/greetonix/src$
>
>
>
Some things seems wrong on that command line:

- On most system you can directly call "libreoffice" instead of providing
the full path
- I'm not sure the -env:UserInstallation part is needed, unless you have
some specific requirements
​- ​the \(encoded\):UTF8 part is not linked to anything, and thus is used
as an input filename. This is most likely not what you want.
- the --infilter might not be needed, as xlsx files should have enough
informations about themselves to load properly.

I was able to convert an xlsx to a csv in UTF-8 using the following simple
command:

$ libreoffice --headless --nolockcheck --convert-to csv
--infilter=CSV:44,34,76,1 a.xlsx

The "76" is responsible for generating an UTF-8 CSV output. If that is not
one of your requirements, you can slim this down even more:

$ libreoffice --headless --nolockcheck --convert-to csv a.xlsx

And if your document isn't open by someone else at the same time, you can
even remove the nolockcheck.

-- 
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] Reading from a USB device.

[Cley Faye]

2017-08-27 15:47 GMT+02:00 Marion & Noel Lodge :

> I have a Studio Logic MIDI music keyboard which I have plugged into my PC
> via a USB cable.  Windows has automatically installed the appropriate
> driver/s.  I am attempting to read the MIDI input from the keyboard as I
> want to see if I can use a Macro to modify the sound before it goes to the
> speaker.   (Actually I want to try to programmatically mix sine waves like
> a Hammond Organ does - it may not be possible, but I'd like to give it a
> try!)
>
> I installed a trial version of Device Monitoring Studio,   see
> https://www.hhdsoftware.com/device-monitoring-studiowhich enables me
> to
> trap the raw data from the keyboard, and I'm able to identify which keys
> are pressed or released, and also the keyboard sliders' movements and
> slider positions.  For my purposes, that is all I need to extract from the
> MIDI stream.
>
> I then went on the Web to see if I could find examples of Macro code that
> would enable my program to emulate what I had been able to do with Device
> Monitoring Studio.  It turns out that USB coding is very complex and the
> only examples I could find were in C, C++ or Visual Basic, none of which I
> have, or have ever worked with.
>
> I then had a look at LibreOffice 5.3 SDK API.  I believe that is the API
> that Base uses, and over several years I have developed a number of
> databases using macros that make calls to the API. One API service I found
> was,  com.sun.star.io.pipe,  which looks as though it might be what I need,
> but I don't know if it would work with a USB port, and I could not find any
> macro code examples that might point me in the right direction.
>
> So my questions are -
> 1.  Does anyone know if it is possible to read from a USB port using a
> LibreOffice macro utilising the API?  If so can you point me to some
> example code (preferably in Basic)?
> 2.  Failing that, is there a simple application on the market that can read
> a USB MIDI stream into a buffer or file?  I think Device Monitoring Studio
> can do that, but it is expensive and has far more features than I'll ever
> need.
>


​Maybe I misunderstood something, but I don't see how this is related to
LibreOffice in any way. While it is true that it is possible to write
applications with LibreOffice to some extent, what you're describing would
be better done using anything else​.

Using Python with libusb could work, if you're looking for something quick
to implement and don't want to dwelve in compiled languages.

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

[Cley Faye]

2017-07-09 23:58 GMT+02:00 Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net>:

> Hello Gilles,
>
> Le 09/07/2017 à 19:20, Gilles a écrit :
>
>> Hello,
>>
>> This PDF file
>> > e=LEGITEXT06074228=pdf>
>> has no Table of Contents, and I was wondering if LO could grab all the
>> headers and build a TOC.
>>
>
> In order to create a PDF with a TOC/index you'll have to set heading
> styles to the appropriate paragraphs.
>
> Opening a PDF with LibO won't go anywhere as the tool for that is Draw
> which can't set styles for a text processor.
>
> I can't see a way to do that quickly, I'm afraid: a copy/paste from the
> PDF document to Writer is possible but you'll have to fix a lot of things
> (eg. useless carriage returns) and apply heading styles by hand. On a 400+
> pages document this a big PITA.
>
> Hopefully someone else will come with brighter ideas.
>
>
>
​You want brighter ideas? Say no more!

So... hmm... I'm afraid there won't be many fully-automated tools that can
build a TOC for you. A PDF basically contains a lot of individual elements,
that are arranged to look like ​something coherent.
From the document you linked, it could theoretically be possible to write a
tool that split every pages, grab the raw text, use a regex to find actual
titles, build a TOC, and inject it in the PDF. This would assume:
- Text extraction works correctly (it's not always the case with PDF)
- Titles always follow the same format

But on this kind of document, you could definitely get some acceptable
results. I experimented a bit. The output is here:
http://www.cjoint.com/c/GGjw0OtPkGc
And for the curious, the "script" I used is here:
​https://pastebin.com/icQSZxQr

As you'll see, it is VERY specific to this document, ​but it is possible to
do something.

-- 
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] LO install demands Chrome, Slack closure

[Cley Faye]

2017-07-06 18:09 GMT+02:00 MR ZenWiz :

> I just upgraded my Win7 laptop at work from LO 5.3.3 to 5.3.4, and it
> insisted I close my Chrome and Slack apps.
>
> Why is LO messing with Chrome and Slack settings?
>

Windows installer asking you to close some applications does not mean that
LibreOffice is messing with any settings whatsoever. It can trigger for a
variety of reason, the most common being that a shared library updated by
this install process is currently loaded by a running program. Windows
Installer detect this, and ask the user to either close the offending
process or keep going as-is and update the files after a reboot.​

Assuming you got a legit installer from the official website (to rule out
some shady providers) I don't know exactly what triggers this behavior in
your case. But it can be as simple as chrome having the Windows Explorer
DLL loaded and the LibreOffice installer updating its Explorer plugin.

-- 
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 creation properties.

[Cley Faye]

2017-06-13 23:41 GMT+02:00 Steve Edmonds :

> When you create a PDF in writer the PDF properties has the path to the PDF.
> Is there a way to suppress this. I am not so keen on publicising
> information on file system or server location.
>

​Hi,

Where are you seeing this exactly? After exporting a PDF with Writer, I
inspected the metadata using pdftk and there is no path information in it.
Are you sure what you're seeing are actual data in the PDF file and not
your pdf viewer showing you the actual location?​
​

-- 
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] Embedding Video Files

[Cley Faye]

2017-06-09 3:50 GMT+02:00 Keith Bates :

> Any ideas about how to make it work? Keep in mind that I have no access to
> their computer outside of my lesson time.


​Saving to .ppt will only work with a basic set of features (and I doubt
embedding video is part of it).
There's also the issue of having the mean of reading the video itself
(software like VLC will happily read anything you throw at it, WMP not so
much).

​Without more details about the installation, it's hard to say, but a good
way to make sure it works would be to:
- Install LibreOffice Portable on a USB stick (when I say "install", it
mostly means "copy over")
- Save your file as .odt to keep all of your presentation

Assuming you can start software from the USB stick (some places restrict
that), it should provide you a mostly sure way of reading presentations on
a Windows machine.
However, video embedding is always tricky; it'd be better if you could
check that your file (container, codec, etc.) works fine on said machine.
If it works once, it'll always work, but it might depends on the Windows
version. From this

old internet post, on Windows it uses DirectShow, which might or might not
support some video formats.

-- 
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] Showing two sheets of the same spreadsheet

[Cley Faye]

2017-04-17 21:51 GMT+02:00 lismurn :

> Is it possible to show two sheets of the same spreadsheet and to edit each
> cell as required on both parts without going to the individual Plot and
> Burial Sheets.
>
> I have a spreadsheet in which one sheet, Plots, shows the details of plots
> in a graveyard including location, ownership, date registered etc.
>
> The other sheet, Burials, shows who has been buried in each plot.
>
> I have attached a jpeg example using Microsoft Excel but want to use
> "Libreoffice Calc Spreadsheet" if possible.
>

Y​ou can duplicate the currently open document using the Window menu:
"Window" -> "New window". You can then place them the way you want (most
desktop environment allow easily placing windows on half-screen or quarter
of screen).​
​By default the new window might be on a different sheet but you can also
have the same sheet open in both windows.​

-- 
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] Malware in latest Win x64 download

[Cley Faye]

2017-04-10 22:15 GMT+02:00 MR ZenWiz :

> If this is normal, why?
>
> If not, can it be fixed?
>

​No, it is not normal. Although contamination of the official builds are
not impossible, it is however less likely to happen than the following:

- Download from a suspicious source. Always grab your download links from ​
https://www.libreoffice.org/download/download/ . It will redirect you to an
official mirror
- Corrupted/intercepted download because of an already infected system: you
can check the downloaded file fingerprint to make sure it matches the ones
listed here:
https://download.documentfoundation.org/libreoffice/stable/5.3.2/win/x86/LibreOffice_5.3.2_Win_x86.msi.mirrorlist
- False positive. On occasion, some AV software report false positives.

So, first question is: did you download it from the official site, second
is did the download was corrupted?

-- 
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] Calculate decimal seconds

[Cley Faye]

2017-03-29 15:38 GMT+02:00 vytas :

> I have a spreadsheet containing timing results which are displayed using
> the a Format code of MM:SS.00  (02:58.03).
>
> What I require is the number of seconds the cell represents as a decimal
> number of seconds (178.03) for the above value.
>

​The actual, numerical value stored in such a cell is a number of day. To
find this out, you can remove formating.

Suppose you have 02:58.03 in A1, you put "=A1" in A2, then Ctrl+M to remove
formatting, it will show you something like 0.002060532
To convert from "number of day" to "number of seconds", multiply with
60*60*24. For example, putting "=A1*60*60*24" in A3 will display 178.03

-- 
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 building Libreoffice from GIT: expected checksum for boost_1_63_0.tar.bz2 is...

[Cley Faye]

My guess is that your download failed and wasn't retried because it's
timestamp is more recent. Try removing the file from
/home/libreoffice/core/workdir/download and run make again.

My other guess is that this list is mainly for users of LibreOffice, and
that dev questions should go to the dev list :)
https://www.libreoffice.org/get-help/mailing-lists/

-- 
Cley Faye
http://cleyfaye.net

2017-02-12 21:28 GMT+01:00 Steven P. Ulrick <meow8...@gmail.com>:

> Hello, Everyone
> I've been trying to build LibreOffice from GIT for the last few days, and
> "make" exits in the following manner:
>
> cd /home/libreoffice/core/external/tarballs/tmp && bash -c 'wget
>> --progress=dot:mega -Q 0 -P "." -l 0 -nd -nH -N --no-use-server-timestamps
>> http://dev-www.libreoffice.org/src/boost_1_63_0.tar.bz2 2>&1 | tee -a
>> /home/libreoffice/core/external/tarballs/fetch.log && [ $PIPESTATUS -eq
>> 0 ]' && SUM=`md5sum boost_1_63_0.tar.bz2 | sed "s/ .*//"` && if test "$SUM"
>> != "1c837ecd990bb022d07e7aab32b09847"; then echo ERROR: expected
>> checksum for boost_1_63_0.tar.bz2 is 1c837ecd990bb022d07e7aab32b09847
>> 2>&1 | tee -a /home/libreoffice/core/external/tarballs/fetch.log; false;
>> fi && mv boost_1_63_0.tar.bz2 ../
>> --2017-02-12 14:21:23--  http://dev-www.libreoffice.org
>> /src/boost_1_63_0.tar.bz2
>> Resolving dev-www.libreoffice.org (dev-www.libreoffice.org)...
>> 195.135.221.70, 2001:67c:2178:7::70
>> Connecting to dev-www.libreoffice.org 
>> (dev-www.libreoffice.org)|195.135.221.70|:80...
>> connected.
>> HTTP request sent, awaiting response... 304 Not Modified
>> File ‘./boost_1_63_0.tar.bz2’ not modified on server. Omitting download.
>>
>> ERROR: expected checksum for boost_1_63_0.tar.bz2 is
>> 1c837ecd990bb022d07e7aab32b09847
>> /home/libreoffice/core/Makefile.fetch:103: recipe for target
>> '/home/libreoffice/core/workdir/download' failed
>> make: *** [/home/libreoffice/core/workdir/download] Error 1
>>
>
> Anyone else seen this?  Ideas on how to work around this?
>
> Thank you,
> Steven P. Ulrick
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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] How to make chart out of a multi-sheet ods file ?

[Cley Faye]

2017-02-05 22:32 GMT+01:00 shirish शिरीष :

> Now what I want to do is to make chart from say either page 2 or page
> 3 but unable to figure out how to do it ?
>

W
​hen creating a chart​, you can either prefix your intervals with
$. or use the button on the right of each range input then
change tab to get data from another sheet.

Additionaly, to use multiple ranges (either on the same sheet or on various
sheets) you can separate ranges using a semicolon, and/or add more data
ranges in the chart assistant.

For example, this is a multi-sheet multiple range
string: $Sheet2.$A$1:$A$7;$Sheet1.$B$1:$C$7

-- 
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 libreoffice online which is introduced in version 5.3

[Cley Faye]

2017-02-02 19:53 GMT+01:00 nasrin khaksar :

> i tried this link, but without any success.
> https://hub.docker.com/r/libreoffice/online
>

​I'm not sure about the rest of your post (restrictions etc.) but that link
is about the docker image directly. Docker is a tool made to deploy apps in
a specific ways. It might be possible to use LibreOffice online in other
ways, but there's no obvious ways to do it without docker.

You can (hopefully) find more info about using LibreOffice Online​ at
https://www.collaboraoffice.com/code/ . For starters, know that it's
completely separate from a regular LibreOffice installation. Work on
CODE/LibreOffice Online started a while ago, but it's probably not
useful/very useable with previous versions. And it also depends on some
other components to actually manage user files, but that's covered on the
link I gave 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

Re: [libreoffice-users] Macro/button to update link(s) to external sheet(s)

[Cley Faye]

Ok, I can't test this right now, but this page might have an acceptable
answer: http://blog.louic.nl/?p=622

The part about adding a nice button have a small macro in it. Here it's
used for linked CSV files, but since the dialog asking to update links
that's shown when you reload your file is the same, maybe the same
procedure works.

Other than that I didn't find a quicker way to reload external references
than file->reload->accept the dialog that asks for refresh :(

-- 
Cley Faye
http://cleyfaye.net

2017-01-16 21:45 GMT+01:00 Tanstaafl <tansta...@libertytrek.org>:

> Ok, one more hurdle...
>
> I tried recording a macro to do this, but it just opens the Edit > Links
> window, it doesn't finish (update the links and close the window).
>
> Anyone have any ideas on how to accomplish this? I really don't want to
> tell the boss he'll have to do that manually every time he wants to
> refresh the data in his management spreadsheet.
>
> 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]

[Cley Faye]

2017-01-08 10:38 GMT+01:00 Vaibhav Banait :

> I use Calc to do invoicing. I use one sheet per invoice and one calc file
> per day. I calculate total amount invoiced using formula =Sum
> (sheet2.B25:sheet16:B25). I generate 25 files per month x 12 month. Is
> there a way I can calculate total amount invoiced in a year by using some
> formula by parsing the files considering the total of the day is on
> sheet1.B25Kindly help


A
​ssu​ming you have some sort of naming convention for your files, it is
easy to do. You can reference other files from within a sheet.

Here are two way to do it with two "day" file and a "summary" file.
Assuming the total in the day files is on sheet1.A1.

First solution is to use these formula:

='file:///E:/day1.ods'#$Sheet1.A1
='file:///E:/day2.ods'#$Sheet1.A1

They will pull data from the file given in reference.
But as you see, you have to put the file path in full (relative URL won't
work). There's a way to easily make this scalable to many days if you use
INDIRECT(). In your "summary" file, put the file path somewhere (in my
example it'll be E1) and the day file names in a col (for example C:C),
then use these formula to get your results:

=INDIRECT("'file:///"$1&".ods'#$Sheet1.A1")
=INDIRECT("'file:///"$1&".ods'#$Sheet1.A1")

that way you can quickly get the results from many days, and if you have to
move your files around you only have to update a single cell instead of all
of them.

This should give you a good example on how to achieve this:
http://www.cjoint.com/c/GAikfTZMQFc

-- 
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] MS Anniversary upgrade warning - not LO issue

[Cley Faye]

2016-12-07 9:10 GMT+01:00 Mike Scott :

> A windows licence might be tied to hardware, for example. So if I need
> occasional windows use (eg to update my satnav - g!) but otherwise use
> linux, dual-boot is a necessity. Such a licence probably wouldn't work in a
> virtual machine.


​There's always this possibility:
https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/

-- 
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: Transferring Markdown Documents to LibreOffice

[Cley Faye]

2016-11-28 16:48 GMT+01:00 H :

> MultiMarkdown has been suggested by its author Fletcher Penney and it does
> sound interesting. Unfortunately I could not get it to work on the only
> Windows system I have - running Vista - and I am not sure I could compile
> it for CentOS.



​I've started writing a markdown conversion tool for another purpose, but
it would be relatively trivial for me to output fodt; do you have a
reference to the markdown you use? As I understand it, there are a lot of
variation of it.

(sorry if it was said before in the thread, but it's been a lenghty one).

-- 
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] Speed up RTF to PDF (headless) conversions

[Cley Faye]

2016-11-28 16:55 GMT+01:00 Paquin, Brian :

> The initial conversion is about 5-10 seconds.
> If we process a second document (all RTFs about the same), it is less than
> a second.
> If we then wait a couple minutes and process a third document, it goes
> back to the 5-10 seconds...
>

​To me, it sounds like libreoffice just shut down when it have nothing to
do, and so needs to start up again.

Depending on the way you do this, you could fiddle with the --accept option
to keep LibreOffice listening, or pre-start it with --invisible, keeping it
open.

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

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

[Cley Faye]

2016-10-24 17:23 GMT+02:00 M Henri Day :

> ​I can confirm that I have installed LibreOffice (5.2.3.1) on several
> machines running Windows 10 version 1607 (aka the «Anniversary Update»)
> with Windows Defender activated​ (
> ​in addition to having the suite installed on several machines running
> Linux Mint 18) ; on n​one of them have I hitherto encountered any problems
> of the type described by the OP
>

Due to the nature of these antivirus, it is very possible that both of
these happened in quick sequence:
- an update to their virus tables/heuristics/whatever got pushed, and
caused LibreOffice to be detected as a malware
- a later update was quickly pushed to fix that

People having the first updates without the second one will have issue,
while people not having the first update, or directly getting the second
one, will not have any problem. These kind of false positive are somewhat
common with antivirus, and usually gets fixed quickly.

There's also the remote possibility that a malware carrier actually
targeted libreoffice binary and caused a bunch of people to actually be
infected; but since most report of trouble are about a ransomware, and that
none of the complaints resulted in unusable files, it's unlikely :)

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

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

[Cley Faye]

2016-10-20 9:44 GMT+02:00 dam4rus :

> So, i have Windows 10 with Anniversary Update and today Windows Defender
> quarantined soffice.bin, because it thinks it's a Trojan. Is this a known
> issue? Should i report it as a bug? I haven't found anything about this
> with
> google search.
>

​Yes, it should be reported as a bug to microsoft (don't know how to do
that though).

Although it is easy to see this as a "strategic move" from MS, it is also
very possible that it is just the result of some heuristics; no doubt they
(MS) have seen quite a few version of the soffice.bin file since
LibreOffice have a lot of version around simultaneously.

There's also the remote possibility that a real trojan stepped in and
infected the file. Uninstalling, checking the system and reinstalling might
fix this, but hopefully this isn't the case.

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

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] 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] 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] 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] 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] 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] 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 <let...@openmailbox.org>:

> 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] 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] 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 <oo...@nouenoff.nl>:

> 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-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] 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 <m...@interak.com>:

> 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] 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] 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] 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 <bekanntesfan...@aol.com>:

>
>
> 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] 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] 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 <steve.edmo...@ptglobal.com>:

> 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] 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 <robbewilk...@hotmail.com>:

> 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] 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 <manuel_songo...@yahoo.it>:

> 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] 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] 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 <csanyi...@gmail.com>:

> 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: 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 <paco...@gmail.com>:

> 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 <ville...@t-online.de>:
>
> > 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=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] 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 <nasrinkhaks...@gmail.com>:

> 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] 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] 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 <keiron.os...@gmail.com>:

> 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] 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] 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 <st-malcolm.mo...@whsg.info>:

> 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] 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] 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] 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] 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] 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 <r...@kingsentmarketing.com>:

> 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] 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 tim.ll...@gmx.com:

 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] 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 jmadero@gmail.com:

 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 wachin...@gmail.com 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] 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 v...@scottsonline.org.uk:

 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:table-row table:style-name=ro1table:table-cell
 table:number-columns-repeated=2/table:table-cell table:style-name=ce2
 office:value-type=float office:value=33520
 calcext:value-type=floattext:p33520/text:p/table:table-celltable:table-cell
 table:style-name=ce2 table:formula=of:=SUM([.B5:.C5])
 office:value-type=float office:value=0
 calcext:value-type=floattext:p0/text:p/table:table-celltable:table-cell
 table:number-columns-repeated=1020//table:table-row



 --
 Mike Scott (unet2 at [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] 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 tiberius_sha...@yahoo.com:

 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] 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 james.kn...@rogers.com:

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

[Cley Faye]

2015-05-27 15:15 GMT+02:00 Gary Dale garyd...@torfree.net:

 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 b.m.bar...@btinternet.com:

 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: 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 mka...@naturalsciences.be:

 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 james.kn...@rogers.com:

 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] [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 tomc...@gmail.com:

 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 ramontava...@gmail.com 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 tomc...@gmail.com 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
  sharing files between those colleagues.  Similarly with OpenOffice.
 
 
  Best advice seems to be to use either;
  1.  the older MS Office format, Xls (without the X on the end), for MS
  Office Xp/2000 and prior or
  2.  stick with Ods.
 
  Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
  everyone else was using at the time and stuck with a mangled version of
 the
  older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing
 to
  open just fine but all the formulas got replaced by fixed values.  Their
  apparent failure somehow led to people saying that everyone else made
 bad
  spreadsheet programs and everyone should stick with MS.
 
 
  So it is well worth avoiding XlsX and it is probably best to use their
  older Xls format instead - at least if you want to open the spreadsheet
 on
  any machine

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 ramontava...@gmail.com:

 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] ml-node+s969070n4147063...@n3.nabble.com 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=nodenode=4147063i=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=nodenode=4147063i=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=nodenode=4147063i=2 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

Re: [libreoffice-users] Notice to Appear in Court

[Cley Faye]

2015-04-19 20:48 GMT+02:00 toki kantoor toki.kant...@gmail.com:

 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] Re: E-mail Account Verification

[Cley Faye]

2015-03-16 15:42 GMT+01:00 anne-ology lagin...@gmail.com:

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] 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 e...@esjworks.com:

 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] Use Java for macros in Base

[Cley Faye]

2015-02-28 21:18 GMT+01:00 Stefan v. Wachter svwa-...@mnet-online.de:

 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] ### 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 dasaib...@icloud.com:

 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 dasaib...@icloud.com:

 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 p_mirow...@bentaxna.com
 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] Re: Split Screen in Writer?

[Cley Faye]

2015-02-02 9:10 GMT+01:00 Alex Thurgood alex.thurg...@gmail.com:

 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] Re: compatibility with Microsoft Access

[Cley Faye]

2015-01-31 18:26 GMT+01:00 Urmas davian...@gmail.com:

 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] 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 li...@comcast.net:

 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] 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] 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 tomc...@gmail.com:

 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 li...@malte.homeip.net
 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 li...@malte.homeip.net
 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-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] 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 gcpa...@gmail.com:

 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] 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 gordo...@mail.com:

 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 lagin...@gmail.com:

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 jbfa...@libreoffice.org
 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] 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 reachmepl...@gmail.com:

 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] 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. webofht-libreoffice...@yahoo.com.hk:

 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] 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 tomc...@gmail.com:

 Hi :)
 To unsubscribe e-mail to:

 users+unsubscr...@global.libreoffice.org

 Regards from
 Tom :)


 On 18 December 2014 at 16:57, juliejohn scott juliejohn_sc...@yahoo.co.uk
 
 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

[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] 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 whitfi...@telkomsa.net:

 *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

Re: [libreoffice-users] Lost Pass Word

[Cley Faye]

2014-11-26 17:32 GMT+01:00 Tom Davies tomc...@gmail.com:

 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 toki.kant...@gmail.com:

 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] Re: rtf files

[Cley Faye]

2014-11-20 6:02 GMT+01:00 Urmas davian...@gmail.com:

 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] Re: rtf files

[Cley Faye]

2014-11-19 16:58 GMT+01:00 Virgil Arrington arringto...@gmail.com:

 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 tomc...@gmail.com:

 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 ville...@t-online.de 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\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\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\00\00\00\00\00\00\00\00\00\00\00