Re: [libreoffice-users] How to switch between impress slideshow and another application

[Cley Faye]

2013/11/24 Michael Shiloh 

> Hello,
>
> Sometimes during my presentations I need to show another program e.g. a
> web browser or a programming language window.
>
> I read somewhere that   should allow me to switch between
> applications even during a slide show, but while   works for me
> normally, it does not work during a slide show.
>
> I don't care whether I useor some other sequence, as long as
> I can easily switch between applications and come back to my slide show
> where I left off.
>
> Any suggestions?
>
> I'm on Ubuntu 13.10, Libre Office 4.1.2.3
>

​Hm. Alt+Tab should work (it does for me), but I'm not on Unity, so who
know :)

Anyway, what *might* work is switching to a different desktop. It might be
something like Ctrl+F2. On KDE, both ways works (I'm more in favor of
switching desktop, because in this case it's possible to prepare the
content beforehand). On Unity (or other WM), this second solution might
work where Alt+Tab doesn't.

-- 
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] csv problem

[Cley Faye]

2014/1/7 piergio 

> Hi all
>
> I'm trying to open (or import in a calc file) a csv file (ubuntu 13.10 -
> libre office).
> I have this error:
> "I dati non sono stati caricati interamente perché è stato superato il
> numero massimo di caratteri per cella."
> (Data have not been loaded completely because you exceeded the maximum
> number of characters per cell)
>
> With MS Office the file works.
> Do you have any suggestions to understrand and fix the problem/error?
>
>
For the "understanding" part, the message seem pretty clear: you have one
cell that is too long for Libreoffice to handle.​​

I'm not sure about the limit itself, but trying today with LO 4.1.4.2,
between 4096 and 8192 it started showing blank cell (while retaining the
content when editing), but still can save and load as a CSV file.

Either you're really trying to load a file with a cell containing more than
16384 characters (it still works with such a large content), or there was
an error while loading your file that made LO think that one cell is larger
than it is. If your file doesn't contain sensitive informations you could
try uploading it somewhere and put the link here so peoples might try
opening it. Otherwise, you can try editing the CSV file by hand (with
notepad or something), remove half the file, try to load, etc. until you
can pinpoint which part leads to the error.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Installing a Language Pack

[Cley Faye]

2014/1/8 

> I would appreciate if you could indicate what I need to do to install
> these language packages to have access
> to the corresponding spellers but leaving the user interface as is, in
> English.
>

If I remember this correctly, Linux version of Libreoffice use system's
dictionnaries to provide the spellchecks languages. So, you don't have to
install any libreoffice package, just your system's packages (something
like myspell-fr for french dictionnary, for example). This will provide you
with various languages for the spellcheck, but leave the LO interface
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] ASCII Filter Options - Help please!

[Cley Faye]

2014/1/10 Jacob Marioni 

> Hello. LibreOffice has been wonderful up until recently.
>
> All of my ODT won't open properly. Every time I try to open a .odt file,
> the
> 'ASCII Filter Options' comes up. These are all normal text files and this
> has never happened before. When the filter options open up its set at:
>
> -Character Set: Western European (Windows -125)
> -Default Fonts: Times New Roman
> -Language: English (USA)
>
> I just clicked ok to try and start it, but when I do everything is gone and
> turned into things like this:
>
>
> "##’êH`h¤i3Vµe#K†£�½À‡T½=E©Å#Ñs#u�…�^âkÂA¼¾Cé.ì@R÷¤'KÛ‡Ù=·î#¢�öÌ
> mÚÎ#Ťáo#íà‘ü,kvÝðŸ#·„Ëa�—+ŒîsQíf—R�7ÉÇ™#W…#
> £#½´i)s‘’5Å=<#Ü(…0âêJªvVuÞŠ=ƒ�ŽKÑ5“F)
> a¼á>#ÉÖ=Ʊ…'è<¿#LK×Ú#5…ÛpU�Œë##“#2#îHLM†1“ŠG >Mò;ì¯mÊ6Ï#
> [#€–ªÈ–%[s4*˜
>
> This has affected All my old .odt files. My .txt files are fine. I can make
> and save new .odt files fine without this problem happening. The only clue
> I
> have is that all this started happening when I got a virus a few months
> ago.
>
>
This (the ASCII Filter options thing) indicate that LO don't recognize your
file as a valid ODT file. If you let the option as indicated, it mean that
your file is no longer a ZIP file (ODT are zip files), so I fear that their
recovery will be very hard (is possible at all). But, I might be mistaken,
so if one of these file doesn't contain sensitive informations, you could
try putting it online somewhere and link it here, so others may fiddle with
it and (hopefully) find a solution.

However, you indicate that you had a "virus". Do you know which one it was?
(usually antivirus software keep some sort of history). It's not out of the
question that something messed with your file (most likely encrypting
them), as CryptoLocker type of virus got some more activity recently.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: ASCII Filter Options - Help please!

[Cley Faye]

2014/1/10 Jacob Marioni 

> -I tried changing my "user profile", but that didn't work
>
> -When I open the files with Notepad, the text is in a different language:
> Ḣ鈓䣪桠榤嘳斵䬝ꎆ붏蟀뵔䔽얩턖ѳ腵超쉫뱁䎾⻩䃬➤
>
> -I'll try to upload the file so people can look at it, but how do I do
> that?
> Can I just upload it here on the forum?
>
> At_Least_you_Have_Something!.odt
> <
> http://nabble.documentfoundation.org/file/n4091641/At_Least_you_Have_Something%21.odt
> >
>
>
Yes, you can. I supposed that you used the mailinglist, which strip
attachments, but uploading through nabble is fine.

Unfortunately, none of my tools is able to find any correspondance between
your file and known archive formats. Maybe someone more specialized will
have more luck, but by the look of it I wouldn't hold my breath for it.
As the data looks random, either you've encountered a serious hard-disk
corruption (unlikely to have gone unnoticed by the filesystem itself), or
some malware/virus really altered your data.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] [HS] ODT and ZIP files (was: ASCII Filter Options - Help please!)

[Cley Faye]

2014/1/10 Tom Davies 

> I tried opening with GEdit (= a lot like Notepad) but the 1st 2
> letters were not PK and then i checked a different Odt that someone
> else sent me earlier and that did start with PK.  I'm not convinced
> about the whole PK thing but it's interesting
>

​As we all know, ODT are ZIP files. "PK​" happen to be found at the
beginning of almost all ZIP files.
In this document
(http://www.pkware.com/documents/APPNOTE/APPNOTE-6.2.0.txt VI.A.)
we can see that every file start with the following header: 0x04034b50,
translated (in correct endianness) to "PK..". So every compressed files in
a ZIP file start with PK.

This also mean that if a file is somewhat corrupted, looking for this
signature and checking that the following bits make a correct header allows
one to recover files. For example, if you find the sequence 504b0304
followed 22 bytes later with a 2 bytes integer, 2 more bytes, then a
filename, you can recover it.

As we know, ODT are made of multiple files, some more important than other.
Losing the manifest for example is not a big issue, so we can recover some
ODT files with this knowledge: identifying files in the ZIP structure, then
checking that we have the "important" parts.


>
> I didn't yet try finding some tool for fixing zip files.  it might be
> worth testing on a copy of a couple of files.  There might be an odt
> fixing tool around the internet somewhere too.
>

I don't know if such tool exist for ODF, but it might be worth making one
based on my previous rant. In the case of minor corruption (which was *not*
the case from OP here), retrieving the document content and possibly losing
stuff like statusbar toolbar settings, document thumbnail, or the initial
mimetype info (representing 77bytes at the beginning of the file, enough
for it to get corrupted!) is probably an acceptable tradeoff. Even losing
some content (like pictures) might be better than losing the whole text.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 untitled docs constantly autosaving

[Cley Faye]

2014/1/12 John King 

> On 09/01/14 15:36, Tom Davies wrote:
>
>> Hi :)
>> It might be worth contacting the openSuSE forums to ask in there,
>> http://forums.opensuse.org/
>> errr, right now their forums are down for maintenance but will
>> probably be up by the time you read this.  Jic it isn't this wiki
>> might be more help
>> http://en.opensuse.org/openSUSE:Communication_channels
>>
>> I guess you probably already asked the same question there somewhere.
>> Also it might be worth posting a bug-report in the oepnSuSE
>> bug-tracker regardless of whether you get any replies or not.
>> Regards from
>> Tom :)
>>
>>
> I have now located a bug report on this issue:
>
> https://bugs.freedesktop.org/show_bug.cgi?id=46635
>
> It applies to other distributions besides opensuse.  Essentially, if the
> option in
>
> Tools-Option-Load/Save-General
>
> is set to 'Automatically save the document too', then untitled/unnamed
> files will go into a save loop every few seconds.
>
> I have submitted a confirmation of the bug report, but cannot at the
> moment test it out on any version of Windows. Could anyone else check this
> and update the bug report?
>
>
As a quick test on my current computer (Windows 7 64Bit, LO 4.1.4.2) I did
this:
- Set autosave to 1 minute
- Check the "save document too" option
- Open a new writer document
- Type a few words​​
- Wait a minute. It created an untitled_1.odt file in the backup directory,
and nothing else
- Typed a few more words
- After a while, the backup file updated. No extra files where created, and
LO doesn't seem to go crazy with I/O either.

However I'm not sure that this specific bug report is related. I'll add
these informations nonetheless.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 untitled docs constantly autosaving

[Cley Faye]

Additionnaly, how did you install LibreOffice on your system? Did you use
some distribution-specific repositories, or got it from the Libreoffice
website ? Maybe there is something opensuse-specific that cause this. If it
doesn't happen with the version downloaded from the website, you'll have to
report this issue to the Opensuse folks.

-- 
Cley Faye
http://cleyfaye.net


2014/1/12 Cley Faye 

> 2014/1/12 John King 
>
>> On 09/01/14 15:36, Tom Davies wrote:
>>
>>> Hi :)
>>> It might be worth contacting the openSuSE forums to ask in there,
>>> http://forums.opensuse.org/
>>> errr, right now their forums are down for maintenance but will
>>> probably be up by the time you read this.  Jic it isn't this wiki
>>> might be more help
>>> http://en.opensuse.org/openSUSE:Communication_channels
>>>
>>> I guess you probably already asked the same question there somewhere.
>>> Also it might be worth posting a bug-report in the oepnSuSE
>>> bug-tracker regardless of whether you get any replies or not.
>>> Regards from
>>> Tom :)
>>>
>>>
>> I have now located a bug report on this issue:
>>
>> https://bugs.freedesktop.org/show_bug.cgi?id=46635
>>
>> It applies to other distributions besides opensuse.  Essentially, if the
>> option in
>>
>> Tools-Option-Load/Save-General
>>
>> is set to 'Automatically save the document too', then untitled/unnamed
>> files will go into a save loop every few seconds.
>>
>> I have submitted a confirmation of the bug report, but cannot at the
>> moment test it out on any version of Windows. Could anyone else check this
>> and update the bug report?
>>
>>
> As a quick test on my current computer (Windows 7 64Bit, LO 4.1.4.2) I did
> this:
>  - Set autosave to 1 minute
> - Check the "save document too" option
> - Open a new writer document
> - Type a few words​​
> - Wait a minute. It created an untitled_1.odt file in the backup
> directory, and nothing else
> - Typed a few more words
> - After a while, the backup file updated. No extra files where created,
> and LO doesn't seem to go crazy with I/O either.
>
> However I'm not sure that this specific bug report is related. I'll add
> these informations nonetheless.
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] I think you could significantly improve the compression on the odt docs.

[Cley Faye]

2014/1/13 Regina Henschel 

> Hi Frank,
>
> frank ernest schrieb:
>
>  I think you could significantly improve the compression on the odt docs.
>>
>> tar -c dir | xz -4 -e >> file.tar.xz
>>
>> 16,760 tar.xz
>> 21,919 odt
>>
>> 76.46334230576213%
>>
>
> there is no choice, how to compress the package, because it is defined in
> the standard, see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
> v1.2-os-part3.html#__RefHeading__752789_826425813
>
>
​Agreed.
It *is* possible to achieve better compression than ZIP (we knew how to do
that ​for quite some time ;) ), but to do so we would need a new iteration
of the OpenDocument standard. While it's not totally out of question, I
have the feeling that increasing fragmentation just to save space on office
files is not a good trade-off. Remember that ODT files are used by many
pieces of software, not only LibreOffice.
OpenOffice of course, but some part of google export, some less-known
office suite, various custom software that output their reports as odt
files... even mso got to implement it. I doubt a new version of the
standard would be a good thing while it is still functionnal.


-- 
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] I think you could significantly improve the compression on the odt docs

[Cley Faye]

2014/1/13 frank ernest 

> Acctually I thought that it was kinda obvious and I was thinking that
> you'd want to fix it before your ODT standard was widly adopted.
> It would be easier to change the code of 10 programs then 1000 once you
> finally retire the standard.
> You could also develop a split in the standard and call the files *.ODT2.
> Personally I was shocked how bad the compression was. I expected maybe I'd
> get 5% or (if I was really lucky) 15% better compression, but 25%! That's
> (as someone already pointed out) HUGE!
> I am advising to fix the spec before the cat gets out of the bag.
>
>
Huu, you might have missed the last five years where odt is already widely
used.

Also, you should warn microsoft before their docx stuff get in the wild
too, as they also use the zip file format.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] I think you could significantly improve the compression on the odt docs

[Cley Faye]

2014/1/16 frank ernest 

> >Also, you should warn microsoft before their docx stuff get in the wild
> >too, as they also use the zip file format.
>
> Here I thought that some of the ideas behind opensource was that it would
> promote
> better/some kind of standards.
>
> It's ok though. There are greater problems out there then lack of
> compression.
>
> Thanks, as always.
>


​My phrasing might have been a bit harsh, so I'll reformulate my thoughts
on this.
One of the key point (in my opinion) when designing file formats​ is to
maximize stability and usability. It is especially true for office files,
that might be stored and reused years later. Simply using the ZIP format
with plain xml content mean that almost anything can read it without
hassle, as both are well established and well supported across a lot of
systems.

Now, one could argue that we could create a new iteration of the standard,
without messing with the existing one (that would become the "old" one).
It's true, but maintaining multiple reader/writer for each version of the
standard can get tedious, and ultimately lead to dropping support for old
files. For example, see the old staroffice and msword file formats,
recently dropped from libreoffice (if I'm not mistaken).
Ultimately, adding an iteration to an existing standard also open the
possibility of changing the interpretation of some features. For more
example, see the docx file format :).

​So, the question: is improving the compression rate (albeit not
marginally)​ worth creating a new version of the standard, with the need to
update *all* software to support it (e.g. not only LibreOffice), and bring
the risk of progressively reducing support for the "legacy" file format?

Again, only my opinion, but no; I'd rather have a file format that don't
change too often. Of course, if a large pack of features needed a large
overhaul of the file format, then so be it. But improving the file storage
efficiency by itself isn't worth it. But knowing that the files are highly
compressible (not sure about this word sorry), you could just mount a
compressed file system and store your files 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] Nikolai Cassanova: Hi, I am having problems with OLE objects in microsoft word documents

[Cley Faye]

2014/1/23 

> Hi Regina,
>
> I am using ubuntu 13.04, I don't understand what you mean by using windows
> file manager.  Is it possible to unpack a .docx file using the ubuntu
> archive program that unpacks tar.gz file formats?  Also libreoffice
> doesn't allow me to remove it.  Thats the problem if I could remove it I
> would just put it on my desktop and then open it with vlc player.
>
>
​Yes, docx files are really zip files. You can rename one from ".docx" to
".zip" and open it with any program that can deal with compressed files (I
believe the default software available on Ubuntu are able to deal with zip
files).

Once open as a zip archive, you'll most likely see the file somewhere.​


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

[libreoffice-users] Re: [libreoffice-marketing] how many languages can LO support at the same time. . .

[Cley Faye]

2014-01-27 Kracked_P_P---webmaster 

>
> The problem I have with "selling" LO to computer centers, both regular and
> ones that teach English as a second language, is how many languages can LO
> support at the same time.
>
> I am talking about two ways.  1 - usable dictionaries in the list.  2 -
> different languages you can change your menus to.
>
> The first one is the key for me.
>
> You have English, French, Spanish [3 regional versions], Italian, and 4 or
> 5 other different language dictionaries, installed and enabled, in the
> Extension Manager.  How many of those languages are usable to the user
> writing documents in English and one or two other languages at a time, then
> someone else sits down and tried to use his or hers language[s] with
> English.  So how many installed and enabled languages can be used at the
> same time?   I was told there was a very small limited number.
>
>
I can't vouch for the second point, but regarding available dictionaries,
here's my experience: I currently have ​​LibreOffice 4.1.4.2 installed
under Windows, with the default installation package. In the list of
available languages for dictionaries it give me a quite long list. Granted,
some are "variations" (like multiple "english" ones), but even then,
there's quite a few. I believe that all of them can be used without
restriction. At least there is none visible.
I wrote a small document with four paragraphs, in French, English, Deutsh
and Russian, and was able to set each paragraph to use the correct
dictionary with minimal effort:

By moving the cursor from one line to another, you should see the language
change in the statusbar. There's multiple way to change the language for a
paragraph, but here's two that are quite fast and accessible:
- Click in the statusbar on the language portion, that will show you a
popup menu, you can then choose "set language for paragraph"
- In the "Tools" menu, go to "Language"

I think this should answer your first concern.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 - Merging PDFs

[Cley Faye]

2014-01-29 charles meyer 

> I've got 3 or so separate PDF files.
>
> I'd like to merge them all into one PDF file in Writer in Office 3.6.2.2
>
> Each page of each PDF file has a lot of empty space around the graphic
> image.
>
> Ex. 2 inches above and below the graphic on each page and a good 3
> inches on each side of each graphic is white, empty space.
>
> Is there a way to eliminate all the empty space around each graphic in
> in each page in each PDF or once all the PDFs are merged into one
> larger PDF?
>
>
LibreOffice Writer is not a PDF manipulator.

Since you want to manipulate the content In addition to merging​​ the
files, you can try to open it with Draw. If your PDF contains images, it
should allow you to manipulate them, and output it again as another PDF.

Note that opening PDF from Draw is a relatively recent development, and
might not be supported by the 3.6 line.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] FYI: LO's security system is compromised, please be careful

[Cley Faye]

2014-01-29 Sayt Bahal 

> It turned out that LibreOffice has a security-related issue (
> https://bugs.freedesktop.org/show_bug.cgi?id=51819), that makes it save
> the
> AutoRecovery files for password-protected documents without any protection
> (encryption).
>
> It essentially means, that with AutoRecovery enabled (which is the
> default):
> - after an application or system crash (eg. a power failure) anybody can
> recover the document without knowing the password (the document 'loses' its
> password)
> - anybody who has access to the system drive (eg. through the network)
> while you are editing a document can open it without knowing the password
> - anybody who has physical access to your system hard drive, now or in the
> future (at worst even months/years after the actual editing), has the
> chance to unerase the document and open it without knowing the password
>
> If you use password-protection a lot and are concerned about the security
> of your documents, it could be advisable to switch the AutoRecovery feature
> off until the bug gets fixed.
>
> The issue applies to all LibreOffice modules (Writer, Calc, Draw, ...) and
> was introduced in version 3.4.6 (March 2012).
>
> --
> For developers only:
>
> It also turned out, that (a bit surprisingly) the lead developers have
> other priorities than fixing such security issues, and are waiting (since
> May 2013) for the community to step in.
>
> If you have the necessary knowledge and free time to track down and
> potentially to fix this issue, please do not hesitate to take a look into
> it and help in maintaining the security standard that millions of users
> worldwide impose on such professional products as LibreOffice.
>
>
Hmm. On a general note, one should know that a lot of applications (all?)
have a tendancy to leak information through temporary files, caching,
memory swapping... And appropriate care should be taken if you're
manipulating sensitive informations: system drive NOT available through
network, encrypted temp partition, encrypted swap (with random key), not
leaving the computer unattended while powered (even if the screen's locked,
it's a liability because full-disk encryption keys might be recoverable
from RAM), etc.

More specific to LO now: this issue, if it works as advertised (didn't
check thoroughly, but on Linux LO 4.1.4.2 the issue exists), doesn't come
from some side-effect of our moderns OS, but is directly linked with LO.​​

Maybe a solution would be to automatically disable temporary
backup/recovery when opening a file with a password. Unfortunately I'm not
very familiar with LO codebase, but perhaps such a solution would be easy
enough to implement to bring current developpers attention on it.
At least it's significantly easier (and safer!) than trying to remember the
document key, save the recovery data encrypted, change the recovery dialog
to handle these cases, etc. Of course one would lose the ability to use
recovery for encrypted documents, but it's not necessarily a bad thing :)

Note that if your document is really sensitive, the fact that it's
encrypted when saving doesn't mean that it's safe: if you're not cautious
about your whole system, entire parts of the file can end up on swap anyway
as you're working on it (it have to be in clear in the RAM at some
point...).

For what it's worth, one short-term solution is to have the temporary place
encrypted. For example, on some Linux systems (namely Ubuntu, don't know
for others) you can chose to encrypt your home folder, which happen to
contain the backup path used by LO. This doesn't protect you from network
access, but that's only relevant if you set open network access to your
home folder, including config files in hidden directories... Which I hope
is not that common.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 - Merging PDFs

[Cley Faye]

2014-01-29 Anthony Baldwin 

> When clients send me pdf files full of images to be translated,
>  I often just snap a screenshot of them and manage the images in GIMP.
> In such cases, I am reconstructing their document in LO (in English,
> whereas the originals come to me in any of French, Portuguese or Spanish),
> so then I just insert the images into the document in LO.
>

Just a quick "offtopic" remark: you can directly open PDF in GIMP​​ in the
resolution of your choice. This way you might be able to get better picture
quality (if the picture in the PDF is also high quality of course). I tend
to be on the cautious side and choose 300dpi, because sometime there's a
picture in there that's actually very high definition and I don't want to
notch it down with a simple screenshot :)

Draw can also be useful in your process, as you can directly select images.
Assuming they didn't get chopped in multiple pieces, you can directly
copy/paste images from Draw to Writer ;)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 word of warning about PDF text

[Cley Faye]

2014-01-31 Peter West :

> A word of warning about text retrieved from PDF documents.
>
> Recovering text blocks from PDFs is inherently risky.  PDF is a page
> definition format, and so it has no notion of the semantics of the text it
> contains. It places bits of text at certain positions on the page. You can
> create a whole page of text by taking the individual characters and their
> attributes and position on the page, shuffling them, and writing them to
> the file.  That will produce a readable file, but try extracting the text
> from that file. Unless you have a very, very smart text extractor that
> reverse-engineers the process of creating the page, then calculates the
> _visual_ order of the text elements, you will end up with gibberish.
>
> _Most_ pdf text, _most_ of the time, is laid on the page in visual order,
> but in even the best-behaved files, you are likely to be surprised.
>
> If you don't _know_ that your PDF text extractor program is completely
> visually accurate by design, don't tell your boss that you can easily
> extract that PDF text, without allowing time for proof-reading every page.
> You will get burned.
>
> I don't know how LO extracts PDF text; perhaps it is very sophisticated. I
> have my doubts.
>
>
You are right about the fact that a PDF is not meant to be opened for
modification/text recovery. However it is hardly relevant here, as LO is
not (as far as I know...) marketted as a PDF extractor.

While it is possible to open PDF with Draw, even the simplest file will
show you that it is not meant for full and easy recovery: embedded fonts
are not used, some graphics are off by a few pixels (sometime more), and
yes, text get split into an unexpected number of parts, even when the PDF
content is layered correctly in the final file.
For example you can get a single line of text split in three text elements,
or have a single text elements with (seemingly) random spaces inserted in
the middle of words. General page layout is also an issue: a very simple
PDF, containing only a single page of text, show up as two pages on Draw,
with the footer of the first page at the beginning of the second one.

But I do not think any of this is relevant as long as users know that
opening PDF is at most useful for recovering some select elements. Unless
the documentation state otherwise, it is fine, as it works very well for
this specific usage. Opening a PDF in Draw just does this: show the various
elements present in the PDF.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] automation

[Cley Faye]

2014-02-02 Jean MAURICE :

> Is there a way to 'drive' libre office from another application like we
> can do with excel:
>
> lnexcel = CREATEOBJECT("excel.application")
>
> In fact, I have a Visual Foxpro app who will have to drive Excel or Calc
> depending of its client. I'd like to know if I can build only one procedure.
>
> Est-il possible de piloter Calc à partir d'une autre application comme on
> peut le faire avec Excel ? En fait, j'ai une application Visual Foxpro qui
> devra remplir des tableaux soit dans Excel soit dans Calc selon ce que le
> client a.
>
>
>
You can try looking here:

for starters.

Note that this list is english only; there is localized mailing list for
other languages. For example: ​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Download earlier version of libreoffice

[Cley Faye]

2014-02-06 Viggo Fedreheim :

> hi.
> I need to download version 3.8 of libreoffice, wher can i get it?
>

You can try this:
http://downloadarchive.documentfoundation.org/libreoffice/old/

However there doesn't seem to be a 3.8 version... hm.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Review of AndrOpen Office (was: Re: What do you think of AndrOpenOffice?)

[Cley Faye]

2014-02-06 James E Lang :

> There is also a LO based app but I definitely do NOT recommend it for any
> serious work YET. I installed it a few months ago but then uninstalled it
> again as it was definitely not all that usable. Now I don't know where to
> get it to test it again (help anyone?).
>
>
Didn't read (yet) the rest of your message, but here's something that seem
LO related, Android related, and verybuggyandunstalbedon'tusethis related :)
https://wiki.documentfoundation.org/Android​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] L.O. 4.0.5 pb enregistrement fichier

[Cley Faye]

Le 7 février 2014 10:14, emmauel73  a écrit
:

> Bonjour,
>
> je viens de déplacer, via l'utilitaire robotcopy, des fichiers vers un
> nouveau serveur de fichier. L'ouverture des fichiers Libre  Office sur ce
> nouveau serveur ne pose pas de problème, en revanche il m'est impossible de
> les sauvegarder après modifications. J'obtiens un message du type 'erreur
> lors de l'enregistrement du document . Accès refusé".
> Je précise que les droits utlisateurs sont correctes et que si je
> sauvegarde
> le fichier sous un autre nom au même endroit cela fonctionne. Enfin jusqu'à
> la prochaine sauvegarde car le problème se répète.
> Seule solution que j'ai trouvé pour l'instant : ouvrir un nouveau fichier
> et
> effectuer un copier coller. Là ca fonctionne correctement.
> Mais cette solution n'est pas satisfaisante étant donnée le nombre de
> fichier LO.
> J'ajoute que le problème n'existe pas sur des fichiers autres que LO
> (MSOffice, PDF, txt )
>
> Si quelqu'un à une idée, je suis preneur.
>
>
Comment les fichiers sont-ils accessibles ? Il est possible qu'il y ait un
problème entre un partage ​​réseau et la façon dont LO "verrouille" les
fichiers ouverts.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: L.O. 4.0.5 pb enregistrement fichier

[Cley Faye]

2014-02-07 emmanuel73 :

> les fichiers sont accessibles via un lecteur réseau monté par GPO
> \\nom du serveur\partage$\
>
>
> je viens d'essayer de puger le profil libre office mais sans résultat.
>
>
Un vieux problème similaire, dont je ne sais pas si il est résolu​​, était
lié à l'extension pour l'explorateur. Vous pouvez essayer l'installation
sans l'extension shell pour voir.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: L.O. 4.0.5 pb enregistrement fichier

[Cley Faye]

2014-02-07 Tom Davies :

> Hi :)
> I also often find that LibreOffice doesn't let me save over the top of
> files stored on our network file-shares.  It only does seem to work if
> using the same computer.  When i go to a different machine i use that
> as an opportunity to add/upodate a version number to the end of the
> document name and move the old version into a back-ups folder.
>
> It seems to work quite well but maybe because we only have a small
> number of files active at any particular time.
>
>
> It is probably something to do with a "~lockfile" in the network
> folder or in the "backups" folder inside the "User Profile" of LO on
> whichever machine you happen to be trying to save from.
>
> Sorry i can't write that in French!  My translation tool is stuck in
> English! :(
> Regards from
> Tom :)
>


​Damn, didn't even see that this was not the french list!
For reference, the french lists are here: http://fr.libreoffice.org/forums/

Pour info, les listes françaises sont ici: http://fr.libreoffice.org/forums/

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Export PDF

[Cley Faye]

2014-02-08 23:40 GMT+01:00 Cliff Scott :

> I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I
> get a error message that "PDF/A-1a forbids a transparency". Clicking OK
> allows the export to continue and I don't see any problems in the resultant
> PDF, but this is something I've only seen on 4.1.4. This happens with
> Writer
> and Calc. FYI, I'm running OSx Mavericks. Is this a known problem?
>

​I can tell you that it did happen with previous versions. It's only shown
if you have transparent items in the document, so it might not show up all
the time.

Now, to know what is transparent is more complicated. It could be an image
with an alpha channel (even if completely opaque). It might also be
anything that LO treat as transparent (mayber borders, some special
characters, etc... I don't really know). The thing is, if your output is
correct, it's probably the kind of transparent item that get converted to
white image over white background... no worries.

However, a bit of warning from personal experience: a few years ago, some
people (mainly using Acrobat Reader I believe) couldn't open PDF/A-1, while
these same files would open fine on pretty much anything: gnome document
viewer, kde viewer (okular), foxit on windows... Pretty funny if you
consider that PDF/A-1 is supposed to work for long term storage. You should
double-check that your files open with this certain reader, just to be sure
:)

-- 
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: Corrupted Calc Display of Excel File

[Cley Faye]

2014-02-10 2:08 GMT+01:00 Pedro :

> In case someone is following this thread,


​We are ;)​



> I received the file by mail and
> the error described was a consequence of the functions used if some cells
> were not filled in. Therefore it wasn't a bug in the 4.1 branch.
>
> The file did reveal some serious mess in 4.2 but hopefully these
> regressions
> will be fixed in the near future (maybe some of them are already fixed...)
>
>
Is it possible to reproduce the issue with a minimal, non sensitive sample
file ? It might be useful to have an example of what did go wrong in 4.2,
in case there is more report about this later.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Neat Writer Feature -- Relative Font Sizes

[Cley Faye]

2014-02-13 23:55 GMT+01:00 e-letter :

>
> OK, fair enough but as a latex user, was amazed to read a claim that
> LO provides greater control! :)
>


​They are tools. Power users of each tools will find that they are on the
"better" side.
Some peoples feel that latex, with all the commands everywhere is too
​complicated, but when you learn a bit about it it's ok. Same for
LibreOffice; there's properties dialog everywhere, multiple levels of
styles, and not-always intuitive page management, but when you learn a bit
about it it's ok.
And in both case, doing anything that's more advanced will require more
learning. Setting up the "best" template for your work can be tedious with
any tools, LO and latex included. But writing a ~100 lines latex class file
to match an (imposed) template is as tedious as setting the correct chain
of styles in LO...

Regarding the "greater control" statement, it's the same. You can have a
lot of control in both, but it's gonna be some work. But I'll concede, one
of latex advantages is that it have sensible default settings for various
usages :)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Getting Hyperlinks to work in pdf exports

[Cley Faye]

2014-02-19 14:26 GMT+01:00 CVAlkan :

> Hi:
>
> I'm currently using LO Version: 4.3.0.0.alpha0+ on 64 bit Ubuntu 12.04LTS,
> but have run into this issue in the past with earlier versions.
>
> If I create a phrase and format it as a hyperlink, control+clicking on it
> launches the browser and goes to the specified page just fine.
>
> However, when exporting the document as a pdf, the link doesn't seem to
> work. I've tried various combinations of the check boxes on the pdf export
> dialog, but nothing seems to work.
>
> Is this a bug, or am I just missing some key setting?
>
> Any pointers would be appreciated. Thanks.
>

It definitely worked in 4.1.4.2, so it's either a regression or something
fishy. You could temporarily try renaming your profile​​ to check if it is
related to some custom settings.

Note though that the "latest" LO version is 4.2. I believe discussions
regarding future versions (alpha, beta, rc...) are not meant to be on the
general user list, but are better directed towards dev and bugtrackers.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Getting Hyperlinks to work in pdf exports

[Cley Faye]

2014-02-19 18:43 GMT+01:00 CVAlkan :

> Cley:
>
> Thanks much for the response. I mentioned that I had the same problem
> earlier, and happen to also have version 4.2 on my machine as well (I
> needed
> to use the 4.3 beta with my major project because of a specific bug that it
> fixed). I have the same links issue with pdfs in version 4.2 and my
> recollection is that it's been well over a year since I last attempted
> unsuccessfully to make this work, so we're probably talking about something
> in the 3.x range.
>
> So - therefore - it seems to me that maybe I'm just not setting it up
> properly. The linked text shows up in the pdf as a formatted link and
> clicking it highlights the whole phrase, so at least something is getting
> passed on - it just doesn't jump to a web page.
>
> Can you tell me what settings you use on the Links panel of the pdf export
> dialog box? I am assuming that is where I must be setting things wrong, as
> I
> can't find anywhere else that makes any reference to links. As I said, the
> definition within Writer is apparently good, as control-clicking on the
> links in the document take me right to the web browser with the correct
> page
> opened.
>
>
Here's a PDF file, generated from LO, with a working hyperlink:

(if you'd like to open it, the PDF can be opened in LO Writer as it
incorporate the original document).

It include the PDF dialog open on the "link" tab. It's in french, but given
the large number of options, I think you'll have no difficulty to see
what's what.​ In short: nothing checked, all on default settings.

Maybe the issue lies with your PDF reader instead? As far as I can
remember, for *me* the URL in PDF always worked... quite the opposite of
your experience :\

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Compress images

[Cley Faye]

2014-02-27 23:28 GMT+01:00 Dale Rebgetz :

> I too am very familiar with the various third party methods mentioned
> below, but we must try to address the problem from the point of view of the
> OP. He was made aware of a very simple tool in Word that did exactly what
> he wanted. *How* it achieved it appeared to be of no interest. He was
> asking about the possible existence of a similar tool in LO.
>
> Personally I believe LO needs an equivalent tool, because most of the
> people whom we are trying to convert to LO/OO have no knowledge and no
> interest in the round-about methods detailed below. If there was an easy
> method to perform automatic or one-click cropping and resolution reduction
> *after* the document was compiled, why wouldn't that be the preferred
> method for all users, regardless of their competency with other editing
> tools?


Hm. Probably because there is no "obvious" way to do it that would combine:
- ease of use
- efficiency in all case
- low development cost

I don't know how often this feature is requested for odt files. I know that
for pdf you can set parameters for the image compression, and it make sense
since the resulting file is unlikely to undergo future changes, but it's
less obvious for file formats that are not at the "end" of the editing
line. It's probably better to work with the "highest" resolution needed,
and produce smaller files as needed. Hmm.

As a "proof of concept", I put together a java program that take an odt
file as input. You can then set the "requested" DPI and jpeg quality, and
save. At this point, every pictures that are larger than needed (that's why
we need DPI) are resized, and all pictures are compressed using either jpg
or png, whichever gives the smalles size. Something as simple as that
already have issues, like when there's transparency involved.
Also, it's only tested on a few files (including
https://wiki.documentfoundation.org/images/9/96/WG40-WriterGuideLO.odt for
funsies).

If anyone want to give it a try here's the jar. It's highly unlikely to
corrupt your source file (the source file is never ever written), but
there's also no guarantee that the output will work ;)

For example, on the writer guide linked before, it goes from 13MB to 9MB
with default settings. Of course it's not the best example: all pictures
are already reasonably sized, and it's mostly screenshots so the quality
drop is very noticeable...

Anyway, if anyone want to look at the source code (without reversing the
jar :D) I'll provide them. But know that it's mostly an ugly hack just to
see how well it would work :)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 4 corrupting Calc files

[Cley Faye]

2014-03-02 7:00 GMT+01:00 "J. Van Brimmer" :

> Hello,
>
> I'm new to the list, so if this is an inappropriate subject, please let me
> know.
>
> I am using Libreoffice on Manjaro Linux. Over the last several months the
> version has been regularly updated. The currently installed version is:
> "Version: 4.1.5.3
> Build ID: 4.1.5.3 Arch Linux build-1". I have been using Manjaro for about
> six months. Over this time I have been using Libreoffice to update some
> Calc spreadsheets that I created to keep track of my finances. There is
> only one of those files that occasionally gets corrupted. It's always the
> same file, and only this one file that gets corrupted. I keep the files on
> a USB drive. I always save the file, close Libreoffice, and unmount the
> drive before removing it from the computer. I have no forewarning that the
> file is corrupt until the next time I open it. When I open the file when
> its corrupted, I get this window:
> Screenshot<
> https://www.dropbox.com/s/aak5y545qsmhe30/Screenshot_TextImport_2014-03-01.png
> >
> ​.  Nothing I try can get Libreoffice to open or repair the file. ​
> ​But​
> ​, if ​
> ​I open the file with Libreoffice 3 on my Debian system, I am offered a
> window that asks me if I want Libreoffice to repair the file. If I click on
> 'Yes' Libreoffice 3 completes the repair and I see the spreadsheet. The
> only strange thing that I notice about the repaired file is that the last
> chart I had created is only a placeholder. I then delete the placeholder
> and recreate the chart. If I then save an​
> ​​d close the file, and reopen it in Libreoffice 4, it opens fine until the
> next time it gets corrupted. I don't know how to cause the problem, other
> that to keep opening the file until it happens.
>
> Has anyone seen this problem? Is there anything I should try?
>
>
You could always try getting the latest version (4.2.1) and see if it still
happen. I vaguely recall having a similar issue in Impress, that vanished
by updating.

Other than that, it would be useful to see the file when it is "corrupted",
but that might not be possible if it contain sensitive data.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 money

[Cley Faye]

2014-03-03 10:21 GMT+01:00 :

> I donated Japanese yen through MasterCard on 3 Mar. 2014 to get
> LIBREOFFICE by your internet form ,but the softwear could not downloaded.
>
> Please send me how to download.
>

From this page:
http://www.libreoffice.org/download​​

You can download LibreOffice for your system, and localization package, by
clicking directly on the title ("Main Installer" and "Translated User
Interface"). This will open a new page that will automatically start
downloading. Donating is not a requirement, and doesn't lead to any new
download, as mentionned by the large green writing.
If the download doesn't start automatically, you can click on the link
provided in the paragraph at the top of the page. It will read something
like this:
"Your download LibreOffice_4.2.1_Linux_x86-64_rpm.tar.gz should begin
shortly. Please click the link in case it doesn't start.
You can find the optional downloads on the right.".

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Compress images

[Cley Faye]

2014-02-28 2:16 GMT+01:00 Cley Faye :

> As a "proof of concept", I put together a java program that take an odt
> file as input. You can then set the "requested" DPI and jpeg quality, and
> save. At this point, every pictures that are larger than needed (that's why
> we need DPI) are resized, and all pictures are compressed using either jpg
> or png, whichever gives the smalles size. Something as simple as that
> already have issues, like when there's transparency involved.
>  Also, it's only tested on a few files (including
> https://wiki.documentfoundation.org/images/9/96/WG40-WriterGuideLO.odtfor 
> funsies).
>
> If anyone want to give it a try here's the jar. It's highly unlikely to
> corrupt your source file (the source file is never ever written), but
> there's also no guarantee that the output will work ;)
> <http://cleyfaye.net/share/odtcompress.jar>
> For example, on the writer guide linked before, it goes from 13MB to 9MB
> with default settings. Of course it's not the best example: all pictures
> are already reasonably sized, and it's mostly screenshots so the quality
> drop is very noticeable...
>
> Anyway, if anyone want to look at the source code (without reversing the
> jar :D) I'll provide them. But know that it's mostly an ugly hack just to
> see how well it would work :)
>

​For the curious ones, I put this "tool" on github (binary & source) :
<https://github.com/CleyFaye/LOFiles/releases/tag/v0.1-alpha>​

This kind of tool is particularly useful if you're working with high-res
images, but intend to produce output at lower res. This way, you can keep
your original, and generate a file with images adequate for printing at
150dpi, another adapted to 90dpi, etc...

​As said, it should not damage anything; the worst outcome​ possible is the
output file being incorrect, so as long as you don't choose to save over an
existing file, you should be safe to try. If there is a high demand I might
keep on improving the code... :-) maybe also expand it with more tools,
like basic recovery of damaged files, things like 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] Compress images

[Cley Faye]

2014-03-05 6:57 GMT+01:00 Thomas :

> (2014/03/05 12:23), Cley Faye wrote:
>
>> 2014-02-28 2:16 GMT+01:00 Cley Faye :
>>
>>  If anyone want to give it a try here's the jar. It's highly unlikely to
>>> corrupt your source file (the source file is never ever written), but
>>> there's also no guarantee that the output will work ;)
>>> <http://cleyfaye.net/share/odtcompress.jar>
>>>
>> That looks very promising, but, please forgive the stupid question, how
> do you use it?
> I downloaded the thing (whatever a "jar" may be) and when I click on it, a
> window opens,
> asking me about the desired image quality.
> But I do not know, how to specify source and/or target files.
> How do you do that?
>
>
Hmm. I might have forgotten to include instructions in the jar, althouth
there's a readme... in the source repository :\​​

​There should be a "File" menu ​at the top of the window with "Open" and
"Save" entries. On different systems the menu might show up somewhere else
(I'm thinking mac and unity...)
Also, I see you're replying to my first message; if you want to give it a
try I highly suggest you use the last link I provided, as this version have
a few bug fixed:
<https://github.com/CleyFaye/LOFiles/releases>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] same calc sheet in 2 windows?

[Cley Faye]

2014-03-06 22:49 GMT+01:00 John R. Sowden :

> On 03/06/2014 01:34 PM, Brian Barker wrote:
>
>> At 13:20 06/03/2014 -0800, John R. Sowden wrote:
>>
>>> I have a calc sheet about 600 lines long with data at the top that I
>>> would like to see while I an using the data at, say line 400.  Is it
>>> possible to open a second window showing the data at the top while editing
>>> the data at lower lines?
>>>
>>
>> It's easier than that.
>>
>> o Click in the row header at the left to select the first row of the
>> general data - the uppermost one that you do *not* want to keep visible.
>> o Go to Window | Freeze.
>>
>> The material at the top will now remain visible whilst you scroll down
>> the rest.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>>  you trust well, I should have thought of that
>
>
To be exhaustive, it IS possible to open a second window on the same calc
sheet. In the same Window menu, you have a "New window" option. It will
open a second view that move/scroll independantly. You can then see
multiple page of the same document, for example if you have a page with all
the graphics, and a page with all the data.​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Where are the file checksums?

[Cley Faye]

2014-03-10 22:19 GMT+01:00 Girvin Herr :

> Greetings,
> I have just downloaded the 4.1.5 version.  However, I cannot find the
> file/page containing the file checksums on the website to verify I have
> good files.  Before the website had been revamped lately, these files which
> contained the checksums, sha sums, etc. were available right up front.  I
> was able to get them for 4.1.4, but not 4.1.5, so it is a recent omission.
>  Does anyone know where these files are now located?
>
> BTW: I am using  http://www.libreoffice.org/  to download from.
>
>
I believe this question was asked recently (or maybe it was on a localized
list).

Anyway, from the main libreoffice.org page, here's the step to get the
various checksums:
​​- Click on "Download now"
- Click on "Info"
The page show a list of various hash to use. Same goes for different
OS/Languages/Versions; as far as my testing goes, the Info page always
contain checksums (the 4.1.5 too).

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 worksheet stalls when opening. Solved!

[Cley Faye]

2014-03-14 11:41 GMT+01:00 William Drago :

> All,
>
> I tried Tom's suggestion and opened the file with Gnumerics. This awesome
> little program opened the spreadsheet and let me know what was wrong with
> it:
>
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.
> fidelity.com/images/savings2/alert.gif'.
> Unable to load the file 'https://retiretxn300.fidelity.com/static/
> netbenefits/common/images/nb_footer_logo.gif'.
>
> At one time I had copied & pasted some information from my retirement
> account into the spreadsheet. Unless I'm logged into my Fidelity account,
> none of these URLs will work.
>
> Now I have 3 questions:
>
> 1) Why doesn't LO tell us what the problems are like Gnumerics does
> instead of stalling for 20 minutes or more?
>

​Not sure, maybe he is just trying to open them.​ But these images load
fine without being logged anywhere (I can see them), so I'm not sure that
the problem is there. It might be related to another resource on internet
anyway.

2) Why is the timeout period so long? 20 minutes? Really?
>

​My previous statement kinda invalid the idea of a timeout (unless the
website was down all the time you tried to open the file...). But if the
issue lies in Calc behing unable to open a file with https links, the
​timeout "per file" isn't insanely high: 2-3 minutes is a fairly reasonable
value to accomodate with dead-slow connections.
But since the images load correctly... moot point :(



> 3) When we copy & paste a webpage why is LO storing links to images
> instead of the actual images?
>

I believe it's by design: it is not always desirable to create multiple
copies of the image source; especially if it's not a static image, that is
used to convey "updated" informations for example; or if you are working on
a document where graphic designers can update their work, put placeholder
in places, etc. In this regard, it keeps the URL as the image source as it
would keep the abolute file path from a file source.

Note that you can see and "kill" these links by going in the Edit menu:
Edit->Links. There you can select all links and hit "Break Links".
If the issue lies in Calc loading a file with linked images on the web,
this can avoid the issue (given you do it before saving, of course).
However, since these links are publicly accessible, a failure to load them
by Calc is likely a bug if it is confirmed.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 worksheet stalls when opening. Solved!

[Cley Faye]

I opened them in a browser, which, if everything was working correctly,
should not be different from the point of view of the server, meaning it
should provide the requested files to both. And I copy/pasted a page from a
website containing linked images into a calc file, which closed and
reopened just fine.
Now, I can't link these image specifically, as Calc just won't paste them
at all if they are not on a "complete" page (which is weird in itself).
Maybe there's something in the image format, or the fact that it's https,
that Calc just don't like. Saldy I can't test this extensively.

2014-03-14 12:26 GMT+01:00 William Drago :

> Did you try embedded those images in a LO spreadsheet to see if they load,
> or did you just open them in your browser?
>
> -Bill
>
>
> On 3/14/2014 7:00 AM, Cley Faye wrote:
>
>> 2014-03-14 11:41 GMT+01:00 William Drago :
>>
>>  All,
>>>
>>> I tried Tom's suggestion and opened the file with Gnumerics. This awesome
>>> little program opened the spreadsheet and let me know what was wrong with
>>> it:
>>>
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.
>>> fidelity.com/images/savings2/alert.gif'.
>>> Unable to load the file 'https://retiretxn300.fidelity.com/static/
>>>
>>> netbenefits/common/images/nb_footer_logo.gif'.
>>>
>>> At one time I had copied & pasted some information from my retirement
>>> account into the spreadsheet. Unless I'm logged into my Fidelity account,
>>> none of these URLs will work.
>>>
>>> Now I have 3 questions:
>>>
>>> 1) Why doesn't LO tell us what the problems are like Gnumerics does
>>> instead of stalling for 20 minutes or more?
>>>
>>>  ​Not sure, maybe he is just trying to open them.​ But these images load
>> fine without being logged anywhere (I can see them), so I'm not sure that
>> the problem is there. It might be related to another resource on internet
>> anyway.
>>
>> 2) Why is the timeout period so long? 20 minutes? Really?
>> ​My previous statement kinda invalid the idea of a timeout (unless the
>> website was down all the time you tried to open the file...). But if the
>> issue lies in Calc behing unable to open a file with https links, the
>> ​timeout "per file" isn't insanely high: 2-3 minutes is a fairly
>> reasonable
>> value to accomodate with dead-slow connections.
>> But since the images load correctly... moot point :(
>>
>>
>>
>>  3) When we copy & paste a webpage why is LO storing links to images
>>> instead of the actual images?
>>>
>>>  I believe it's by design: it is not always desirable to create multiple
>> copies of the image source; especially if it's not a static image, that is
>> used to convey "updated" informations for example; or if you are working
>> on
>> a document where graphic designers can update their work, put placeholder
>> in places, etc. In this regard, it keeps the URL as the image source as it
>> would keep the abolute file path from a file source.
>>
>> Note that you can see and "kill" these links by going in the Edit menu:
>> Edit->Links. There you can select all links and hit "Break Links".
>> If the issue lies in Calc loading a file with linked images on the web,
>> this can avoid the issue (given you do it before saving, of course).
>> However, since these links are publicly accessible, a failure to load them
>> by Calc is likely a bug if it is confirmed.
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] ODF 1.x vs 1.2

[Cley Faye]

2014-03-14 11:33 GMT+01:00 Tanstaafl :

> Hi all,
>
> Ok, I was wondering about this.
>
> How do I tell what version of the ODF standard any of my individual files
> are?
>
> I tried opening a spreadsheet (.ods) and checked File > Properties, but
> nothing in there about the PDF version...
>

​Open it with a ZIP program​. The file content.xml should start with a
"office:document-content" tag, and somewhere in there is the attribute
"office:version". I believe it contains the file version.
As far as "user friendly" goes, I'm not sure if there is a way to see this
in LibreOffice, because...


>
> Follow-up question would be, how do I convert the old to the new?
>
>
​...opening and saving the file should "update" it to the current version.
It is certainly possible to do that through a script if you have a lot of
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] Windows-Mac compatibility

[Cley Faye]

Hi,

I can't vouch for Mac compatibility, but using the same version of LO on
both Windows and Linux never gave me any trouble, except for fonts issues.
If you are careful about using only fonts available on all your systems (or
if you don't care much about this point) you can expect a smooth transition
between both OS.

-- 
Cley Faye
http://cleyfaye.net


2014-03-16 15:11 GMT+01:00 Lorenzo Pii :

> Dear all,
> I'm interested in experiences for cross compatibility between Windows and
> Mac for Calc. Is it fully compatible or only partially? I have a file on
> dropbox and I’m wondering if I’d be able to edit it both from my work pc
> and my personal mac with the same version of libreoffice. I know the best
> and clever way would be to try it myself, fact is my file has quite some
> sheets and I would like to avoid to start saving it with both machines and
> eventually find out in a month or so that something went bad in the process.
>
> Thanks a lot
>
> Lorenz
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] Master Document

[Cley Faye]

2014-03-22 21:04 GMT+01:00 Dale Erwin :

> Is there some reason why the master document does not render the
> sub-documents in the same was as they are rendered when opened separately?


​One possibility is that there is a style conflict/override.
​Master document's styles override sub-document's. If you have the same
stule name in both the master document and the sub document, you will see
the master document's version only.

This is usually a neat feature​ (you can produce various output style for
the same sub-document), but might be a bit confusing. Even more confusing
is that this include page styles too, and that point is easily overlooked.

If you simply want all styles in the master document to be the same as in a
sub-document, you can try this: open the master document, open the format
list if not already open. In the "style and format" toolbar (or sidebar),
there is a button in the top-right corner (probably called "new style from
selection" in english). Click it, and select "load styles", then "from a
file", then select one of your sub-document.
​These step should replace all styles in the master document with the one
in the sub-document. If this does fix your issue, remember to change only
styles in the master document to keep all of them "in sync".​

​Of course, if that's not the issue at hand, feel free to dismiss my little
rant :)​


-- 
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] Master Documents, Office Suites, and the Underwood

[Cley Faye]

2014-03-25 14:33 GMT+01:00 Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> I was taught K.I.S.S as a programmer, and I have not removed that idea in
> my documents.


​A small comment on the KISS concept: "simple" does not necessarily mean
minimalist, or immediately accessible, it can mean "easy" too. Even simple
things like keeping headings formatting consistent is not simple to do by
hand: you have to give every heading the same formatting (font size,
characters modifiers...), and if you need to change them for some obscur
reason, you have to loop over all your headings by hand to do so. Surely as
a programmer you can see the problem here :)


Now, if you're not familiar with styles, you'll see them as "hidden"
formattin aide, or think they have changes "buried" deep down. And indeed,
it is possible to do extremely complicated things (know that styles are
cascading, can inherit from their parent, and the final formatting of a
character is a combination of page style, paragraph style, character style,
paragraph formatting and character formatting).
But it doesn't mean you have to go all out with this. You can have a flat
list of two-three styles and stick to them. They will sit there, on the
right of you screen (or wherever you've put the style toolbar). Nothing's
hidden, nothing's buried in the depth of style micro-managing... and *that*
is what some peoples (including myself) see as the "simple" part of KISS :)

​If you're mixing style and direct formatting though, there you're asking
for trouble. It's possible too, but at this point you have to remember too
many layers of formatting (in my opinion).

But, LO was made to be a office suite.  Writer was made to be a word
> processor.  Sure you can go "all out" and use it as a desktop publisher and
> other document formatter that does strange an wonderfully eye-catching
> things to the text, but do we all need to learn how to do those things?  Do
> we all need to use them to create and format our documents?  No, I should
> hope not.


You point out that LO is an office suite, and not a desktop publisher...
but the thing is, it is. As with everything you don't have to use all these
functionalities, but they are present, and used by many (even on this list
we get every once in a while someone with some questions regarding
publishing with LO).​ But, if you don't have to learn how to use them, you
have to know they exist to avoid misusing them. If one keep all it's typing
in the "standard" style and does everything by hand, it's fine, but if you
start mixing both, and then push them in a master document, you should know
what to expect, even if you don't want to use this.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] shutdown glitch

[Cley Faye]

2014-03-26 13:32 GMT+01:00 rmg :

> When you shut down after pressing [Goodbye] (which you do, it's a
> dedicated machine) you get '/usr/lib/libreoffice/soffice not responding'.
> If you close the front end with the close button you don't - but then it
> doesn't do its cleanup.
>
> Any suggestions?
>

​You should check the macro to find how it's closing libreoffice (which
function is called or something like that). Maybe there was a change in API
since the OOo time and it is dependant on something deprecated/broken.​


-- 
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] shutdown glitch

[Cley Faye]

2014-03-27 23:52 GMT+01:00 rmg :

> ​​
> if HasUnoInterfaces(doc, "com.sun.star.util.Xcloseable")
> doc.close(TRUE)
> else
> doc.dispose()
> End if
>
>  as I said lifted straight from the macro examples; the Libreoffice API
> reference seems to say that's right.
>


​I'm not very fluent in LO API, but according to the documentation (
http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1util_1_1XCloseable.html)​
XCloseable.close() must be called before XComponent.dispose(), so maybe you
can try this:


​
if HasUnoInterfaces(doc, "com.sun.star.util.XCloseable")
doc.close(TRUE)
End if
doc.dispose()


​Also note that it's XCloseable with a capital C. I don't know however if
it's case-sensitive (the doc seems to say it's not) but it wouldn't hurt to
check this too :)​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Errors in LO 4.1 but not in LO 3.5

[Cley Faye]

2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge :

> My macro is expecting a single value, but under v4.1 it has three values,
> so it's obvious why it is throwing the error.
>
> In both cases I have used the Java version 1.6.0_29, so I cannot work out
> why there is this difference in the way the OdateModel object is storing
> its Current Value.  I could test for the Current Value's Type each time and
> extract the date with appropriate code.  But this doesn't seem to be the
> right way to go.  And there could be other variances between the LO
> versions that I haven't come across yet.
>
> I am running an H2 Database on Windows 7 64 bit.  Can anyone spot what I
> might be doing wrong with my Java settings in LO v4.1?
>

There ​was a change in date objects:
 (look for "Changes
to UNO APIs")

​This looks like the culprit in your case. The best course of action is
likely to update your code to follow these changes (either a quick fix to
"reproduce" the old value, or more long-term fix in the code around 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] Errors in LO 4.1 but not in LO 3.5

[Cley Faye]

2014-03-29 21:29 GMT+01:00 James E Lang :

> Oh dear! So let me get this straight. Old macros might not work with newer
> versions of LO.
>
> I realize that backward compatibility leads to "bloat" when carried to the
> extreme but shouldn't the older specification be deprecated but still
> supported through two major versions (e.g. version 3.x specification
> deprecated through version 5.x) or maybe for two years? And shouldn't there
> be a stand alone migration tool? And shouldn't a library of these tools be
> available online indefinitely?
>

​This is complicated, and usually things are done this way. However, at the
time this change happened, there where a lot of warnings about it, because
it changed the behavior of existing functions. You can't really mark
"deprecated" a function and replace it with another function using the same
name/interface. And having something like a DateTime2 interface to
"supersede" DateTime would only lead to more bloat, the exact thing we
don't want when facing this kind of changes.

To be fair, this is a relatively rare case, and is well documented. It is
still annoying when you hit that in your code, but sometime it can't be
avoided.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] MSO for iPad, big deal or big yawn

[Cley Faye]

2014-04-02 18:00 GMT+02:00 Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net>:

> I haven't got any smartphone, so I'm just wondering: what use for office
> software on such a small screen as a smartphone one? Is the software
> usable at all?
>

​On a smartphone? Maybe the ability to read a document is interesting, but
that's it.

However, tablets have decent screen estate, and can easily be combined with
mouse/keyboard as needed, while being more convenient than a whole laptop.

-- 
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] old versions

[Cley Faye]

2014-04-12 1:02 GMT+02:00 Tim Lloyd :

> My simple solution is to install 3.5.7.2 on his desktop. Maybe he gets
> lucky and it is available through the package manager (it isn't in Fedora
> 20).
>
> So I had a look at the download section of the website which only offers
> the 4.x series. Any ideas how I would go about downloading 3.5.x versions
> of LO?
>

​Short answer:
http://downloadarchive.documentfoundation.org/libreoffice/old/

Long(er?) answer: update to newer version, check files, fix small things
that's not right (if needed of course...). It's some work, but way easier
than keeping old versions in the long term :)​


-- 
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] Any reason why resizing an image does not keep aspect ration by default?

[Cley Faye]

2014-04-12 20:48 GMT+02:00 Simon :

> Is my use-case so strange and unusual ?
>

​No, not unusual at all. I have a hard time imagining use cases where you
don't want to keep the aspect ratio.



> Do common people most often need to
> flatten the image and not keeping their ratio ?
>

Far too often I'm working with peoples just trying to fit an image
somewhere. They would probably find it hard to understand why the image
shrink in both dimensions when they are pulling only one way. It is sad but
it happen.



> Why this default behavior is
> not even configurable?
>

​That I can vouch for. Whatever the rationale behind the default behavior
is, having an option to change it seem reasonable.

There is a lot of options that would seem "obscur" but would greatly
increase flexibility. Perhaps it would be reasonable to have two option
dialogs: the current one, which is relatively "user friendly", and a second
one, more like the "about:config" page in firefox.

-- 
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] Retrofitting a template to a document

[Cley Faye]

2014-04-17 7:37 GMT+02:00 Toki :

> Can somebody point me to an easy way to add the source template data back
> to the file?


​Look for the "Template Changer" extension; it should do what you want.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 file size suddenly by 400x

[Cley Faye]

2014-04-17 12:29 GMT+02:00 Thomas Blasejewicz :

> I do have a not so big Calc file for my personal "accounting" (keeping
> track of my work)
> The one from last year was about 160 kb. This year's contains naturally
> less data.
> And that suddenly jumped to 27 MB and file constantly crashes.
>
> Copying the data into a new few file gives me about 78 kb.
>
> Where does that giant data package of 27 MB suddenly come from?
> Can I get rid of it?
>

​Hi,

Do you often copy/paste data? It is possible that some behavior changed
regarding this.

Anyway, to find exactly what is taking so much space, you can try this:
- Copy your file somewhere (just to be safe)
- Rename it to .zip
- Open it
There, you should be able to see what file take that much space. If it's in
contents.xml, then it will need further examination, but if it's in another
file, it might be easier/quicker to deal with.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 for Chrome OS - i.e. Samsung Chrome Book

[Cley Faye]

2014-04-17 14:43 GMT+02:00 Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> So I ask if there is any movement towards making a Chrome OS port.
>
> Actually this Samsung Chrome uses a microSD card for "some" storage.  I
> cannot tell much about it, since I do not have access to the manual.  So
> the version of LO would need to fit on a microSD card storage, like a
> tablet, but it is not a tablet. This is really a really small net-book like
> device running Chrome OS.
>

​As far as I know, making an application for ChromeOS is roughly the same
as making an "application" (note the quotes) for Chrome. This mean it's
mostly html based and javascript driven.​ Porting LO to this kind of
platform mean two things:
- We get an awesome, cross-system, cross-platform office suite
- We have a insane amount of work, need to rewrite *everything* from
scratch, redo the UI, handle the strict restriction of browser-based
applications... I'm sure you see what I mean :)
It *might* be possible to run some binaries part, as it is possible with
some restriction for Chrome app/extensions, but it remain a formidable task.

Honestly, I wouldn't hold my breath for a port of this kind for three
reasons: it's a huge task, there's little incentive to do it (way less than
an android port for example), and there's a solid alternative.

First alternative (easier): it is possible to install Ubuntu (or other
linux OS) on a chromebook. I did that long ago, and there's a handful of
tutorials on how to do so. If your chromebook is Intel based, it's even
better, but as far as LO is concerned, it can be installed on ARM devices
too.
Second alternative (trickier): there's way less tutorials, but I vaguely
remember the possibility of using real software in chromeos, mainly through
command line. However I don't have any more info, and I'm not sure that it
isn't restricted to command-line stuff (I'm not even sure that chromeos use
an X server).

Also, regarding storage space: for previous models, it was a really good
idea to replace the (really) small hard drive with a better one. I don't
know the specs of the newest chromebooks, but it's worth checking.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 file size suddenly by 400x

[Cley Faye]

2014-04-17 15:26 GMT+02:00 Thomas Blasejewicz :

> I am afraid, I do not understand.
> Renaming the file to "current name.zip" does not change anything.
> Creating a Zip Folder/file generates only ONE folder, containing ONE file
> = the calc file. Size as stated.
> I cannot see any XML file anywhere 
>

​You have to change the file extension from ".ods​" to ".zip". If you're
under windows, the file explorer probably hide the file extension, so you
have to unhide them (it's easy, the procedure is described here:
http://support.microsoft.com/kb/865219/en)

Once you can change the file extension to zip, you should be able to open
it and see how files are laid out. You'll have something that ressemble
this structure: http://i.imgur.com/eAEuZZ5.png​​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 for Chrome OS - i.e. Samsung Chrome Book

[Cley Faye]

2014-04-17 16:40 GMT+02:00 Don Myers :

> The other way is to use Crouton, where you are actually running Ubuntu
> through the Chrome OS


​Ah, thanks for that. The name slipped my mind, and I might need this soon
too, for roughly the same reason :)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Heartbleed

[Cley Faye]

2014-04-17 21:52 GMT+02:00 Tanstaafl :

> This is an OpenSSL bug, what does this have to do with Libreoffice?


​As far as I can tell, it's because LibreOffice was linked with a
"vulnerable" version of openssl.

It's never bad to be on the side of precautions by using the latest
versions (especially if it provides bugfixes), but I'm not sure how an
exploit on the server side of a TLS connection could cause issue in a
client software. Better safe than sorry I suppose.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: LO for Chrome OS - i.e. Samsung Chrome Book

[Cley Faye]

2014-04-18 11:39 GMT+02:00 Urmas :

> "Cley Faye":
>
>> First alternative (easier): it is possible to install Ubuntu (or other
>> linux OS) on a chromebook.
>>
>
> So you propose to the person to turn her expensive device into brick by
> voiding its warranty? Seriously?
>

​Yes, seriously. Sorry if you're shocked.
And the fact that you decide to install custom software on *your* *own*
hardware doesn't mean that you're voiding your warranty just because the
manufacturer told you so. Not all countries have similar laws regarding
this.

Does I sound a bit extreme here? It's hard to tell, you thrown off my
balance by saying that voiding a warranty turns a device into brick. Last
time I installed a piece of software on it, my chromebook was much less
brick-y than you imply.

Maybe If I did suggest to install windows instead of a linux, your view
would differ?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Heartbleed

[Cley Faye]

2014-04-18 11:59 GMT+02:00 Tanstaafl :

> You are wrong, so need to do a LOT more reading.
>
> But again... in what way does Libreoffice utilize TCP/UDP connectivity?
> What am I missing? Does it have a hidden built-in SSL client?
>

​Ahem. Some *hidden* features, like, retrieving data from URL maybe? URL
that may or may not contain the "https" protocol, thus needing some form of
SSL/TLS handling?​ Like images, or custom data sources?

Looks like a lot of peoples need to do a LOT more reading.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 for Chrome OS - i.e. Samsung Chrome Book

[Cley Faye]

2014-04-18 18:28 GMT+02:00 Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> Android's market share is increasing while Windows is going down. Chrome
> OS is increasing as well, but its market share is not as strong as Android
> [so far].  IT would be nice to get into that market share for LO, when
> possible.
>

​You know... ChromeOS is sort of important. ChromeOS "apps" are basically
the same as Chrome "apps", so I'd say their market share is more like...
34-46% theoretically (
http://en.wikipedia.org/wiki/Usage_share_of_web_browsers)
It isn't a fair comparison, as the software is available in some other
forms where the Chrome browser is available, but it could be an incentive :)



> I do not know how well LO works with Win8, since I only used it for about
> 10 minutes for trying to setup a package for someone and thought it was
> worse than Unity, and I hate Unity.
>

​It works more or less like in windows 7. No "metro" support, so you're
back to the plain windows look (with all of the drawbacks of W8, but that's
not the place to discuss this...).


>
> Windows - yes
> Linux - deb and rpm
> Mac - Intel only for the newer versions
>
> Android tablets - use an AOO/OOo based or other version[s] for Android
> that is available, for now.
> iOS - told it is being looked into
> ChromeOS - not in the future plans, so far.
>

​That's a good summary so far. Note that LO peoples are working on Android,
although it's not at the "beta" status yet (
https://wiki.documentfoundation.org/Development/LibreOffice_on_Android).
But I can vouch for a *viewer* that would handle correctly files. It might
be easier to do (less UI work, no edition code maybe). It would be a great
step toward general adoption of opendocument format. But, again, I'm
starting to digress.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Can't download from TDF

[Cley Faye]

2014-04-19 4:19 GMT+02:00 MR ZenWiz :

> Fixed, sort of - I went to the archive and could get it from there.
>
> But, really, shouldn't the download page just work?
>

​If works for me (at least for the windows version). Maybe you hit a
temporary downtime?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Documentation

[Cley Faye]

2014-04-23 23:49 GMT+02:00 Dale Erwin :

> I was searching via google for LO documentation and I found
> "WG40-WriterGuideLO.pdf".  However, when I clicked on it, I received a
> document with 468 blank pages.
>
> This was the URL: https://wiki.documentfoundation.org/images/
> 3/35/WG40-WriterGuideLO.pdf
>

​I suspect a corrupted download, as the file is fine here.
​Check that the file you downloaded is ~12MB (​12 229 962 bytes). You can
even go further and check the CRC (672C5CCC), but the size is usually
enough to detect an accidental download fluke.


-- 
Cley Faye​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Remove Properties and Personal Information

[Cley Faye]

2014-04-28 4:40 GMT+02:00 Joe B :

> I realize this is much more a Windows 7 problem than a LibreOffice problem,
> but so was my last question :)
>

​It's not a "more W7 than LO" problem, it's a "W7 only" problem...​

It would seem to me that if I have Full Control permission, then the
> Special Permission check box should be check-able (not grayed out), but
> it's not check-able, and it is grayed out.  What am I missing?
>

​The NTFS rights management. You can have full control over a file, but
can't do everything. You can be the "administrator" user, and not have full
control. You can be the owner of a file, and still be unable to modify it.
You can give *all* rights to the "Everyone" virtual user, and still not be
able to access the file without an user account on the system.

The worst thing is, I'm not joking here, these things are real. The only
option as far as I know is to effectively give yourself extra rights either
through all the dialogs madness or with the "icacls" command line tool.
Both methods are overly tedious in my opinion, but that's just the way it
is.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Remove Properties and Personal Information

[Cley Faye]

2014-04-28 16:19 GMT+02:00 Joe B :

> Of course, the F permission is "Full Access" which I already have.  I am
> just showing what I have already tried.
>
> How might I modify this statement to include "special permissions"?
>

​Sorry, I can't help you further with the windows command line tools, as I
don't use them very often.​
​What you can try is to set the appropriate permissions on a file through
the GUI, and then run icacls on it without arguments. This should show you
the current file permissions per user, and can give you the info you need.
As far as I remember, icacls is good to manage the "generic" access
properties, but can also show information about extended metadata, which
might be what you need there.

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

Re: [libreoffice-users] Draw & PDF Files

[Cley Faye]

2014-05-08 16:02 GMT+02:00 Brian A. Colucci :

> We are running Libre Office 4.2 under Linux Mint 14.  Draw states that it
> is capable of opening PDF files.  This functionality is a bit sketchy.
>  Either the document will not display at all in draw, or it displays with
> all of the fonts, and page layouts askew.  Is this a known issue, or just
> unique to us?


​I have yet to see a PDF that is not displayed in Draw, so that might be a
specific issue you have.

However, here's my experience with it so far: PDF in Draw have always felt
more like a hack than anything. It doesn't seem to handle embedded fonts,
and for fonts available on the system, the rendering is different,
including different spacing between letters. Images and various graphics
elements tend to get out well, but from time to time you'll come across a
graphic that's on the wrong side of a page.


This behavior have been relatively consistent between LO version since PDF
opening was introduced, and to be fair the very nature of a PDF, especially
how the format is laid out internally, makes "opening" them for edition
quite a challenge.
​This tool is still useful for some use cases, tough, and I've used it some
times, mainly to extract graphics without losing quality. But it's not a
"PDF editor", at least not yet (obstacles can certainly be overcome, but
that's not what I'd call a priority in an Office edition suite. my 2cts of
course).​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 users list

[Cley Faye]

2014-05-09 1:59 GMT+02:00 :

> Did this site die or is my mail program in need of
> replacement/resurrection?  I have not received any messages since 4-24-14.
>


​I don't know about your mail program, but the list is very lively. Last
message is from less than an hour ago.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Draw problems

[Cley Faye]

2014-05-09 23:45 GMT+02:00 Girvin Herr :

> I am using Linux LO 3.6.7.2.  I see that Draw still has problems rendering
> drawings correctly as an embedded object.
>
​[...]​
>
> Does anyone have a better solution?
>

​The first thing to try is to use a more up to date version.​ Current
version is 4.2.4, and although there is no guarantee, there's a fair
possibility that your issue is fixed, or at least mitigated. Even if it is
not the case, filling a bug report against the latest version have more
chance to see it fixed.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] ss not expanding excel csv sheet to multiple columns

[Cley Faye]

2014-05-13 20:32 GMT+02:00 John R. Sowden :

> I have a vendor who allows me to download a spreadsheet of my monthly
> invoice.  If she downloads it to herself, in the CSV format, she gets 1
> field per column in Excel.  If I download the sheet in the CSV format, I
> get all of the fields in 1 column.  See headings below from libreoffice.
>
> Hardware Identifier","Device Type","Price","Initial Service Start
> Date","Station Account","Customer First Name","Customer Last Name
>

​When​ you open a CSV file, a dialog appear asking you for many options.

From the look of your post, you have to choose "Separated by", "Comma", and
set Text delimiter to double quote ("). You can try this, but to be sure
having the actual csv file, even with only the first lines, would be useful
(unless it contains sensitive data of course).

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] [Draw] Confused about how to render rotated text

[Cley Faye]

2014-05-14 17:55 GMT+02:00 KARR, DAVID :

> I can't figure out how to render a short piece of rotated text. The
> instructions I saw referred to a "text" icon. In the Draw app the only one
> that comes close is the "Label Field" in the "Form Controls" toolbar. The
> later instructions for selecting that for rotation just don't work.
>
> What am I missing?
>

​Writing rotated text in Draw:
1 - In the "Drawing" toolbar, select the text icon (if the ​Drawing toolbar
is not visible, show it first from the Display->Toolbars menu):
http://i.imgur.com/n52PGyo.png
2 - Place your text somewhere
3 - Right click in the hashed outline of the text object, then select
"Position and sizing" (not sure about the english translation, but you get
the idea)
4 - In the "Rotation tab, you can set the angle you want (
http://i.imgur.com/wB1ZQkg.png)

And the result: http://i.imgur.com/rucFDqj.png

I believe this answer your question.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Option to output the .ods underlying XML files auto formatted?

[Cley Faye]

2014-05-17 23:45 GMT+02:00 Jiergir Ogoerg :

> Unfortunately all the XML files (which make up the .ods files) aren't
> formatted by LibreOffice so I have to waste
> a lot of time formatting them by hand to be able to analyze the contents.
>
> Is there any option in LibreOffice to make it generate _formatted_
> underlying XML files?
>

​I don't think such an option exist, as it would serve little purpose since:
- Most xml "viewers" are able to format the files on the fly
- There exist tools that can do it, like xmllint. You can easily script the
whole process with the language of your choice.

A dirty example using bash shell scripting, that would extract the ods
content and clean the xml in-place:

#!/bin/bash
> ODSFILE="$1"
> TMPFILE=$(mktemp
> ​)​
>

unzip "$ODSFILE"
> for i in $(find -name '*.xml')
> do
> mv "$i" "$TMPFILE"
> xmllint --pretty 1 "$TMPFILE"
> ​> ​
> "$i"
> done


that should be way easier than to add an option to pretty-print internals
in LibreOffice...

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Issue install on a a Dell

[Cley Faye]

2014-05-19 1:19 GMT+02:00 Wade Smart :

> Trying to install LibraOffice, Im having this problem.
> It says its installing - it skips to installed. No icons.
> No program files were created.
>
> When I run the install program again it shows either
> repair or remove - so it things its installed.
>

First, make sure that you downloaded LibreOffice from the official website:
www.libreoffice.org (or one of the localized variant, xx.libreoffice.org)​.
Also make sure that you didn't download the help package by mistake. Both
files (the main installer and the offline help installer) are MSI files,
but the main installer is quite larger (around 200MB).


If you're sure you have the right file, maybe the download got corrupted.
You can check it's exact size and some hash values used to validate a
download here:
http://download.documentfoundation.org/libreoffice/stable/4.2.4/win/x86/LibreOffice_4.2.4_Win_x86.msi.mirrorlist

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 4.2 Proposal.

[Cley Faye]

2014-05-21 15:06 GMT+02:00 Gilbert Wuytack :

> LibreOffice 4.2 offers a new Start screen, and shows a preview of the last
> documents.
>
> Indeed, that is correct but I do not think it's good that everyone can
> open password protected documents without entering the password from this
> preview!
>
> This gives me a sense of insecurity and wonder whether it would not be
> better asking the password if the file is protected by a password.
>

​I just did the following:
- Started LibreOffice
- Created a new document, typed a few words, then saved it
password-protected
- Closed it to return to the start screen: no preview image, and when
clicked it ask for the password
- Closed libreoffice, started it again: still no preview image​, still
asking for password
I'd say that the start screen doesn't bypass the password protection
mechanism in any way: it doesn't disclose a preview of the document, nor
keep an unencrypted copy anywhere.

Maybe I misunderstood, but I don't get the problem 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] Re: Full justification

[Cley Faye]

2014-05-24 22:25 GMT+02:00 william drescher :

> I forgot to mention: if you have already typed the text you want
> justified, you have to highlight it when clicking on the justify button.


​Technically, it should work by just having the cursor in the paragraph, as
the justification is a paragraph property. If it doesn't apply the
justification to other lines, then indeed your lines are not part of the
same paragraph (e.g. the return key was used somewhere).​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Export all pages as PNG in one go?

[Cley Faye]

2014-05-27 12:53 GMT+02:00 Gilles :

> When opening the file in LibreOffice Draw, I can select each page and hit
> File > Export to get a PNG file, but it appears that it's not possible to
> select all the pages with CTRL, hit Export, and get the pages as
> independant
> files as eg. Page1.png, Page2.png, etc.
>

​I believe that LibreOffice is not the appropriate tool to do this, as it
is not a PDF editor.

There is other tools far more efficient for this, that can render an almost
pixel-perfect output of your PDF files, like imagemagick. It is also
available for windows: http://www.imagemagick.org/script/binary-releases.php

Once installed, you can use a single-line command to do the conversion:
"convert -density 300 input.pdf output.png" will convert the PDF to a
series of PNG files, as if the PDF was rendered at 300 dpi. Usually, using
96 dpi gives acceptable results for display, but it depend on your goal.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Page Break and Page Break with new Style

[Cley Faye]

In addition to the other response, it is good to know that page breaks
inserted manually are defined in the Paragraph style immediately following
the break. You can access this property through two mean:
- Right click on the paragraph at the top of the new page, select
"Paragraph..."
- Put your mouse cursor on the page break (on my system, it's a blue dotted
line between pages), and when the contextual arrow shows up, click and
select "edit page break"
Both ways will open a dialog with a "Text flow" tab containing the page
break, with the possibility to add/change the page style and numbering.

It is particularly useful to know when working with master document, when
you need to track a rogue page break that appear at the beginning of
sub-documents.

-- 
Cley Faye
http://cleyfaye.net


2014-06-11 10:03 GMT+02:00 Brian Barker :

> At 09:24 11/06/2014 +0200, Fernand Vanrie wrote:
>
>> Found that using "Cntrl + Enter" produced a Page Break without the
>> possibility to change the Page Style on the new page. Is there also a short
>> cut key combination to make a Page Break with new Style ? what now must
>> been done with  Insert >> Manual Break >> Page Break with new style
>>
>
> Perhaps depending on your operating system, Alt+I, B should bring up the
> Insert Break dialogue. Pressing P will select "Page break" and S the Style
> drop-down. The arrow keys will then move through the list of available
> styles.
>
> Alternatively:
> o Go to Tools | Customise... | Keyboard.
> o Under Functions | Category, select Insert.
> o Under Function, scroll down to and select Manual Break.
> o Under "Shortcut keys", select your chosen shortcut.
> o Click Modify and OK.
>
> 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

Re: [libreoffice-users] Page Break and Page Break with new Style

[Cley Faye]

2014-06-11 18:01 GMT+02:00 Brian Barker :

> At 15:35 11/06/2014 +0200, Cley Faye wrote:
>
>> In addition to the other response, it is good to know that page breaks
>> inserted manually are defined in the Paragraph style immediately following
>> the break.
>>
>
> I think you mean in the paragraph's own *format*, not in the paragraph
> style of that paragraph.


​That is correct, thanks for the correction. I'll rephrase: inserting a
page break change the following paragraph's own style, and you can modify
the page break there afterward.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] SAve powerpoint presentation as executable

[Cley Faye]

Unfortunately, not directly.

And there is (as far as I know) no simple "viewer" that could be used for
this purpose, although it might be an interesting development challenge.

As for now, your best four options are:
- Have a portable version of LO at hand. It take some space but is not
unreasonable, and can be launched from most computer you'd have to run a
presentation on
- Export to PDF. Most systems can read PDF, and it guarantee you a (mostly)
perfect render of your presentation, with no surprise. Downsides are: no
transitions, no animations.
- Export to SWF. As a second choice after PDF, since most computer have
some way of reading SWF. Still no transition/animations
- Export as HTML (and not XHTML that doesn't seem to work for me). Still no
transition/animations, but seem to work for simple stuff (including
images), and is mostly guaranteed to work anywhere (including mobile
browsers).

Out of these four options, I'll suggest the first two, as coming across a
computer that doesn't have a PDF reader is uncommon nowadays.

-- 
Cley Faye
http://cleyfaye.net


2014-06-17 20:44 GMT+02:00 Pikov Andropov :

> Can LO produce an executable file from a PowerPoint presentation, so
> that no viewer is needed at the time the presentation is presented?
>
> 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] Save Powerpoint presentation as executable

[Cley Faye]

2014-06-18 2:37 GMT+02:00 Brian Barker :

> Unfortunately, not directly. And there is (as far as I know) no simple
>> "viewer" that could be used for this purpose, ...
>>
>
> On the contrary, if the target platform is Windows (but not other
> operating systems), it can use the freeware Powerpoint Viewer from
> Microsoft:
> http://www.microsoft.com/en-us/download/details.aspx?id=13 .


​While this can be helpful for peoples having to go back and forth between
the odp and the ppt format, I have a hard time considering that a ppt
viewer is a viable alternative to view odp files. Saving a LibreOffice
presentation as a Powerpoint ​
​file can lead to all sort of rendering issues and surprises. ​Also, it
looks like this need to be "installed" on the system.

It would be nice to have an autonomous, minimalist binary for this purpose.
If you can install software on the target computer, might as well install
LO directly.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Loading each document about 3 minutes

[Cley Faye]

2014-06-20 11:53 GMT+02:00 Cigydd :

> Note: I post here because I am not absolutely sure that this is a problem
> on
> the antivirus side.
>

​An easy way to check this is to temporarily disable your antivirus live
protection and try to open the files. As long as you don't wander on shoddy
websites or plug unknown usb keys in the process it's pretty safe.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Loading each document about 3 minutes

[Cley Faye]

2014-06-20 13:46 GMT+02:00 Cigydd :

> So is there any solution to my problem except having the two computers
> which share that two disconnected printers always turned on or switching
> them on each time I need to work with LibreOffice on the third computer
> (which is a notebook)?
> I know, this sounds crazy but this is Microsoft.
>

​I can't tell for sure if that's the culprit, but if it is, you might be
able to mitigate the issue by installing a virtual printer like a pdf
printer (if you don't have one already) AND setting it as the default
system printer. This might help, as the default printer asked for
properties should always be "present" now.

Of course, if that's not the cause of the issue, I have no idea. Does this
happen with every document, or just a handful/documents in specific
folders? There's two things that comes to mind: either some document got
exceedingly complex from the parser point of view (usually happen when
switching back and forth between different formats), or some other windows
magic is at work. (I don't exclude a possible bug in LO, but since it's a
relatively rare problem, it's more likely due to some strange interaction
than due to LO in itself.)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Loading each document about 3 minutes

[Cley Faye]

2014-06-20 22:44 GMT+02:00 Cigydd :

> So does somebody have an idea what's causing the remaining delay by
> loading the ODS spreadsheets?
> One of the files contains about 30 sheets, each of them 1-3 pages long.
> But it can't be the cause because the other file contains only 1 sheet
> with 4 rows.
>

​Knowing that the printer issue is still real (and fixable somehow) is good
news.

Now, as to why some specific files take longer to open, there's too many
causes to rule out, and some of these causes might even be invisible.

Maybe there's a lot of complex formula that gets calculated when loading,
maybe there are macro that run when opening these files, or maybe it's
something else (although I believe there is an option to not compute
formula automatically... this might need to be tested).

It might be impractical for the 30 sheets document, but you can try this:
select all content from the 1-sheet document, and copy/paste it in a new
calc file. Then, check how long this new file take to load...

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Sponsoring improvements and bug fixes

[Cley Faye]

2014-07-01 16:46 GMT+02:00 Andrew Beverley :

> This is the real issue. I don't doubt it's good value, but I probably
> should have explained my situation: at the moment I'm a single
> individual trying to move small companies onto Libreoffice. Money for
> the fixes will come straight from my own pocket, so my budget per fix is
> more like several hundred dollars than several thousand. If there is no
> hope of *anybody* working for this, then please let me know.
>

​Unless having a very specific corner-case,​ it is very possible that
you're not alone having this issue. It might be interesting to have some
place to regroup funding for fixing such bugs. Kinda like crowdfunding, but
with bug reports instead of projects.


However, I can very well see this being misused with either tons of bogus
bug report, or getting targeted as "LO is not free anymore" or something.
Maybe in your case you could mention in the bug report that you're looking
for people that need this fixed, and can contribute toward this goal. $8k
is a huge amount, but if multiple individuals/small companies are facing
this issue and really wish to see a fix, it might be feasible.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Disappearing manual page break in master document

[Cley Faye]

Master/sub documents issues can be tricky to debug, but here's two things
to check:
- Setting the next page numbering to 0 essentially mean to ignore the
setting, so the next page will have whatever number should come. This might
be the issue.
- If possible, open your first sub-document, right-click in the very first
line of this document, select "Paragraph" and add a page break by hand
there, selecting the page style and setting the numbering to start at one.
This should stick when merged with the master document.

-- 
Cley Faye
http://cleyfaye.net


2014-07-03 22:40 GMT+02:00 Erik Jan :

> These days I am trying to make a master document. I made a template for
> it, and from this one I derived a template for the subdocuments by leaving
> out the the pages proper to the master document.
>
> In the master document I have defined:
>
> first page and its verso
> title page and its verso
> dedication page and its verso
> index page and its verso
> Right pages and left pages
> right pages word index and left pages word index
> back page right and back page left.
>
> Under the index page I insert a manual page break to be followed by the
> index verso page with page number 0, so that the first right page of the
> subsequent chapters to be inserted start at page 1.
>
> Every time I insert a new subdocument the manual page break loses its
> renumbering, so that the following pages start at number 9.
>
> What am I doing wrong?
>
> Greetings,
>
> Erik.
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] different font size in different files

[Cley Faye]

2014-07-10 8:33 GMT+02:00 John R. Sowden :

> I have tried to standardize on freesans 10 point for most ss uses.  I just
> came on a file with very small type size, yet when I selected the cell and
> the format -> font, I got freesans 10 point.  Not wanting to diagnose
> myself as blind and/or crazy, I brought up another file with the same
> freesans 10 point, and they are clearly different.
>
> why?,
>
>
​Just a guess: the zoom level is stored in the file. Have you checked that?​

​It is visible in the bottom right corner of LO window, or in the
Display/Zoom menu.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] which version has the best legacy importing?

[Cley Faye]

2014-07-12 20:10 GMT+02:00 Kracked_P_P---webmaster <
webmas...@krackedpress.com>:

> The files are .sig
> which might be something like Printshop or other software that was out
> there in October 2005 when the files were made.  There is a cover.sig, p1 -
> p13.sig, and a toc.sig file names.
>
> Right now I have them on my Linux desktop, but will need some conversion
> or viewer for Ubuntu/Mint or Windows 7.
>
> Any ideas?
>

​You might have a hard time to get something out of them...
According to this (
http://whatis.techtarget.com/fileformat/SIG-PrintMaster-graphics-file), it
might be Printshop files, but ​there doesn't seem to exist much other
software that can open them. Even (paying) recent version of these software
are not guaranteed to be compatible with older formats (according to
wikipedia, http://en.wikipedia.org/wiki/The_Print_Shop).

​You can always try to feed them in imagemagick, to see if it can convert
them to something exploitable. But I don't think LO will be able to eat
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] which version has the best legacy importing?

[Cley Faye]

For my curiosity, if one of those file happen to not have any sensitive
information, would it be possible to have a copy of it? I'm curious about
this file format... It's supposed to be an "editing" format, but most
information indicate that there are only converters to flat image formats...

-- 
Cley Faye
http://cleyfaye.net


2014-07-12 20:55 GMT+02:00 Robert Funnell :

> A quick Google search indicates that your suggestion of PrintShop may be
> close to the mark. It seems that the files are probably image files and not
> word-processing files. Apparently there are image-conversion programmes
> available out there that can handle these files.
>
>
> On Sat, 12 Jul 2014, Kracked_P_P---webmaster wrote:
>
>
>> OK everyone, I received the USB floppy from China, today.
>>
>> The files are .sig
>> which might be something like Printshop or other software that was out
>> there in October 2005 when the files were made.  There is a cover.sig, p1 -
>> p13.sig, and a toc.sig file names.
>>
>> Right now I have them on my Linux desktop, but will need some conversion
>> or viewer for Ubuntu/Mint or Windows 7.
>>
>> 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] Is version 4.1.6.2 insecure?

[Cley Faye]

It might be related to this:
https://www.libreoffice.org/about-us/security/advisories/cve-2014-0247/

In this regard, it might be insecure because a macro can get executed even
if the user settings should prevent it to happen.

Regarding the "insecure" aspect, well... macro are a programming language,
and as such can do nasty things by themselves, or expose other
vulnerabilities (that's why their use is usually discouraged). If you only
open documents from "safe, known and reliable sources" the impact should be
minimal, but it's better to be on the side safe of things by updating.

-- 
Cley Faye
http://cleyfaye.net


2014-07-12 19:38 GMT+02:00 Jay Lozier :

>
> On 07/12/2014 05:55 AM, . wrote:
>
>> To whom it may concern:
>>
>> LibreOffice 4.1.6.2 is detected as insecure by Secunia PSI. Advisory
>> SA57383 (Macro Vulnerability). Would you be so kind as to let me know why
>> this stable version is insecure, but the fresh version 4.2.5 is secure?
>> Thank you for your timely effort.
>>
>>  Can you supply more details. Secunia has a paywall.
>
> Macros are a well know security hole in all office suites. They
> potentially allow arbitrary code to be run on an end users computer when
> the file is opened. For older MS office suites, the default was to run all
> macros when the file is opened. Recent (after 2005 or so) the default
> behavior was changed to only allow "trusted" macros the privilege of being
> allowed to run.  I do not know how common this was with other office
> programs/suites of the same vintage.
>
> I believe LO has always used the model of the "trusted macro only" being
> granted privileges by default.
>
> Under TOOLS>OPTIONS>LibreOffice/Security click on "Macro Security". Set
> the security level to high or very high. This will restrict macros from
> running unless they trusted. This setting works for any macros.
>
> --
> Jay Lozier
> jsloz...@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] Re: different font size in different files

[Cley Faye]

2014-07-12 21:56 GMT+02:00 Robert Peirce :

> No idea, but I used to copy and paste from a terminal window (Mac) to a
> calc sheet with no problem, until the latest release.  Now, what I paste
> gets blown up to a much larger size.  I have to enter the numbers by hand
> and then they are okay.  I have no idea why this is happening or what to do
> about it.


​Maybe your terminal now copy as rich text. Try "paste special" (it's in
the edit menu, or with ctrl+shift+v on a PC... probably something similar
on a mac). I don't know if it will help you with the weird size
discrepancies, but at least you won't have to input your data by hand...​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: File corruption on OSX and LO 4252

[Cley Faye]

2014-07-16 9:42 GMT+02:00 Alexander Thurgood :

> I was also always sceptical of reading/writing directly from/to external
> storage, but this issue had never occurred in any of the preceding 3.x
> or 4.1 versions of LO on OSX (or in any other version of
> StarOffice/OOo/LO/AOO/NeoOffice that I have had). So, I was naturally
> caught "unawares" as they say. After many hundreds of hours of using
> previous iterations of LO with external storage, one certainly does not
> expect it to behave in a contrary fashion in an allegedly "stable" release.
>

​This is not really an answer regarding LO, but a general observation on
using external storage that might be pertinent in your case.

I use external USB drives to store most of my media files (pictures and
videos, with some audio files). That imply a lot of files, with relatively
large size. In this setup, I never had a problem with file corruption.
Except for that one time, which happened exactly as I was doing a backup
copy of the whole drive. Every single files where corrupted. When the copy
ended, all files where there. They all had the correct size, but all of
them where invalid. Some video played for a second, then stopped
encountering invalid content, pictures where completely unrecoverable, you
get the idea.
After that, I tried to find the culprit: it was not the OS (windows 7), as
other drives, and these two drives at other time, worked perfectly fine. It
was not the copy software either (teracopy at the time). The USB drives
themselves didn't report any error, and worked fine afterward (they are
still fine today). Turns out, a faulty USB hub can cause silent copy error:
the software, whatever it is, will see the write operation succeed, when
the content on the drive is garbage.

Long story short: a "passive" USB hub silently corrupted ~1TB of data.

Now, let's go back to your issue. The code for writting files (in
LibreOffice or any other software) is the least difficult part to port from
system to system. There is litteraly nothing to do, as various libraries
(including the standard C library) provide the necessary functions. For
most piece of software, there is also no difference at all in writing to an
internal hard-drive, or to an external one.

I'm not saying that the issue doesn't exist, mind you. Bugs exists, and
weird interactions can always happen. But since the "file writting" part is
probably the simplest thing in the whole program, it would be very
interesting to check if LO is really the culprit. The fact that it only
happened those two times with LO is not conclusive: if it is indeed caused
by external causes, it could have gone unnoticed if, for example, you
weren't manipulating other files on the drive at the time.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Nitpicking on a name

[Cley Faye]

2014-07-25 9:19 GMT+02:00 Charles-H. Schulz <
charles.sch...@documentfoundation.org>:

> Now you will tell me that it is easier to type LO than it is with
> LibreOffice. Perhaps. But everyone here writes MS Office...


​I've seen MSO used in long messages... Seeing that these messages are on
the *LibreOffice* mailing list, I doubt that there is any confusion
possible.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] shortcut keys for LibreOffice under Linux

[Cley Faye]

2014-08-12 4:55 GMT+02:00 Thomas :

> Then I do have the choice between learning all the different shortcuts,
> or else switching to Ubuntu (this "unity" thing, which I do not like at
> all).
>

​Unity and XFCE are not the only desktop ​environments. If you have issues
with one, and dislike the other, you can try KDE, which have no issues
interfering with common keyboard shortcuts, and is also extensively
configurable in case you find an obscure combination that conflict with
libreoffice.


-- 
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: LO Writer (Linux): Way to do text search in set of documents?

[Cley Faye]

2014-08-27 13:15 GMT+02:00 Maurice :

> The simplest way would presumably be to write an app that would create
> a temporary composite document from a list, and do the Find through
> that.
>

​I don't know if that's what you meant, but it might be possible to achieve
this through a macro inside LibreOffice.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: LO Writer (Linux): Way to do text search in set of documents?

[Cley Faye]

2014-08-28 16:01 GMT+02:00 Tom Davies :

> I thought
> that was all the Master Documents did but i guess there is a lot more to
> it!
>
>
​One of the "great" feature of master documents is overriding styles from
sub documents. With that you can have for example a whole book written with
a set of files, and different master documents that will format it for
printing, pdf, multi-column, etc...

(not that this is relevant at all for OP's problem, just a head up!)​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 do I insert a thin space in Libre in Windows?

[Cley Faye]

2014-09-11 17:57 GMT+02:00 Brian Barker :

> At 11:03 11/09/2014 +0100, Tom Davies wrote:
>
>> On 11 September 2014 08:07, Johan de Smidt wrote:
>>
>>> What is the keyboard shortcut for inserting a thin space in Windows?
>>>
>>
>> If you go to Tools - Customise then you can reconfigure one of the
>> keyboard combinations to be pretty much anything you want.
>>
>
> No: surely only to one of the provided functions, not "pretty much
> anything"?
>

​To be completely honest, you can bind custom macro too, that could achieve
this task in one line. It might be a bit overkill though, and probably
easier to just remap an unused key combination at the OS level (but I don't
know an easy way to do that outside of linux 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] How to make this equation?

[Cley Faye]

2014-09-17 12:26 GMT+02:00 rcc :

> Hi,
>
> How to make the equation as the attached image?
>
>
> Thank you. 
>

​With something like this:

v_{0}=left none {d} over {dt} g left (t,c_{1},c_{2} right ) mline  right
none_{t=t_{0}}

​For the record, opening LibreOffice Math directly (instead of inserting a
formula into a document) show a few helpers to write formula (I didn't know
that before now).

The result of the formula in LO is:
​http://i.imgur.com/gYJfMOM.png

You can probably adjust things more by changing fonts and spacing.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Saving as docx in Writer

[Cley Faye]

2014-09-19 16:08 GMT+02:00 Laurence Wyche :

> Hello Chaps
> Sometimes we are forced to save our Writer documents as if they were Word
> docs.
> Up to now this has worked well, but now it produces a zip file.
> What is going on?
>

A docx file IS a zip file. Are you saying that LibreOffice actually save a
file with the zip extension, or just that it show up as zip in your file
manager? The former would be very surprising, while the later can happen,
especially on systems where the content of a file is used to determine it's
type instead of the extension.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Making horizontal lines in Writer

[Cley Faye]

I don't know how well it transition to .doc files, but my approach to make
answer lines is the following:
- create a new paragraph style (let's call it "Answer Zone")
- change the style spacing so that there is no extra space before/after the
paragraph
- change the style border to be a single line at the bottom, and disable
the checkbox that merge the borders between paragraphs

...after typing this, I just checked, and that's roughly what the "---\r"
route is doing. Damn. The issues seems to be that the "Merge with next
paragraph" option either doesn't exist in .doc format, or isn't carried
over correctly. And no more luck with docx.

Some sort of solution for your issue could be to just send the odt (recent
version of MS Office can read them, YMMV), or directly send the PDF, which
is clearly the best option if the recipient of your document will not have
to modify it, only to view/print it.

-- 
Cley Faye
http://cleyfaye.net

2014-09-24 0:27 GMT+02:00 "J. Van Brimmer" :

> I'm using 4.3.1.2 on Xubuntu Linux.
>
> I am creating some lesson handouts for a class I'm going to be teaching. I
> have to email them to our secretary, who has to read them in MS Office for
> printing.
> ​
> The ​documents are formatted in landscape mode.
>
> In the document I enter a short text line, press Enter, then I type in
> three dashes, press Enter, and waula, I have a horizontal line for the
> students to  write their answers on.
> ​Sometimes I continue pressing Enter to automatically create as many lines
> as I need.
> ​
> This works fine as ling as I stay in .odt format. But if I save the
> document in .doc format, and then open the .doc file in LibreOffice, some
> of the horizontal lines are missing. I have tried everything I can think
> of, but I can't get all of the lines to "stick" from .odt to .doc format.
>
> I have read the "Help" page here:
> https://help.libreoffice.org/Common/Drawing_Lines_in_Text
> ​ .
> But ​those tips don't work either.
>
> ​I am being forced to work in Win​broke using BS Word. Help!
>
>
> --
> ->Jerry<-
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] Ctrl+F4 Close document

[Cley Faye]

The "close document" behavior you're noticing on windows is not linked to
LibreOffice, but is a feature of the system. It just mean "close the
window, not the app" and work everywhere. You can try it in most tabbed
browser too :)

The reason to have this greyed on Linux might be to avoid a clash with a
system shortcut. On some desktop environment, Ctrl+F4 lead to the fourth
desktop.

You can either look around on your system how this keyboard shortcut is
handled, or use another.

-- 
Cley Faye
http://cleyfaye.net

2014-09-26 16:24 GMT+02:00 Thomas Blasejewicz :

> Good evening
> I just noticed something. I have LibreOffice 4.2.4.2 on some Windows
> machines and recently also on two Linux (xubuntu 14.04) machines.
> Usually on the Windows machines the KB shortcut Ctrl+F4 closes the
> current document.
> Under Linux it does not do that (I copied the user profile from the
> Windows machine, following a tip here on the list).
>
> Under "Tools -> Customize -> Keyboard" the item "Ctrl + F4" is greyed
> out, both under Windows and Linux,
> and I CAN NOT edit/modify it.
>
> Am I missing something here?
> How can I assign the "close document" function to the above key
> combination?
>
> Thank you.
> Thomas
>
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] profiles

[Cley Faye]

Usually, moving/renaming profiles is very scarcely done, only in case
something goes wrong. Most of the time LibreOffice do a good job of
updating it.

Anyway, most of the actual content of the profile (macro, template, and
other stuff) can either directly be saved outside of it, and even if it's
not, each file/directory can be moved around without trouble. The only
thing that is quite hard to extract (and usually, the cause of issue) is
the registryModifications.xcu file, which contain almost all custom
configuration.

-- 
Cley Faye
http://cleyfaye.net

2014-10-14 1:18 GMT+02:00 Tim Lloyd :

> Hi,
>
> There are often suggestions here for people to rename their profile to
> allow a new, clean, version to be created. I recently wrote my first macro
> (a small step for mankind…) and when I decided to give 4.4 a whirl I
> realised I had a new profile and my macro was gone. No huge drama
> recreating the minimal macro but, is there a mechanism to import specific
> parts of a profile? I can imagine those who indulge in industrial scale
> customisation don't want to lose their good work.
>
> Cheers
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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 forks

[Cley Faye]

As an example, go there:
https://github.com/watabou/pixel-dungeon

See in the upper-right corner the term "Fork" :)

It's almost used in a literal way: at one point in the life of a project,
someone decided to go in another direction, like a fork on a road
<http://i.imgur.com/O6vSljU.jpg>.

-- 
Cley Faye
http://cleyfaye.net

2014-10-15 1:50 GMT+02:00 anne-ology :

>would you like a spoon & knife with that  ;-)
>
>If 'fork' has now become a computer term -
> [and I just 'searched' it to see] -
>then just what is it?
>
>Curiously wondering what the next word will be that will be
> transformed by the computer industry  ;-)
>
>
>
> From: Bruce Byfield 
> Date: Tue, Oct 14, 2014 at 4:36 PM
> Subject: [libreoffice-users] LibreOffice forks
> To: users@global.libreoffice.org
>
>
> Can anyone point me to a list of LibreOffice and OOo forks?
>
> Thanks,
> --
> Bruce Byfield 604-421-7189 (on Pacific time)
> blog: https://brucebyfield.wordpress.com
> website: http://members.axion.net/~bbyfield/
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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: Problem importing xls files

[Cley Faye]

2014-10-15 12:27 GMT+02:00 Urmas :

> "Harvey Nimmo":
>
>  I think you will find that a .slk file is a symbolic link file
>> (equivalent to the linux .lnk) so it won't open directly in Calc.
>>
>
> LOL wut? SYmbolic LinK is one of the oldest text data interchange formats.
>

​Also the first time I heard of a linux .lnk file extension, which sound
silly since most fs used in linux supports symbolic links. I suppose it's
only a misunderstanding.

And, to clarify, the slk file actually have content and can be (usually)
opened by itself.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Is there a way for a Basic macro to detect what application is running it?

[Cley Faye]

Quickly looking through the (not very user friendly) help for LibreOffice
Basic, the closest thing I found is GetSolarVersion, but that's probably
not enough.

While checking if the type is a struct can be a good workaround, it's not
completely future-proof; there is a need for a function to distinguish
between version of the Basic API (not only between AOO and LO).

-- 
Cley Faye
http://cleyfaye.net

2014-10-19 21:06 GMT+02:00 Johnny Rosenberg :

> Here's my problem:
>
> I have both Apache OpenOffice and LibreOffice installed and I use them
> both. I have quite a few Calc files with Basic macros. Today I found my
> first difference between the Basic API in LibreOffice vs. Apache
> OpenOffice:
>
> Dim Dlg As Object, Ctl As Object
> DialogLibraries.LoadLibrary("Standard")
> Dlg=CreateUnoDialog(DialogLibraries.Standard.ElDialog)
> Ctl=Dlg.getControl("DateField")
>
> Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and here's
> the difference:
> In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is
> represented as 20141019. I made two functions to convert to and from the
> format I needed.
>
> When running my macro in LibreOffice, the macro was interrupted by an error
> message, of course. After some debugging I found that the LibreOffice
> version of Ctl.setDate/Ctl.getDate works with a struct:
> Type DateType
> Year As Long
> Month As Long
> Day As Long
> End Type
>
>
> This is of course not a big deal, I can make the macro accept both formats,
> but the macro need to know if LibreOffice or Apache OpenOffice is running
> it. How can I do that? I have tried to find the answer myself, both using
> xray and searching the web, but so far nothing.
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] LO Calc question...

[Cley Faye]

2014-10-26 19:48 GMT+01:00 Andrew Sullivan :

> I have a simple spreadsheet in Calc - just a few columns fo data and a
> chart at the top of the page.  The data columns are quite long (hundreds of
> lines eventually) and I would like to fix the position of the chart at the
> top of the page and scroll down the data columns.
>
> Assuming this makes sense, is it possible???
>

​There is probably some quirk with this solution, but you can lock the
scrolling (using the adequate option in the Window menu, I don't have the
exact name as I don't have the UI in english).

If a chart is in the locked part, it will not scroll when the rest of the
spreadsheet is scrolled. So, if for example you have your data starting at
row 20, and the chart is above that, locking the scrolling at line 20 will
allow browsing the document while viewing the chart.

There is also other possibilities, like opening a new window on the same
document (again in the Window menu), or move the chart to a separate tab,
but that might or might not suit your needs.

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