RE: [libreoffice-users] Benford's Law
Uniform random number generators do not conform to Benford's law. To get uniform digits in the range 1 to 10, try =FLOOR(10*RAND();1;1) However, Benford's law is about the *first* digit of a wide variety of numbers. See http://en.wikipedia.org/wiki/Benford%27s_law#Mathematical_statement. To get the Benford distribution of digits 1 to 9, I think you want =FLOOR(10^RAND();1;1) What makes you think these do not have the Benford distribution? How are you testing that. You should be able to create a histogram for the frequencies of values of 1, 2, 3, ..., 9 and show that it approaches the Benford distribution as you increase the number of samples. While the RNG used for RAND() may not be cryptographically wonderful, I expect it would pass a reasonable test (say chi-squared) for correspondence to the Benford distribution. - Dennis -Original Message- From: Toki Kantoor [mailto:toki.kant...@gmail.com] Sent: Sunday, July 14, 2013 02:01 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Benford's Law On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I need a random number generator whose output does adhere to Benford's Law. jonathon -- LibreOffice in a Multi-Lingual Environment. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.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] Benford's Law
I meant, of course, that large samples of =FLOOR(10^RAND();1;1) should satisfy the chi-squared distribution for conformance to the Benford Distribution. -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Sunday, July 14, 2013 02:55 PM To: 'Toki Kantoor' Cc: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Benford's Law Uniform random number generators do not conform to Benford's law. To get uniform digits in the range 1 to 10, try =FLOOR(10*RAND();1;1) However, Benford's law is about the *first* digit of a wide variety of numbers. See http://en.wikipedia.org/wiki/Benford%27s_law#Mathematical_statement. To get the Benford distribution of digits 1 to 9, I think you want =FLOOR(10^RAND();1;1) What makes you think these do not have the Benford distribution? How are you testing that. You should be able to create a histogram for the frequencies of values of 1, 2, 3, ..., 9 and show that it approaches the Benford distribution as you increase the number of samples. While the RNG used for RAND() may not be cryptographically wonderful, I expect it would pass a reasonable test (say chi-squared) for correspondence to the Benford distribution. - Dennis -Original Message- From: Toki Kantoor [mailto:toki.kant...@gmail.com] Sent: Sunday, July 14, 2013 02:01 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Benford's Law On 07/13/2013 11:01 PM, Brian Barker wrote: Unless I misunderstand,the formula =10^RAND() should create random variates in the range (1,10) following the law. 10^RAND generates a set of random numbers that does _not_ adhere to Benford's Law. I need a random number generator whose output does adhere to Benford's Law. jonathon -- LibreOffice in a Multi-Lingual Environment. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.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] AOO for Android - not worth the download
AndrOpenOffice (AOO) is not an Apache OpenOffice project. If it were it would be on the Apache OpenOffice SVN, the bugzilla, there'd be release votes, etc. There is no indication that AndrOpenOffice is even open source, although there is apparently significant (non-GPL) open source content. You'll also notice that it does not appear to use any of the Apache OpenOffice trademarks or logos, at least not on the Google Play site. Nothing wrong with it being a port. It just isn't being conducted by the Apache OpenOffice project. There are disclaimers about full features of ... deeper in the material. I guess we don't get to use AOO as a handy abbreviation for Apache OpenOffice any longer [;). - Dennis -Original Message- From: Kracked_P_P---webmaster [mailto:webmas...@krackedpress.com] Sent: Saturday, June 22, 2013 02:51 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] AOO for Android - not worth the download On 06/22/2013 04:35 PM, James Knott wrote: Johnny Rosenberg wrote: This is a little confusing to me. You mention LibreOffice and Apache OpenOffice for Android, but as far as I know there is no Apache OpenOffice for Android, so I guess you are talking about LibreOffice all the time, right? I can't find either. LibreOffice's port for Android is still in ALPHA, early alpha so I have been told. To find the AOO port. . . . go to Google Play search for OpenOffice --- https://play.google.com/store/apps/details?id=com.andropenofficefeature=search_result# Description AndrOpen Office is Apache OpenOffice port for Android. You can view, edit, export office documents using full features of Apache OpenOffice. (NOTE: You can only edit in English in current version.) AndrOpen Office has 4 components: - Writer (a word processor) - Calc (spreadsheet) - Impress (presentation graphics) - Draw (drawing) -- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.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] Showing cell contents as text in calc. (Not evaluating the formula the text represents)
Ditch the curly braces. They prevent the formula inside from being recognized
as a formula.
-Original Message-
From: Tim Deaton [mailto:t...@timdeaton.org]
Sent: Wednesday, June 12, 2013 05:42 PM
To: Steve Edmonds
Cc: NickKolok; LibreOffice
Subject: Re: [libreoffice-users] Showing cell contents as text in calc. (Not
evaluating the formula the text represents)
Maybe it's a difference between the different language settings, or the
operating system. I'm using LO Version 3.6.6.2 (Build ID: f969faf) on
Windows 7 64-bit, and my language setting is USA English.
First I copied the formula from below, including the curly brackets, and
pasted it into calc. It behaved as a string, not a formula.
Next, I copied it again, and then changed the S31 to S32. Still behaved
as a string.
Third, I typed the formula in from scratch. Still behaved as a string.
Fourth, I grabbed the handle on the bottom right corner of the cell and
dragged down to copy. Still a string.
But about this time, I noticed that the first two cells had blank spaces
after the end of the entry. the third and forth cells (the one I had
typed from scratch, and the copy made by dragging down from that one)
didn't.
Finally, I clicked into the fourth cell to change S31 to S32. When I did
so, the curly brackets disappeared, the cell references took on colors,
and the lines appeared around the cells included in the arrays. BUT -
when I hit ENTER, the text became a string again, complete with the
curly brackets that had disappeared while I was editing it.
Maybe if I knew something about the kind of math represented by these
functions, I'd have a better clue. But I know nothing about that level
of math.
-- Tim
===
On 6/12/2013 6:07 PM, Steve Edmonds wrote:
Thanks for the reply, please click into the cell and change S31 to
S32. Do the contents change into a formula or stay as text.
Steve
On 2013-06-13 09:59, NickKolok wrote:
Greetings from Russia!
I opened LibreOffice Calc (4.0.3) fnd simply copy-pasted the following:
{=MMULT(MINVERSE(A14:R31),S14:S31)}
into an empty cell on a empty book.
It is displaying as text, not calculating a formula.What am I d oing
wrong?
Четверг, 13 июня 2013, 9:44 +12:00 от Steve Edmonds
steve.edmo...@ptglobal.com:
Hi.
I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to
display this as the text {=MMULT(MINVERSE(A14:R31),S14:S31)} (without
the quotes). Formatting the cell as text doesn't help. I thought
once
you could prepend with a ' to define the characters following as left
aligned text but not show the '. This does not seem to work any more,
there must be a simple solution I am missing.
Cheers, steve
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot
be deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)
The single-' works in front of numerals.
Sometimes it works in front of a formula and sometimes it doesn't. Typing a
space before the = or the {= seems to work consistently instead. Good idea.
I just checked in LibO 4.0.1.2 on Windows XP SP3.
-Original Message-
From: Brian Barker [mailto:b.m.bar...@btinternet.com]
Sent: Wednesday, June 12, 2013 08:30 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Showing cell contents as text in calc. (Not
evaluating the formula the text represents)
At 09:44 13/06/2013 +1200, Steve Edmonds wrote:
I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to
display this as the text {=MMULT(MINVERSE(A14:R31),S14:S31)}
(without the quotes). Formatting the cell as text doesn't help.
I think you can type this - complete with the braces - and have it
appear as a text string and not be interpreted as a formula, in
fact. If you wanted it to be an array formula, you would need not to
enter the braces but to use Ctrl+Shift+Enter (instead of simple
Enter) to complete the entry; the braces are then added automatically
to the display you see in the Input Line (as well as in the cell if
you have the display of formulae selected). You probably know that.
At 10:07 13/06/2013 +1200, Steve Edmonds wrote:
... please click into the cell and change S31 to S32. Do the
contents change into a formula or stay as text.
That is indeed where you appear to have a problem: editing the text
string makes Calc reinterpret it as an array formula, which is what
you are trying to prevent.
At 09:44 13/06/2013 +1200, Steve Edmonds wrote:
I thought once you could prepend with a ' to define the characters
following as left aligned text but not show the '. This does not
seem to work any more, there must be a simple solution I am missing.
Yes, this does generally work, but I think there may be one of two
problems here. It does seem that if you enter what would be a
formula but prefix it with the apostrophe, the string remains text
and not interpreted as a formula, but the apostrophe remains
displayed. I don't know why this should be, but it clearly gets in your way.
Another point worth mentioning is that if you have Custom Quotes
selected in AutoCorrect Options, then the apostrophe will be
instantly converted to an opening single quote mark and will continue
to display. To avoid this whilst retaining custom quotes, use Edit |
Undo (or Ctrl+Z) immediately after typing the apostrophe to undo the
automatic correction. Oh, but if you have existing leading custom
quotes in the same column, you will see automatic suggestions and
will need to Undo twice.
So how to do what you require? Here are some workarounds:
o Enter a space before the text. This will fool Calc!
o Enter the formula =T({=MMULT(MINVERSE(A14:R31),S14:S31)}) instead.
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] ”Artifacts” in OpenOffice and LibreOffice
I see less-dramatic variants of these on Windows 8 also, using an ATI Radeon HD 5980 graphics processor with an HP Z30W monitor in 32bbp 2560 x 1600 landscape orientation. I am certain in my case that the situation is GDI/driver/engine related. The typical situation is where editing leads to modified text appearing off-baseline and interfering with adjacent text, usually in the line above. Since causing the displayed material to refresh corrects things (e.g., by performing a Page Down followed by a Page Up), the situation is somewhere in the rendering path. I am not so certain that the situation is unique to OpenOffice-lineage programs. That may just reflect where we are working so much. It could be attributable to heavy usage of fine-detail font rendering in these programs bringing out the defects. There might also be associated computational errors (somewhere in the code base and libraries used) in how changes in documents are first rendered in the GUI. It is also necessary to consider that different users observe similar defects with different causes. It does seem that it is all about rendering in the GUI, not something untoward happening to the document itself (internal to the program or when made persistent). The challenge is having tests that can reveal these situations and support isolation of causes. - Dennis -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Saturday, May 11, 2013 07:08 To: Johnny Rosenberg Cc: us...@openoffice.apache.org; LibreOffice Användare Subject: Re: [libreoffice-users] ”Artifacts” in OpenOffice and LibreOffice I have had subtle redraw issues with OO off and on, and I always blamed it on an interaction between applications and the video drivers. Realize that I use nVidia video cards on 64-bit Fedora using the proprietary video drivers. What I saw was not remotely as bad. Admittedly, when I tried out the latest dev build, it was totally unusable (of course, the single tester was unable to reproduce on Windows 7). see https://issues.apache.org/ooo/show_bug.cgi?id=122214 Are you able to do a test and change your video driver say between the free and not free driver to see if there is a change (I do not use Ubuntu so I don't have a good handle on what drivers are available or how). I used to have exactly the same problem in QT, and it was very bad. I was able to avoid the problem with QT Creator by starting it using -graphicssystem raster Not that I expect this to help you. I did notice that it still has some rendering issues that appeared in the latest versions (I believe it is related to an over-lay issue when you edit a field that assumption allowed me to fix it in the software that I write, but I did not jump into the QT code base). I have seen strange redraw issues so long in OO that correcting for it is almost automatic in my brain (scroll screen up then down to clear) so I cannot even say if I still see the problem. I think I do, but it is for sure not as bad is it used to be for me. I know, that I have rambled on and on I will summarize in saying 1. I have never seen it so bad 2. I have seen screen corruption 3. You may avoid some of it based on the video driver If I had it that bad on my Fedora system, I would likely change my desktop on login to see if it helped. With Fedora, I can easily jump between Gnome and KDE (as one example). I would also try jumping between the two different drivers available to see how that helped as well. Sadly, the free driver is poor with respect to 3D stuff. On 05/11/2013 08:52 AM, Johnny Rosenberg wrote: I have had this problem for quite some time now (months if not years) in LibreOffice and OpenOffice. The problems are maybe a little bit worse in LibreOffice, but I didn't exactly measure it… It looks like a graphics card problem, but why are nothing else affected? It only happens to OpenOffice and LibreOffice. I tested a few versions and it seems to not matter. The screenshots are taken with Apache OpenOffice 3.4.1 and I saw the same thing in LibreOffice 3.5, 3.6 and 4.0. I think this also happened with earlier LibreOffice versions, like 3.4 and 3.3. I didn't use OpenOffice since 3.2 (except 3.4.1, which I use these days), and I don't even remember what it looked like. Here's a screenshot with Apache OpenOffice Calc 3.4.1. I added some arrows pointing at the problem areas: http://ubuntuone.com/0wvqcaN38PC5835t4uJVPv The worst thing is when I try to use the Basic IDE, take a look at this. Very hard to write and edit code when it looks like this: http://ubuntuone.com/4HRPQMpblZT97UxHq5ggzO My operating system is Ubuntu 12.04 and the more stuff I run at the same time, the worse will it look. My graphics card is the nVidia GeForce Go 7300, which is blacklisted for use with the Unity 3D desktop, so that may be what's causing this problem, but still it ONLY happens to LibreOffice and OpenOffice. One
RE: [libreoffice-users] Re: File associations for MSO to LibreOffice -- Win8
In the LibreOffice 4.0.1 Start Screen Open dialog, the Files of type: pull-down lists Microsoft Publisher 98-2010 (*.pub) as one of the drawing/image formats that are supported. - Dennis -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Wednesday, April 03, 2013 14:03 To: LibreOffice Subject: Re: [libreoffice-users] Re: File associations for MSO to LibreOffice -- Win8 Tom Davies wrote: Hi:) I thought Publisher compatibility was added in 4.0.0? Regards from Tom:) If so, this is the first I've heard of it. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] File associations for MSO to LibreOffice -- Win8
1. Find a file that has the association to be changed, using Windows Explorer (from the Windows 8 Desktop). 2. Right click on the file entry. 3. Select Open With ... 4. On the dialog that offers some selections of prospective alternatives, do not choose one. Instead, select Choose default program It will show the current default and some alternatives. If LibreOffice (Writer, Calc, Impress) is in the list, choose the appropriate one. Otherwise, use the More Options case to see additional selections. 5. Note that, even when the default is changed, this technique can also be used (with the default check-box cleared) for occassional selection of a different program. Windows notices this and will move the selections that have been used up to the top for direct selection at the Open With ... option. - Dennis -Original Message- From: Marc Paré [mailto:m...@marcpare.com] Sent: Sunday, March 31, 2013 19:49 To: users@global.libreoffice.org Subject: [libreoffice-users] File associations for MSO to LibreOffice -- Win8 Unfortunately, I do not have a version of Win8, and have been asked how to set file associations for MSO files to use LibreOffice instead. The person who asked me would rather double-click on the files she wants to open through windows explorer. Many thanks for the help. Cheers, Marc -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] calc problem
It is not an .xlsx file. .xlsx files are a kind of Zip package, similar to how .ods is a special Zip package. Rename it to .xml. Try opening it, in LibreOffice, as Microsoft Excel 2003 XML. Also, Excel should be able to open it as an XML file unless it has been damaged. There are some data extraction programs that produce these as .xls when they are an Excel form of XML. This may be one of those situations. - Dennis -Original Message- From: Tim Lloyd [mailto:tim.ll...@gmx.com] Sent: Monday, March 25, 2013 21:07 To: Michael Manning; users@global.libreoffice.org Subject: Re: [libreoffice-users] calc problem Hi Michael, looks like this one didn't make it to the list. And it is very interesting. In light of all the XML reports I think the first step is to ask the site why XML docs are masquerading as XLS. It would be good to know the version of MSO you are using so I can quote this to them. FYI I am using Office 2007 and the file opens without this message, Thanks to all for your feedback so far. Cheers On 03/26/2013 01:23 PM, Michael Manning wrote: I also found that this file locked up Calc. I also attempted to open the file using Excel on my Windows computer and received the following message from Excel: There does seem to be a problem with the file structure is Excel does not recognize it as a .xls file. Renaming the file as .xlsx did not fix the situation. Opening the file in an editor reveals that it is in XML format: ?xml version=1.0 encoding=UTF-8? Workbook xmlns=urn:schemas-microsoft-com:office:spreadsheet xmlns:ss=urn:schemas-microsoft-com:office:spreadsheet xmlns:x=urn:schemas-microsoft-com:office:excel xmlns:o=urn:schemas-microsoft-com:office:office DocumentProperties xmlns=urn:schemas-microsoft-com:office:office Title/ Authorsystem/Author LastAuthorsystem/LastAuthor Created1364168930/Created LastSaved1364192393/LastSaved CompanyFairfax Media/Company Version102/Version ... Mike On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd tim.ll...@gmx.com mailto:tim.ll...@gmx.com wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to open it. Calc locked up! No problem with the files I normally look at, Calc opened them fine. So I tried again today and waited for an error - LibreOffice 4.0.1.2 General input/output error. So I hopped over to the windows PC and tried LO portable. Same error. The error was repeated whether I tried to open directly from the website or if I saved to disk and then attempted to open the file. MS Excel has no problems. The file in question is accessible using this link: http://www.afr.com/share_tables/ Just click on the xls link next to Warrant Market Any comments? Cheers -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org mailto:users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Put LibreOffice as unedited document viewer only
Open the document that you want to make read-only. Click the File | Save As ... menu. On the Save As change the name if you want to keep the editable version separate. If not, leave the name and location the same. On the Save As dialog, check the Save with Password. (Don't worry, that will be modified in the next step.) Click Save on the Save As dialog. When the Set Password dialog opens, *do* *not* enter a password. Instead, click the More Options Under the File sharing password part of the expanded dialog: 1. Check Open file read-only 2. Enter a password to allow editing. 3. Confirm the password. Now click OK on the Set Password dialog. This will prevent direct editing of the file. This is not fool-proof. It is possible to overcome the read-only condition without knowing the password: 1. Material can be selected and copied to the clip-board. 2. The document can be Saved As to another file, and that copy will not be read-only. (I just confirmed all of this with LibreOffice 3.6.4.3 on Windows XP SP3.) - Dennis -Original Message- From: jathan [mailto:jathanblack...@gmail.com] Sent: Wednesday, March 13, 2013 17:51 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Put LibreOffice as unedited document viewer only [ ... ] An apology for some ambiguity in my explanation. That I want to do with LibreOffice is use it in read-only mode by default in place of edit function as odfviewer: http://opendocumentfellowship.com/odfviewer, pptview for powerpoint presentations or Evince or Adobe Reader for PDF documents. That is to say that no document can be opened for editing without assigning permissions previously in LibreOffice, only use it as a ODF documents viewer. Thanks. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Exported XLS doesn't opens in Calc
If renaming it from .xsl to .html had it open correctly, I suspect it is not OOXML. It *might* be the Excel XML Spreadsheet format. I checked here: http://hpsws.lithium.com/t5/Project-Portfolio-Management/HP-PPM-and-Excel-Integration/td-p/2250 Apparently exporting a report from PPM often produces HTML, even when Excel is specified. It appears that exporting as an XML file does provides something that Excel can read also. I'm guessing the reference to POI is Apache POI, Java libraries for manipulating/creating documents in Microsoft Office formats. - Dennis (Although file associations are used to determine what application to launch, the Microsoft Office applications don't depend on the filename extension to determine what the format is. That can sometimes account for something opening correctly in Microsoft Office but not being recognizable when opened in another application such as LibreOffice.) -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Tuesday, March 05, 2013 10:10 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Exported XLS doesn't opens in Calc On 03/05/2013 12:31 PM, Nacho Rodríguez wrote: Hi I use the PPM application from HP. This application can export data in XLS format. The exported XLS files opens right in MS-Office, but when try to open it with Calc it show the text import window and I get a sheet with XML and HTML tags Renaming the file with HTML extension and viewing in browser showed the content correctly Anyone knows how can I open these files in LibreOffice? I’m using LibreOffice version 4. Attach an example file. Thanks in advance ___ Nacho Rodríguez Can you upload the file to Nabble or post a link to it? Since you are seeing xml/html tags I suspect the is not xls but xlsx. I would make a copy of the file and change the copy's file extension to xlsx and then try opening it. The xls format in an MS binary format while the xlsx is format similar to ods. Both xlsx and ods are containers with xml files within the container. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year?
SourceForge reports downloads by country. It appears that the number of languages supported does not limit the locations where the downloads happen (although destination country is necessarily an estimate, just as it is on the ClustrMap of visitors to my web sites). I assume that as language versions increase (as just happened in a refresh of AOO 3.4.1), the proportion of downloads will improve for countries where those languages are used/preferred by someone. - Dennis -Original Message- From: Italo Vignoli [mailto:italo.vign...@gmail.com] Sent: Tuesday, February 19, 2013 09:26 To: charles.sch...@documentfoundation.org Cc: webmas...@krackedpress.com; users@global.libreoffice.org; disc...@documentfoundation.org Subject: [libreoffice-users] Re: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year? On 2/19/13 6:20 PM, Charles-H. Schulz wrote: I suspect they multiply the standard package price of MS Office and multiply that by their numbers of stated downloads, then divide it by 365. At least that's how I would do it. Average number of downloads per day, multiplied by 150 dollars (which is the inflated average price of MS Office Home, as the price is less than 80 dollars now). By the way, they claim 236 countries and territories while their language versions are around 10% than that. Huge FUD by the master of IBM FUD, Mister Robert Weir. -- Italo Vignoli - italo.vign...@gmail.com mob +39.348.5653829 - VoIP 5316...@messagenet.it skype italovignoli - gtalk italo.vign...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] RE: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year?
I thought the article explained exactly how it was calculated: https://blogs.apache.org/OOo/entry/21_million_per_day. There's no need to speculate. There are two base figures: (1) the average number of AOO full-install downloads per day and (2) an estimated average price for a permanent Microsoft Office desktop license. Rob used $150 US which is the price for Office 2013 Home and Student. That includes service packs, etc., but not upgrades to later versions of Microsoft Office. For Office 365/2013 there is a lower price -- the student price for Office 365 rental is a single $79 for a four-year lease, which includes any updates to the desktop products in that time. The $99/year Office 365 Home Premium (one rental good for noncommercial use on up to 5 machines) is another option, including not only the Office 2013 versions of Excel, Word, and PowerPoint, but Outlook, Access, Publisher, and OneNote (and their updates and upgrades for as long as the rental continues). Since it is perhaps personal use that is the most price-sensitive case, assuming that one download avoids a $100-$150 expense is probably not far off for estimation purposes. LibreOffice can use the same logic that Apache OpenOffice did. -Original Message- From: Charles-H. Schulz [mailto:charles.sch...@documentfoundation.org] Sent: Tuesday, February 19, 2013 09:21 To: webmaster-Kracked_P_P Cc: LibreO - Users Global; LibreO - Discuss Subject: Re: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year? Hello Tim, I suspect they multiply the standard package price of MS Office and multiply that by their numbers of stated downloads, then divide it by 365. At least that's how I would do it. best, Charles. Le mardi 19 février 2013 à 12:15 -0500, webmaster-Kracked_P_P a écrit : How did AOO figure out how much their version of OOo was worth per day to users? I cannot figure out any way. Of course it makes great Marketing Copy. We are giving our users some much product value, we must be the better product. FUD or what? --- http://www.eweek.com/enterprise-apps/apache-openoffice-valued-at-21m-per-day The Apache Software Foundation (ASF) announced that Apache OpenOffice has a value of $21 million a day. ASF officials said Apache OpenOffice has averaged 131,455 downloads per day since its 3.4 release last May. That represents an average value to the public of $21 million per day or $7.61 billion per year, ASF said. -- Charles-H. Schulz Co-Founder Director, The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany Rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] MS Excel file macros cause infinite loop of errors
There's also the ever-popular testing for an exact floating-point value [;). The OP mentions there being an *exception* loop, so it sounds like LO is throwing a script error exception message and somehow there is no way out of it. It looks like two things are needed: 1. The complete, exact exception message about what is wrong. 2. Opening the document with macros disabled (if that is possible when conversion from .xls is happening) and extracting the resulting script. (An alternative is to open the document in Excel, which should allow macro disabling, and extract the original VBA there.) Speculating further, it may well be that the VBA has a dependency that can't be resolved on the users system from LO. Either way, the script error/failure behavior of LO needs to be looked into. - Dennis -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Monday, February 11, 2013 10:15 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] MS Excel file macros cause infinite loop of errors On 02/11/2013 12:52 PM, Todd E. Moore wrote: Trying to determine where best to request help.A file sent to me includes VB macros created in MS Excel.The macro handler in LibreOffice (both 3.6 and 4.0) end up in an exception loop which cannot be stopped unless I kill the process from the system command line.Is there a specific way to address the Subject line or a different forum/mailing list I should use for requesting help?I wanted to make sure I send to the correct place before cluttering up folks' Inbox with a hefty file. Todd Either upload the file to Nabble or post the file some and provide a link. I am not expert on macros but infinite loops are caused by a serious logic error - not providing a loop exit condition that tests correctly. I would expect the problem to in a WHILE/DO loop where there most be an exit condition that terminates the loop. For example i = 10 While i 1 do loop body i = i + 1 This above will always test TRUE and never exit. I have explicitly shown i incrementing. But the following will exit because the loop condition will eventually evaluate to false: i = 10 While i 1000 do loop body i = i + 1 Another error is for the above examples is to forget to increment i -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Re: LibreOffice 4.0
The precise situation is as follows: Office 2007 (SP2 I think) through Office 2013 *all* accept and produce OOXML Transitional. This is also true of the compatibility pack that provides OOXML support in Office 2003. These products also have compatibility modes that will preserve compatibility (unless changed at user option) of edited documents that originated from down-level versions. The OOXML format has this kind of support available as part of special compatibility and extension provisions. (There are similar provisions in the Office 97-2000 format and RTF, but the technique is more refined in OOXML.) Office 2010 and Office 2013 *also* accept OOXML Strict. These are the first versions that can accept Strict. They are the first versions produced after Strict was fully specified. (There was a major change in Strict at the ISO level and I don't know how that has been smoothed over between Office 2010 and 2013.) Office 2013 is the first version that can *produce* OOXML Strict. The default is still OOXML Transitional. One has to specifically request Strict in the Save As dialog, at least on my installation of Office 2013 Preview. I don't know when the default will ever flip over and I haven't checked for configuration options that change the default preference. This is all done to smooth the readiness and preparation for migration to Strict. It was not Microsoft's idea to create such a hard line in the sand. It came from the ISO/IEC committee that is maintaining the OOXML specification and from the ballot resolution meeting that had OOXML approved as an International Standard. The Transitional OOXML support in Office 2007 and back to Office 2003 (by compatibility pack) was all done based on the original ECMA standard, which had no Strict separation. What is being done to smooth the transition makes perfect sense to me. Presumably the people who want to use strict understand that there is no down-level compatibility, and strict will not happen by accidental default. This consideration of migration and up-/down-level preservation would be an useful lesson for actions taken on the ODF TC and in OpenOffice-legacy implementations that provide breaking changes to default behavior. There are more of those on their way. The sudden change of Save As Password to use different encryption methods not known down-level was just a first taste. Breaking changes with regard to SVG compatibility will be more noticeable. And the new change-tracking that may emerge in ODF 1.3 will go farther still. - Dennis -Original Message- From: webmaster-Kracked_P_P [mailto:webmas...@krackedpress.com] Sent: Tuesday, February 05, 2013 06:57 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Re: LibreOffice 4.0 Many months ago, there was a notification that MSO2013 changed their XML formatting from a loose to a strict version of the format. I do not remember the exact wording but they stated that MSO2010 may not read MSO2013 files correctly. So that makes 3 releases of MSO on Windows that are not compatible with MS's own XML based formats. EVERY time they release a new version, since 2007, they require the user to buy the new version to be compatible. They there is the big hike in buying their office suite, since renting will give MS more income from the same user. You get a lower up-front cost but a higher total cost when you rent MSO. All this incompatibility is just a scheme to increase their income. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: LibreOffice 4.0
That's very funny. What particular basics of security do you have in mind? And how would you say LibreOffice 4.0 will demonstrate superiority in that regard? -Original Message- From: Stephen Morris [mailto:samor...@netspace.net.au] Sent: Tuesday, February 05, 2013 12:20 To: Tom Davies; Urmas; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: LibreOffice 4.0 [Microsoft] don't have the reputation of Microsoft and Security don't go together for nothing, plus they continually demonstrate that they don't understand the basics of security. regards, Steve [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Navigation in Documents
When I saw Jean's comments, below, it brought to mind a serous pet peeve I have with the OpenOffice-legacy interfaces. Although one can follow links from tables of content and also follow cross-reference links within documents, there is no provision for retracing my way backwards through a progression of followed links. That is, the counterparts of the Browser forward/back link-path navigation are unavailable. In my work with specifications published in ODF, this is a very serious limitation. That is such a serious limitation that I will export an ODF document to PDF and take advantage of the fact that the Acrobat Reader does provide link-path-history back and forward navigation. Buttons for forward/back are not on the default Acrobat Reader toolbar, at least not on Windows, but they are there and can be added to the toolbar using the available customization dialogs. Out of curiosity, I just found out where to add the same functions to my QuickStart toolbar in Microsoft Word 2013, where they work find in OpenDocument Text (.odt) documents too. Have I missed these in LibreOffice somewhere? - Dennis PS: I am submitting an enhancement request at Apache OpenOffice for this too. -Original Message- From: Jean Weber [mailto:jeanwe...@gmail.com] Sent: Sunday, February 03, 2013 09:52 To: Tom Davies Cc: Tim Lloyd; documentat...@global.libreoffice.org Subject: Re: [libreoffice-documentation] Draft LO 4.0 Chapter 4 - Getting started with Writer Tom, if you click a link in the table of contents at the topic that page, only minimal scrolling is necessary. That's what the TOC is for. :-) But the task list is in addition to what Tim was asking about. Jean On 03/02/2013, at 3:37, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I think there is a sign-out sheet in the wiki https://wiki.documentfoundation.org/Documentation/Development/UserGuideTasks scroll quite a long way down for it though. Regards from Tom :) -- Unsubscribe instructions: E-mail to documentation+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/documentation/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Development of Extensions for LibreOffice
Via Simon Phipps on Twitter: We're rewriting the LibreOffice wizards in Python because we can no longer be sure Java will be there -- Michael Meeks, #FOSDEM -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Sunday, February 03, 2013 13:05 To: Stephen Morris; LibreOffice Users Subject: Re: [libreoffice-users] Development of Extensions for LibreOffice Hi :) Hopefully one of the links in this wiki-page might be useful https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Re sources#Programmers Errr, i thought everyone was moving away from Java due to all the security issues it's been having in the last couple of years? I thought people were moving to C++, Python or even Qt? Regards from Tom :) From: Stephen Morris samor...@netspace.net.au To: LibreOffice Users users@global.libreoffice.org Sent: Sunday, 3 February 2013, 19:57 Subject: [libreoffice-users] Development of Extensions for LibreOffice Hi, I have Eclipse with the OpenOffice plugin to enable development of extensions for Libreoffice. Can someone tell where I can get documentation on the Libreoffice Calc internals and how to interface specifically to things like the Pivot Table dialogue so that it can be extended. I want to work around the fact that Pivot Tables in Calc 3.6.5 are functionally not equivalent to Excel 2002 let alone Excel 2010? I was also thinking of developing these extensions in Java, are there any issues with doing so? regards, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure
Without purchasing (subscribing for the Office 365 Home option) for Microsoft Office 2013, there is the option to use the Excel Web Application on Skydrive. That's free and Skydrive will accept ODF 1.2 Spreadsheet documents with their OpenFormula formulas. -Original Message- From: e-letter [mailto:inp...@gmail.com] Sent: Thursday, January 24, 2013 01:02 To: dennis.hamil...@acm.org Cc: James Knott; LibreOffice Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure On 23/01/2013, Dennis E. Hamilton dennis.hamil...@acm.org wrote: ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas were left implementation-specific. Microsoft did not support the OpenOffice.org-specific formulas. Instead, they used Excel-specific formulas in ODF 1.1. On input of a not-supported formula expression, Excel in Office 2007 and 2010 drops the formula and preserves the last-calculated value. Whether a wise choice or not, that is what's done. As Regina says, Office 2013 supports ODF 1.2, including its OpenFormula specification. OpenFormula is also used by current implementations of LibreOffice and Apache OpenOffice when their documents are saved as ODF 1.2, so there is interoperability of formulas shared between ODF 1.2 implementing software. To clarify (without m$ 2013 to view), when a spreadsheet in LO is created in the (default) version 12, a user with m$2013 will be able to see formulae, whereas earlier versions e.g. m$2012 will shown only the results of the formulae calculations. Therefore, users should be encouraged to create new spreadsheets in the native LO odf and encourage recipients to either: (a) use LO or buy m$2013 in order to view openformula formulae or (b) view formulae results _only_ in earlier legacy m$ software. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure
ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas were left implementation-specific. Microsoft did not support the OpenOffice.org-specific formulas. Instead, they used Excel-specific formulas in ODF 1.1. On input of a not-supported formula expression, Excel in Office 2007 and 2010 drops the formula and preserves the last-calculated value. Whether a wise choice or not, that is what's done. As Regina says, Office 2013 supports ODF 1.2, including its OpenFormula specification. OpenFormula is also used by current implementations of LibreOffice and Apache OpenOffice when their documents are saved as ODF 1.2, so there is interoperability of formulas shared between ODF 1.2 implementing software. - Dennis -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Wednesday, January 23, 2013 05:20 To: LibreOffice Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure e-letter wrote: after opening in m$ excel 2010 (yes, m$ can open ods spreadsheets, so use that format please!!!) , the formulas were lost, leaving only the result values in the spreadsheet cells. Instead of reporting another erroneous LO bug, does someone know how to forward this error with m4 excel 2010 to m$ bug reporting service? That is a well known feature of MS Office. Excel would replace formulas with calculated values. For some reason, MS thought that was appropriate, even though no other spreadsheet app does that. This was back in the days when MS was ramming their OOXML standard through ISO. I believe, though don't know, that this has been corrected in later versions of MS Office. This is one bug that can be laid squarely at the feet of MS and one might even suspect it was deliberate. Bottom line, there's nothing for LO to fix. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files
That's not an ODF manifest. It is not clear what the scenario is. Can you describe, simply, what software, version, operating system, and computer saved this particular document with the manifest you show, below? If it was saved as an .sxc, it should not have used AES256, nor should it have used SHA256-1k. On attempting to open the document with the same software that produced it, what is the error report? It is possible that software designed to recognize the .sxc format will simply fail to properly deal with those encryption parameters, since they were not introduced until ODF 1.2. Replacing content.xml is not going to help. You need to leave the content.xml there as it was produced with the improper encryption so that it will be decrypted by the correct (improper) decryption. A. You can make the following changes to see if that helps: 0. Make a copy of the file. Rename it so the extension is .ods instead of .sxc. 1. Replace the beginning of META-INF/manifest.xml, !DOCTYPE manifest:manifest PUBLIC quot;-//OpenOffice.org//DTD Manifest 1.0//ENquot; quot;Manifest.dtdquot; manifest:manifest xmlns:manifest=http://openoffice.org/2001/manifest; manifest:file-entry manifest:full-path=/ manifest:media-type=application/vnd.sun.xml.calc/ ... with manifest:manifest xmlns:manifest=urn:oasis:names:tc:opendocument:xmlns:manifest:1.0 manifest:version=1.2 manifest:file-entry manifest:full-path=/ manifest:media-type=application/vnd.oasis.opendocument.spreadsheet ... [Note: There is no !DOCTYPE ... in ODF files.] 2. Attempt to open the file. If you are asked for your password, provide it. 3. If the file is reported as corrupted (even before reaching (2)), take the option to attempt to repair the file. 4. If you manage to open the file, do a Save As ... immediately as an .ods *with* *a* *new* *name*, with or without password. 5. You should be able to reopen that new version. Change your Tools | Options ... Load/Save settings to always save as ODF 1.0/1.1 (not 1.2). Save it *again* as an .ods with another new name. This should give you a version that uses the default encryption that is probably what worked with .sxc, but it is still an .ods. 6. Now check the spreadsheet to see if the content was recovered successfully. There may be defects or problems because of differences between .sxc and .ods. 7. If you must use .sxc, with the Load/Save setting still for ODF 1.0/1.1, you *might* be able to save again as an encrypted .sxc and successfully open it as well. B. The alternative is to decrypt the content.xml directly. That is a bit complicated and it requires that you have implementations of SHA1, PBKDF2, AES256-CBC, and DEFLATE (for decompressing the decrypted result). You won't need SHA256-1K because you can tell by inspection of the DEFLATE whether you got a successful content.xml XML file. C. Note that you must know the password in all of these scenarios. Unfortunately, the password recovery utilities that I am aware of have not been upgraded to deal with the AES encryptions and they only work if your password is very insecure. - Dennis -Original Message- From: raido [mailto:1rli...@klots.eu] Sent: Saturday, December 29, 2012 01:26 To: users@global.libreoffice.org Subject: [libreoffice-users] Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files Hi, I have old openoffice calc files (.sxc) with password protection. Libreoffice 3.5.1 managed to save those in old format and possible with aes256 encryption (as stated in manifest file). I have tried different technics to solve the problem: * googled around. Have not found a case where corrupted files have been restored, *used different libreoffice and openoffice versions to try to open the file, *tried to decrypt by hand (my skills and time ware out in generating password with PBKDF2 algorithm), *tried to modify manifest file to make it look like a 1.2 ODF version, *tried to replace content.xml in 1.2 ODF file (+ changing content.xml info in manifest file), *I tried with encryption tool named rltodfjlib.jar, *searched for backups. I modified the file 4 months ago during few days, saved once and did not try to open. My frequent backups are stored only for 2 months and older backups are too old, *possible done other things whics I have forgotten as I am pretty frustrated. The information in this file is not recoverable by other means, as original documentation on paper is destroyed by burning. And now I think I have only one question: is it possible at all to open such file with reasonable amount of time and resources?. At least I learned one good thing: verify that you can open saved file before you close it if the file is important. I guess the best explanation of my problem is in manifest file: ... !DOCTYPE manifest:manifest
RE: [libreoffice-users] RE: Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files
Do the same experiment, but this time specify Load/Save default as ODF 1.0/1.1 (not 1.2 or 1.2 extended). If that provides a successful Save with Password roundtrip to .sxc and back, you have a possible work-around. Then, to recover the existing file that is a problem for you, please do my Experiment A with the renamed file and modified manifest. - Dennis PS: On opening of the .sxc, the password is incorrect means that .sxc import does not realize that SHA256-1k is being used for the confirmation and/or it does not recognize AES and attempts to decrypt with Blowfish. When the sanity check on the decryption fails, the implementers assumed that it is because the password is incorrect and chose the error message accordingly [;). PPS: You have found a bug. Nothing but the default encryption techniques should be used when saving .sxc and ODF 1.0/1.1 formats with password. Probably the safest work-around is to use .ods from now on. There are also user configuration options to force default (Blowfish) encryption even for ODF 1.2 documents. I don't have those details. -Original Message- From: raido [mailto:1rli...@klots.eu] Sent: Saturday, December 29, 2012 12:21 To: users@global.libreoffice.org Subject: [libreoffice-users] RE: Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files Thank you for quick answer. About the scenario... I was using Linux i386 and an old .sxc file, but it does not depend on os. I just tried it and everyone can repeat it: OS: MS Windows 7 x64, Libreoffice 3.5.1 fresh installation. If Tools-Options-Load/Save-General Default file format and ODF settings changed to 1.2 Estended (recommended). I created a new file: File-New-Spreadsheet and saved it File-Save As..., changed file type to OpenOffice.org 1.0 Spreadsheet (.sxc)(*.sxc), checked Save with password and clicked Save. LibreOffice asks for password twice and asks if I want to use OpenOffice.org 1.0 Spreadsheet Format or ODF Format. After choosing 1.0 version. I close the spreadsheet and open it again. LibreOffice asks for password. After entering the password it says The password is incorrect. The file cannot be opened. Thats it. The start of manifest is such as I wrote. ODF 1.0, .sxc with AES256 and SHA256-1k. This is known problem, but I have not found is it possible to decrypt the content, or is it impossible. I belive, this is the same bug: https://bugs.freedesktop.org/show_bug.cgi?id=47482 I am sorry, I did not provide this information before. I replaced the content.xml into correct .ods file and changed manifest of the correct file to give correct checksum, iv, salt and other parameters. Now your suggestions: A. 1. Did so 2. opened, did not ask password 3. yes, asked for repairing 4. no, failed, gave Read error (thats normal, as file is encrypted and LO did not ask for password) I tried almost the same before writing to the list, only I did not change the extension to .ods and I left !DOCTYPE to manifest file. The result was the same. B. My knowledge here is not yet complete. I tried cat meta.xml |openssl enc -d -aes-256-cbc -iv `echo [iv-string from manifest]|base64 -d|xxd -p` -pass pass:`echo [my password]|pbkdf2.pl \`echo [salt from manifest]|base64 -d|xxd -p\` 1024|xxd -r -p` where pbkdf2.pl is from http://www.cit.griffith.edu.au/~anthony/software/pbkdf2.pl I have to study it more. Or maybe someone can help here also? C. yes, I know the password. Thanks again, Raido -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-3-5-1-corrupted-eas256-password-protected-ODF-ver-1-0-1-1-files-tp4026356p4026468.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Libre Office listed in petition to promote the use of free software in our schools
There is no provision for adding comments with a signature. It is a simple click-to-sign arrangement. Minimal identifying information, provided on registration for the site, is shown for distinguishing individual signers. - Dennis -Original Message- From: Paolo Debortoli [mailto:paolo_debort...@yahoo.com] Sent: Friday, December 28, 2012 17:00 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Libre Office listed in petition to promote the use of free software in our schools From: Tom Davies tomdavie...@yahoo.co.uk To: Alan Boba abo...@gmail.com; users@global.libreoffice.org users@global.libreoffice.org; us...@us.libreoffice.org us...@us.libreoffice.org Sent: Saturday, December 29, 2012 1:51 AM Subject: Re: [libreoffice-users] Libre Office listed in petition to promote the use of free software in our schools Hi :) I think with this sort of thing one just has to weigh-up whether it is better to let proprietary stuff win or sign something that might not be exactly the wording that each individual would choose. I'm not sure that each person can write their own thing. Do letters from individuals get added to the count? Regards from Tom :) I agree. We need ALWAYS to accept different points of wiev. The final outcome is more important. A friend of mine resgistered and signed without being US resident. In fact nothing says you need to be a US resident to sign a petition... I will also try. - Original Message - From: Alan Boba abo...@gmail.com To: users@global.libreoffice.org users@global.libreoffice.org; us...@us.libreoffice.org us...@us.libreoffice.org Cc: Sent: Friday, 28 December 2012, 20:32 Subject: Re: [libreoffice-users] Libre Office listed in petition to promote the use of free software in our schools On Fri, Dec 28, 2012 at 11:42 AM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) I thought a few people on the Users List might be interested in this petition. Apparently you need to create a whitehouse.gov account to sign Petitions which would probably put me off signing. On the other hand having a chance to kinda vote on single issues seems like a good thing. Hmm, a tough choice. Regards from Tom :) From: Immanuel Giulea giulea.imman...@gmail.com To: disc...@documentfoundation.org; market...@global.libreoffice.org; market...@us.libreoffice.org Sent: Friday, 28 December 2012, 15:01 Subject: [libreoffice-marketing] Libre Office listed in petition to promote the use of free software in our schools Hello all, From my readings of the mailing lists in the last few weeks, it seems that adoption of LibreOffice in North America (especially US) has been a challenge. Today, I found a petition addressed to the White House that includes LibreOffice. https://petitions.whitehouse.gov/petition/promote-use-free-software-our-schools-libre-office-gimp-gnu-cash-and-other-gpl-software-which-cost/T1xGw1fZ The deadline is three weeks away and they need 23,000 more signatures. Nothing is impossible through the power of social networks. I've already shared the petition to several G+ groups. Perhaps some posts from TDF core team on twitter and Facebook will help this initiative. Just a thought. Cheers from Montreal, Canada Immanuel Giulea -- Unsubscribe instructions: E-mail to marketing+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/marketing/ All messages sent to this list will be publicly archived and cannot be deleted I would sign but... The petition begins by castigating issues with proprietary software. My belief is that while those issues may be important they aren't a consideration for the great majority of computer users. In addition I find it much easier to support causes that don't cultivate fud but instead focus on the benefits of a proposed action. Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly
[libreoffice-users] RE: Windows 8 Compatibility - More Info
I wanted to check on the Access Violation that Tony experienced to see it was an easily reproducible situation for a Windows 8 installation of LibreOffice. Before doing that, I installed LibreOffice 3.6.4 on a Windows XP SP3 system. I then ran the Windows 8 Upgrade advisor. The upgrade advisor did not include LibreOffice in its report, neither as compatible or incompatible. However, there was a link to web resources for checking on applications not covered in Upgrade Advisor reports. After nosing around, I was led to here: https://www.microsoft.com/en-us/windows/compatibility/win8/CompatCenter/ProductViewerWithDefaultFilters?TempOsid=win8Locale=en-usTextSearch=LibreOffice There is a Compatibility Center where reports about particular applications are crowd-sourced. (Note that only major versions are identified.) The dual listing for LibreOffice Version 3 is because TDF is identified as the brand in one source, and libreoffice in another. The same Community Discussion backs up both, though. To see how this works, I voted on the TDF entry. I was unable to specify version 3.6 (only 3.3 and 3.5 are listed), nor was I asked for details. Interesting but not totally satisfying. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Friday, December 14, 2012 13:39 To: 'Jay Lozier'; users@global.libreoffice.org Subject: RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) Jay, I agree. There are two kinds of compatibility for Windows 8. First, desktop compatibility is essentially the same as for Windows 7. There is more room for gradual upgrade to integrate more smoothly, including on x64 machines with Atom processors, solid-state drives, and storage in the cloud. I think UX features will also adjust and improve, but that will be relatively gradual. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] RE: Windows 8 Compatibility - More Info
Apache OpenOffice 3.4.1 is indeed listed as compatible by the Windows 8 Upgrade Advisor. That's my counter-example to your presumption about competing products. I only went to the web site when I found that no LibreOffice version was listed (compatible or otherwise) after the Upgrade Advisor scan. The Advisor provided the link as part of the Why aren't all of my applications listed? dialog. I don't know how presence in the Advisor is determined, and how often the list it uses is updated. The crowd-sourced list on the web has many competing products. Since Windows 8 is very inexpensive until the end of January, I recommend that you go directly to Windows 8 Pro. This is equivalent to Windows 7 Ultimate (though I don't know about the Unix Subsystem). You'll have pretty much everything of Windows 7 (plus Hyper-V) and it appears that you can always mark a troublesome app to run as Windows 7 compatible. Also, run the Windows Upgrade Advisor and simply don't go to the purchase step. You'll have a report that at least warns about incompatible apps and whether or not there are updates, better drivers, etc. Finally, there are some extra steps to upgrade from a 32-bit OS to a 64-bit OS. (Ed Bott has provided tips about this, such as this FAQ: http://www.zdnet.com/the-ultimate-windows-8-upgrade-faq-706815/.) - Dennis -Original Message- From: webmaster-Kracked_P_P [mailto:webmas...@krackedpress.com] Sent: Monday, December 17, 2012 11:00 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] RE: Windows 8 Compatibility - More Info Right now libreoffice has 12 out of 13 votes for compatible The Documentation Foundation has 4 out of 4 votes. To be honest, do you really think that MS would list competition in their compatibility reports? Nearly half of my major packages were not reported in their Win7 compatibility report, the last time I ran it. Plus it told me a couple of packages were not compatible when the software companies advertise it works for XP through Win7. Have not tried the Win8, since I will not buy it. I should buy Win7, if possible next month for upgrading my 32-bit Vista [dual boot with Ubuntu] to Win7 64-bit. On 12/17/2012 12:49 PM, Dennis E. Hamilton wrote: I wanted to check on the Access Violation that Tony experienced to see it was an easily reproducible situation for a Windows 8 installation of LibreOffice. Before doing that, I installed LibreOffice 3.6.4 on a Windows XP SP3 system. I then ran the Windows 8 Upgrade advisor. The upgrade advisor did not include LibreOffice in its report, neither as compatible or incompatible. However, there was a link to web resources for checking on applications not covered in Upgrade Advisor reports. After nosing around, I was led to here: https://www.microsoft.com/en-us/windows/compatibility/win8/CompatCenter/ProductViewerWithDefaultFilters?TempOsid=win8Locale=en-usTextSearch=LibreOffice There is a Compatibility Center where reports about particular applications are crowd-sourced. (Note that only major versions are identified.) The dual listing for LibreOffice Version 3 is because TDF is identified as the brand in one source, and libreoffice in another. The same Community Discussion backs up both, though. To see how this works, I voted on the TDF entry. I was unable to specify version 3.6 (only 3.3 and 3.5 are listed), nor was I asked for details. Interesting but not totally satisfying. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Friday, December 14, 2012 13:39 To: 'Jay Lozier'; users@global.libreoffice.org Subject: RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) Jay, I agree. There are two kinds of compatibility for Windows 8. First, desktop compatibility is essentially the same as for Windows 7. There is more room for gradual upgrade to integrate more smoothly, including on x64 machines with Atom processors, solid-state drives, and storage in the cloud. I think UX features will also adjust and improve, but that will be relatively gradual. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] RE: 0xc0000005 error in RPCRT4.dll from soffice.bin)
Thank you. I did a little research. (There is a web site devoted to 0xc005!) This is an access violation error. It cropped up in a Windows system DLL (RPCRT4.dll is for remote procedure calls and it is part of Windows). It appears that the proximate cause is a request from soffice.bin. Windows 7 compatibility removing the problem suggests that this is related to automatic use of hardware security features that Windows 8 now imposes on applications by default. I checked on the certification requirements for Windows 8 desktop apps at http://msdn.microsoft.com/en-us/library/windows/desktop/hh749939.aspx. It appears that the issues that might need to be addressed are that of section 1.1 and those under section 3. I don't know the extent to which those have been addressed for LibO. I did observe some active work to comply on Apache OpenOffice. I don't know how much the automated tools for verification of the requirements help in this particular area. I don't have LibO on any Windows 8 configurations at the moment. I'll remedy that and see if this is a broadly-reproducible situation. - Dennis -Original Message- From: ubuysa [mailto:tonycros...@yahoo.co.uk] Sent: Sunday, December 16, 2012 00:41 To: users@global.libreoffice.org Subject: [libreoffice-users] RE: 0xc005 error in RPCRT4.dll from soffice.bin) Dennis E. Hamilton wrote [Back to the original topic...] I somehow missed the resolution to the behavior you saw. Was this related to the problem of a Java dependency not being satisfied (something that LO didn't break although a workaround is available here) or something else? - Dennis I don't know what was causing the original problem. I was running the latest version of Java but, just in case, I downloaded it again and re-installed. That made no difference to the problem. What did resolve the problem was to change the compatibility mode for swriter.exe to Windows 7. That's what led me to wonder whether LO 3.6 was fully Windows 8 ready? Since then I have set Windows 7 as the compatibility mode for all other LO components. -- View this message in context: http://nabble.documentfoundation.org/RE-0xc005-error-in-RPCRT4-dll-from-soffice-bin-tp4024539p4024599.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] RE: 0xc0000005 error in RPCRT4.dll from soffice.bin)
[Back to the original topic...] I somehow missed the resolution to the behavior you saw. Was this related to the problem of a Java dependency not being satisfied (something that LO didn't break although a workaround is available here) or something else? - Dennis -Original Message- From: ubuysa [mailto:tonycros...@yahoo.co.uk] Sent: Friday, December 14, 2012 22:21 To: users@global.libreoffice.org Subject: Re: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) [ ... ] FWIW it wasn't my intention to blame anybody. I had hoped I might be helping by highlighting what appears to me to be a minor issue with LO3.6 and Windows 8? I like to think I am more technically astute that the norm, although now retired I spent over 30 years as a sysprog working with large IBM mainframe operating systems. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)
There is a difference between what the OS provides when running on the Windows 8 desktop versus running an MX application. So far, I've only seen OneNote MX on what's called the Metro (or Modern) interface. The MX applications run full screen (or on the side) and the application has to be designed appropriately for it. I'd be surprised if it is practical to do this with the current OpenOffice-descendant code bases, especially for Windows RT, the version for ARM processors. I think extensive productivity applications will continue to run on the desktop side of Windows 8, at least when the computer keyboard and display form factors make that appealing. Versions designed for touch usage and MX-style will work on smaller form factors, including phones, and depend on the multi-touch gestures more. LibreOffice, OpenOffice, and Microsoft Office 2013 are desktop applications and benefit from what the OS provides without requiring application cooperation (apart from using the Windows APIs in ways that allows the OS personality to be extended to the application). For some form of inputs, such as accepting ink, the application has to cooperate. (Windows 8 also supports use of pen and stylus input. The Windows 8 Surface comes with a stylus, but the Windows RT Surface does not. But Windows 7 and the Windows XP Tablet PC editions from 2005 all support this form of input.) Office 2007 does work with my Tablet PC's features, although I think it is essentially via OS provisions. There may be some accommodation for ink from the Tablet PC stylus, but I have not explored that beyond how it works with Office 2007 OneNote. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Friday, December 14, 2012 10:44 To: dennis.hamil...@acm.org; 'ubuysa'; users@global.libreoffice.org Subject: Re: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) Hi :) I suspect that compatible means that it will work but that gestures and other stuff may not work fully and reliably. Does MSO 2007 support gestures? I doubt it. Some may work if the OS can access the relevant controls. From the original question i got the impression the person meant more than just working adequately and really wanted to know if everything was fully integrated and fully working. Hence why i said i doubt anything is properly fully Win8 ready. The separate track-pad looks quite nice. Not quite my cupp-tea although i like to play around with things like that for a while sometimes. When i was working in an accountancy practice i would have quite like a separate number-pad but only if it had a Tab key, to jump into the net field without having to reach for the mouse. The only ones i have seen are either thousands of pounds or miss crucial keys such as + and - let alone other useful ones such as Tab. Regards from Tom :) From: Dennis E. Hamilton dennis.hamil...@acm.org To: 'Tom Davies' tomdavie...@yahoo.co.uk; 'ubuysa' tonycros...@yahoo.co.uk; users@global.libreoffice.org Sent: Friday, 14 December 2012, 16:55 Subject: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) @Tom, What do you mean by Win8 ready? Do you mean integration with multi-touch, the additional UI provisions, or what? If you mean certified for Windows 8, it will depend on whether the requirements for that have been worked through. I know of no reason why LibreOffice can't achieve that. I don't know if it has been done. I'd be very surprised if older versions of Office don't already satisfy the essential requirements. If you mean compatible with Windows 8, anything that is compatible with Windows 7 should work. I just ran the Windows 8 Upgrade Advisor on my aging Tablet PC, running Windows XP SP3. It turns out that I can't upgrade because the processor on that machine does not have hardware NX support, and Windows 8 requires it as part of the tighter security with which it operates. However, on the review of software that needed to be upgraded or that is not supported, Office 2007 was listed as Compatible. In addition, on that particular machine, the Upgrade Advisor listed this software as compatible: OpenOffice.org 3.4.1 Apache Software Foundation I'm confident, when I run the Windows 8 Upgrade Advisor where I have LibreOffice installed, I will see a similar encouraging result. - Dennis PS: You can purchase boxed Microsoft Office 2013. It is very pricey. Here, we'll be renting, since one single lease will cover all of our multiple household machines and provide all of the Office components used here. It will be much easier to have the same version of Office on all systems going forward. It was too expensive to do that before. Some Personal Windows 8 Preparations: Something else I'm doing to prepare cutting over full
RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)
Jay, I agree. There are two kinds of compatibility for Windows 8. First, desktop compatibility is essentially the same as for Windows 7. There is more room for gradual upgrade to integrate more smoothly, including on x64 machines with Atom processors, solid-state drives, and storage in the cloud. I think UX features will also adjust and improve, but that will be relatively gradual. The second kind of compatibility is determined by whether or not an application is distributed via the Windows Store. As far as I know, that's reserved for MX applications that run on either Windows 8 or Windows RT. I also believe that is the only way a consumer can obtain MX applications that they didn't write themselves. (There are apparently ways for Enterprises to create something like their own stores.) So yes, there are two levels of capability. The productivity software such as LibreOffice is going to be running on the desktop for a long time. There is a great deal to figure out to see how to deploy on MX successfully. In a way, the same issues arise for Android and iOS as targets for the desktop productivity software that we've been relying upon. - Dennis -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Friday, December 14, 2012 12:04 To: users@global.libreoffice.org Subject: Re: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) On 12/14/2012 02:37 PM, Dennis E. Hamilton wrote: There is a difference between what the OS provides when running on the Windows 8 desktop versus running an MX application. So far, I've only seen OneNote MX on what's called the Metro (or Modern) interface. The MX applications run full screen (or on the side) and the application has to be designed appropriately for it. I'd be surprised if it is practical to do this with the current OpenOffice-descendant code bases, especially for Windows RT, the version for ARM processors. I think extensive productivity applications will continue to run on the desktop side of Windows 8, at least when the computer keyboard and display form factors make that appealing. Versions designed for touch usage and MX-style will work on smaller form factors, including phones, and depend on the multi-touch gestures more. LibreOffice, OpenOffice, and Microsoft Office 2013 are desktop applications and benefit from what the OS provides without requiring application cooperation (apart from using the Windows APIs in ways that allows the OS personality to be extended to the application). For some form of inputs, such as accepting ink, the application has to cooperate. (Windows 8 also supports use of pen and stylus input. The Windows 8 Surface comes with a stylus, but the Windows RT Surface does not. But Windows 7 and the Windows XP Tablet PC editions from 2005 all support this form of input.) Office 2007 does work with my Tablet PC's features, although I think it is essentially via OS provisions. There may be some accommodation for ink from the Tablet PC stylus, but I have not explored that beyond how it works with Office 2007 OneNote. - Dennis It seems to me that Win8 compatibility is harder to pin down. Does it mean that the software can function using the Metro/Modern/Whatever interface and the traditional desktop or that it runs in Win8 using some mode? IMHO this distinct will cause much confusion with people as to what is meant. Truthfully, I am confused how to properly describe Win8 compatibility and I have been using computers for 30 years plus. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Friday, December 14, 2012 10:44 To: dennis.hamil...@acm.org; 'ubuysa'; users@global.libreoffice.org Subject: Re: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) Hi :) I suspect that compatible means that it will work but that gestures and other stuff may not work fully and reliably. Does MSO 2007 support gestures? I doubt it. Some may work if the OS can access the relevant controls. From the original question i got the impression the person meant more than just working adequately and really wanted to know if everything was fully integrated and fully working. Hence why i said i doubt anything is properly fully Win8 ready. The separate track-pad looks quite nice. Not quite my cupp-tea although i like to play around with things like that for a while sometimes. When i was working in an accountancy practice i would have quite like a separate number-pad but only if it had a Tab key, to jump into the net field without having to reach for the mouse. The only ones i have seen are either thousands of pounds or miss crucial keys such as + and - let alone other useful ones such as Tab. Regards from Tom :) From: Dennis E. Hamilton dennis.hamil
RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)
Jay, Yes, user confusion and frustrated expectations do seem to be risks. I think the bigger problem will be with Windows RT systems, where Windows 7/8 and earlier desktop applications do not run at all. On Windows 8 systems, having both MX applications and desktop applications may or may not be a difficulty for users. We'll have to see. Software producers that have both a desktop and an MX version will need to be careful about how things work when both are installed on a Windows 8 machine. There are already examples of that with Internet Explorer, OneNote, Skype, SkyDrive, and Netflix. That's something to think about for LibreOffice too. - Dennis -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Friday, December 14, 2012 13:59 To: dennis.hamil...@acm.org Cc: users@global.libreoffice.org Subject: Re: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc005 error in RPCRT4.dll from soffice.bin) On 12/14/2012 04:39 PM, Dennis E. Hamilton wrote: Jay, I agree. There are two kinds of compatibility for Windows 8. First, desktop compatibility is essentially the same as for Windows 7. There is more room for gradual upgrade to integrate more smoothly, including on x64 machines with Atom processors, solid-state drives, and storage in the cloud. I think UX features will also adjust and improve, but that will be relatively gradual. The second kind of compatibility is determined by whether or not an application is distributed via the Windows Store. As far as I know, that's reserved for MX applications that run on either Windows 8 or Windows RT. I also believe that is the only way a consumer can obtain MX applications that they didn't write themselves. (There are apparently ways for Enterprises to create something like their own stores.) So yes, there are two levels of capability. The productivity software such as LibreOffice is going to be running on the desktop for a long time. There is a great deal to figure out to see how to deploy on MX successfully. In a way, the same issues arise for Android and iOS as targets for the desktop productivity software that we've been relying upon. - Dennis Dennis, The problem then is properly explaining to Win8 users what they should expect in terms of compatibility. But even so, I fear a large number of users will not either pay attention to the vendor statements or be confused by the MS advertising and believe that all software will work with the new UI like the advertised apps. It probably will be a lesser problem with FOSS projects because a higher portion of the user base is more technically astute. If we are having this discussion then the majority of users will be confused by this issue. The scenario, IMHO, is who will the user blame: MS or the software vendor? IMHO, I think the compatibility definition is caused by MS being schizophrenic with the OS and trying to make work on tablets/phones and desktops the same way. Jay [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?
That feature (the MDI interface) of Microsoft Office appears to be going, going, gone ... in Office 2013/365 [;). It still exists in Office 2010 although in my work it is more annoying than helpful. In the Office 2013 preview, the Windows are separate and the side-by-side feature is gone from Excel. Even if you are in Excel with an open document, and you open another, it opens in another Excel window. This makes sense for the ways that Windows 7 and Windows 8 operate. It also has the Office Apps usable in consistent ways whether running from the Web, on a desktop, or on other devices. I don't know what the considerations were, but the simplification and consistency are apparent. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Tuesday, December 11, 2012 04:40 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? Hi :) People have discussed various different ways that tabs could be implemented in LibreOffice. I would really like to see either of the main ways. The only one i could understand was having each tab as a different document but there was an old word-processor that had something very useful for working on documents longer than 1 page or so. Something like an advanced Navigation tool. In MS Office you can open more than one document and each one is opened inside the type of shell you see if you open LibreOffice without opening any document and just get the splash screen. That way you can maximise the Word window and have 2 or more documents in any arrangement you like without having multiple instances of their ribbon-bar and menus taking up even more excessive screen real-estate. Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: dennis.hamil...@acm.org Cc: 'anne-ology' lagin...@gmail.com; 'Jorge' jrodrigue...@cpcecr.com; 'Tom' tomdavie...@yahoo.co.uk; 'Dr. R. O Stapf' reinh...@stapf-online.com; users@global.libreoffice.org Sent: Tuesday, 11 December 2012, 3:26 Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? Hi. I can see 2 other interpretations from Anne-ology message. 1. She wants to be able to open the file twice, to visually compare the instance initially (and still) on disc with the instance edited in ram. 2. She wants to be able to visually compare 2 parts (paragraphs) in the same document. I used to do this many years ago on OS/2 in lotus or staroffice. Steve On 2012-12-11 15:41, Dennis E. Hamilton wrote: Umm, if two Text (.odt) documents have not changed dramatically, does not the Edit | Compare Document ... menu dialog provide a way of seeing how the currently open document is changed from another document? - Dennis -Original Message- From: anne-ology [mailto:lagin...@gmail.com] Sent: Monday, December 10, 2012 15:39 To: Jorge Cc: Tom; Dr. R. O Stapf; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? I wish this were true ... using WIN [now 7], it's not ;-( To be able to compare 2 versions side by side would be an asset - often, I've wanted to remember how something was worded ... so I have to close the document, open the other document then reverse the process because both versions cannot be open at the same time - I've tried minimizing one document but it closes on its own when the next document is opened - the computer is always a step ahead of me ;-) On Sat, Dec 8, 2012 at 3:26 PM, jorge jrodrigue...@cpcecr.com wrote: Hi: If I remember well...with LO you can compare two documents...and in Ubuntu there are some programs to do the same Regards, Jorge Rodríguez El vie, 07-12-2012 a las 00:21 +, Tom Davies escribió: Hi :) Side-by-side is fairly easy on Win7 and Ubuntu 12.04. Not sure about others but it's got to have originated somewhere and is probably on the cards elsewhere. Not sure about synchronised scrolling though, that part sounds like a good item for a feature-request / bug-report. http://wiki.documentfoundation.org/Bug_Report So, in Ubuntu 12.04 and Win7 just grab the first document's window and drag it to the far left as though you are dragging it off-screen. When a weird shadow fills half the screen let go. Whatever size and shape the windo had been it now fills half the screen. Do the same to the 2nd document's window but drag it to the right. Errr i choose left first just because it feels more comfortable to me. If you try to drag it off the top of the screen then the window tries to maximise. Of course you could use Alt Tab to flick between any windows on the workspace you are on and that can be a good way to compare quickly. Most GnuLinux distros also let you flick between different work-spaces quickly so changes jump
RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?
Umm, if two Text (.odt) documents have not changed dramatically, does not the Edit | Compare Document ... menu dialog provide a way of seeing how the currently open document is changed from another document? - Dennis -Original Message- From: anne-ology [mailto:lagin...@gmail.com] Sent: Monday, December 10, 2012 15:39 To: Jorge Cc: Tom; Dr. R. O Stapf; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? I wish this were true ... using WIN [now 7], it's not ;-( To be able to compare 2 versions side by side would be an asset - often, I've wanted to remember how something was worded ... so I have to close the document, open the other document then reverse the process because both versions cannot be open at the same time - I've tried minimizing one document but it closes on its own when the next document is opened - the computer is always a step ahead of me ;-) On Sat, Dec 8, 2012 at 3:26 PM, jorge jrodrigue...@cpcecr.com wrote: Hi: If I remember well...with LO you can compare two documents...and in Ubuntu there are some programs to do the same Regards, Jorge Rodríguez El vie, 07-12-2012 a las 00:21 +, Tom Davies escribió: Hi :) Side-by-side is fairly easy on Win7 and Ubuntu 12.04. Not sure about others but it's got to have originated somewhere and is probably on the cards elsewhere. Not sure about synchronised scrolling though, that part sounds like a good item for a feature-request / bug-report. http://wiki.documentfoundation.org/Bug_Report So, in Ubuntu 12.04 and Win7 just grab the first document's window and drag it to the far left as though you are dragging it off-screen. When a weird shadow fills half the screen let go. Whatever size and shape the windo had been it now fills half the screen. Do the same to the 2nd document's window but drag it to the right. Errr i choose left first just because it feels more comfortable to me. If you try to drag it off the top of the screen then the window tries to maximise. Of course you could use Alt Tab to flick between any windows on the workspace you are on and that can be a good way to compare quickly. Most GnuLinux distros also let you flick between different work-spaces quickly so changes jump out at you that way too. Windows users probably aren't familiar with the spinning cube (which i can never get to work). Of course Ubuntu kinda lost that quick flick between workspaces in 11.04 using Unity (unless i'm missing a key-combo (which is highly likely)) Regards from Tom :) From: Dr. R. O Stapf reinh...@stapf-online.com To: users@global.libreoffice.org Sent: Thursday, 6 December 2012, 23:10 Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? This would realy be a good feature. I also miss the possibility to compare to documents side by side and synchronized scrolling. I hate to say it but this is a good feature of MSO. Just hope that our devs can add ti to LibO. On 2012-12-05 20:50, Gilles wrote: I agree. I also miss being able to split a document horizontally in two halves. It's very useful when going through a big document. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?
If you want to compare one document with an earlier version, and you have both, do the following. Open the first document in LibreOffice Writer. When it is open, go to the menu above the document. Click Edit On the pull-down menu, click Compare Document ... A file open dialog will appear. Use it to open the earlier document. Writer now has a document that shows the changes from one to the other. Scroll through the result and see how the changes to the older document that result in the newer one. You can save this as a third document if you want. Or you can always make another comparison again. This may not be exactly what you are looking for, but it is very useful to know about. - Dennis Also, in working with a document, you can record changes as you do it. You can see the changes (show them as you type), or you can simply record them. Then you can show them whenever you want, change your mind, etc. This is on the Edit | Changes dialog. Turn on Edit | Changes | Record and the changes you make from then on are remembered and can be shown. -Original Message- From: anne-ology [mailto:lagin...@gmail.com] Sent: Monday, December 10, 2012 20:01 To: Dennis Cc: Jorge; Tom; Dr. R. O Stapf; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? well, now you've lost me ;-) On Mon, Dec 10, 2012 at 8:41 PM, Dennis E. Hamilton dennis.hamil...@acm.org wrote: Umm, if two Text (.odt) documents have not changed dramatically, does not the Edit | Compare Document ... menu dialog provide a way of seeing how the currently open document is changed from another document? - Dennis From: anne-ology [mailto:lagin...@gmail.com] Sent: Monday, December 10, 2012 15:39 To: Jorge Cc: Tom; Dr. R. O Stapf; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? I wish this were true ... using WIN [now 7], it's not ;-( To be able to compare 2 versions side by side would be an asset - often, I've wanted to remember how something was worded ... so I have to close the document, open the other document then reverse the process because both versions cannot be open at the same time - I've tried minimizing one document but it closes on its own when the next document is opened - the computer is always a step ahead of me ;-) On Sat, Dec 8, 2012 at 3:26 PM, jorge jrodrigue...@cpcecr.com wrote: Hi: If I remember well...with LO you can compare two documents...and in Ubuntu there are some programs to do the same Regards, Jorge Rodríguez El vie, 07-12-2012 a las 00:21 +, Tom Davies escribió: Hi :) Side-by-side is fairly easy on Win7 and Ubuntu 12.04. Not sure about others but it's got to have originated somewhere and is probably on the cards elsewhere. Not sure about synchronised scrolling though, that part sounds like a good item for a feature-request / bug-report. http://wiki.documentfoundation.org/Bug_Report So, in Ubuntu 12.04 and Win7 just grab the first document's window and drag it to the far left as though you are dragging it off-screen. When a weird shadow fills half the screen let go. Whatever size and shape the windo had been it now fills half the screen. Do the same to the 2nd document's window but drag it to the right. Errr i choose left first just because it feels more comfortable to me. If you try to drag it off the top of the screen then the window tries to maximise. Of course you could use Alt Tab to flick between any windows on the workspace you are on and that can be a good way to compare quickly. Most GnuLinux distros also let you flick between different work-spaces quickly so changes jump out at you that way too. Windows users probably aren't familiar with the spinning cube (which i can never get to work). Of course Ubuntu kinda lost that quick flick between workspaces in 11.04 using Unity (unless i'm missing a key-combo (which is highly likely)) Regards from Tom :) From: Dr. R. O Stapf reinh...@stapf-online.com To: users@global.libreoffice.org Sent: Thursday, 6 December 2012, 23:10 Subject: Re: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally? This would realy be a good feature. I also miss the possibility to compare to documents side by side and synchronized scrolling. I hate to say it but this is a good feature of MSO. Just hope that our devs can add ti to LibO. On 2012-12-05 20:50, Gilles wrote: I agree. I also miss being able to split a document horizontally in two halves. It's very useful when going through a big document. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how
RE: [libreoffice-users] Calc formula for US Thanksgiving date
You should get a lot of responses on this. US Thanksgiving is always the 4th Thursday in November. So, the first thing you want to do is find out what day of the week November 1, , in a particular year is. (There are functions for this). Then find out how many days later the first Thursday is. (In 2012, the answer is 0.) You'll have to work this out based on how day-of-week is counted. Add that number of days and 21 more to the November 1, date value. That will show you the date of Thanksgiving in year . (For 2012, the correct answer is November 22, 2012.) - Dennis -Original Message- From: . [mailto:l...@ebookring.net] Sent: Monday, December 03, 2012 02:59 To: users@global.libreoffice.org Subject: [libreoffice-users] Calc formula for US Thanksgiving date I need a formula for Calc to determine the US Thanksgiving date for a given year. Thanks -- www.eBookRing.net The designer and maker of the original eBookRing The perfect stand for eReaders, iPads, iPhones, tablet computers and other electronic devices. Patent Pending -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice
I don't understand the maddening aspect of this reaction. I suppose I don't have to. When ODF was developed at OASIS, one of the design points was to be based on the functionality of OpenOffice 1.x as it was at the time, starting from an XML format that was developed for that product. It was explicitly ruled out of scope for the format to have counterparts of Microsoft Office document features. When OOXML was developed, using the Open Packaging Conventions that were already used by Microsoft for a different project, a critical goal was to have fidelity-preserving, convertible features of legacy Microsoft Office documents. There is also a strict version that doesn't include so much of the legacy accommodation and has some better feature provisions going forward. There you have it. ODF 1.0 then ODF 1.1 and now ODF 1.2. Also, OOXML versions 1 through 3 (so far), although ODF changed more from ODF 1.1 to ODF 1.2 (because of the addition of OpenFormula) than anything that happened to OOXML since the ISO OOXML version. Neither of these are DocBook (an XML document format) or DITA or any other XML-carried document format. None of that is surprising in any technical way: XML is not a document format, it is a markup format for extending and customizing into any number of document models and schemas. XML by itself (unlike HTML, yet-another document format) doesn't establish any kind of document format whatsoever. There was an ISO working group looking into the harmonization of document formats, especially with what could make better portability among OOXML-based and ODF-based software. A recent report on the subject is rather interesting. Look at http://www.interoperability-center.com/en/dokumenten-iop-lab. The final report on Document Profiling and a White Paper on Document Interoperability are listed in the Publications sidebar. - Dennis -Original Message- From: VA [mailto:cuyfa...@hotmail.com] Sent: Wednesday, November 28, 2012 06:56 To: Pedro; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice This is utterly maddening. Based on Pedro's post, I ran a simple test. I created a document in Word (.docx) and an identical document in LibO (.odt). I saved them both and then extracted their contents using 7-zip Manager. I was amazed at how similar the two document contents were, and yet how different. Neither document had any of the binary smilie faces I've come to expect by opening a .doc document in a text editor. All of the individual files contained formatting codes in simple text. And, yet... The maddening part is how two programs can create the same type of documents (xml files saved in a zipped format) and yet remain so completely different. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice
I think you may be over-estimating the similarities. There are strong differences in the models and architectures of the two formats. And their goals were different. That they both use Zip and XML is a bit like saying my house and the railroad station both have copper plumbing. While it is the case that there are many common features that users see and use, how they are reflected in the format is quite different and, in some cases, lossy under portability, even sometimes incommensurable. Despite that, there is high portability for a class of documents. - Dennis Anecdote #1: Regina and I just ran into an interesting one. Passwords use to protect fields and sheets and text documents don't convert between the OOXML and ODF formats. One reason is that the code in which the password is stored before it is converted to a digital hash is different. So even if the hash is moved, it can't be unlocked using the other format because the internal form of the password is different, and there's no way to adjust the hash for that. (In the case of encrypted documents, as opposed to protected documents, that doesn't work either, not the least being that there is no encryption as part of OOXML.) Ignoring the encrypted document case, there are ways that the products could come closer with regard to protection passwords. Anecdote #2: Microsoft Word protects word documents by setting protection for the entire document and the user then selecting those parts of the document that are to have relaxed protection. Then a single password is used to lock in the arrangement. In ODF and OpenOffice, the selections to be protected are identified and they can be locked individually by passwords, with the rest of the document treated differently (or with yet another password). It is very had to take a protected document that was created in one model and convert it to a *protected* document in the other model. What is usually done is that each product ignores the protection settings from the other. This is a model incompatibility. That's a bigger deal, especially if it confounds something that is important to a very large number of users. -Original Message- From: VA [mailto:cuyfa...@hotmail.com] Sent: Wednesday, November 28, 2012 13:13 To: dennis.hamil...@acm.org; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice What I find maddening is that two document formats can be so similar, and yet remain so different. As Maxwell Smart would say, missed by THAT much. Virgil -Original Message- From: Dennis E. Hamilton Sent: Wednesday, November 28, 2012 1:27 PM To: 'VA' ; 'Pedro' ; users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice I don't understand the maddening aspect of this reaction. I suppose I don't have to. When ODF was developed at OASIS, one of the design points was to be based on the functionality of OpenOffice 1.x as it was at the time, starting from an XML format that was developed for that product. It was explicitly ruled out of scope for the format to have counterparts of Microsoft Office document features. When OOXML was developed, using the Open Packaging Conventions that were already used by Microsoft for a different project, a critical goal was to have fidelity-preserving, convertible features of legacy Microsoft Office documents. There is also a strict version that doesn't include so much of the legacy accommodation and has some better feature provisions going forward. There you have it. ODF 1.0 then ODF 1.1 and now ODF 1.2. Also, OOXML versions 1 through 3 (so far), although ODF changed more from ODF 1.1 to ODF 1.2 (because of the addition of OpenFormula) than anything that happened to OOXML since the ISO OOXML version. Neither of these are DocBook (an XML document format) or DITA or any other XML-carried document format. None of that is surprising in any technical way: XML is not a document format, it is a markup format for extending and customizing into any number of document models and schemas. XML by itself (unlike HTML, yet-another document format) doesn't establish any kind of document format whatsoever. There was an ISO working group looking into the harmonization of document formats, especially with what could make better portability among OOXML-based and ODF-based software. A recent report on the subject is rather interesting. Look at http://www.interoperability-center.com/en/dokumenten-iop-lab. The final report on Document Profiling and a White Paper on Document Interoperability are listed in the Publications sidebar. - Dennis -Original Message- From: VA [mailto:cuyfa...@hotmail.com] Sent: Wednesday, November 28, 2012 06:56 To: Pedro; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice
RE: [libreoffice-users] Can I lock a row so it doesn't move when scrolling?
It works similarly to Excel. Select the cell that is just below the rows you want repeated as row headings and just to the right of the columns you want repeated as column headings. On the toolbar select Window | Freeze To change it or remove it, just select Window | Freeze (it will show as checked, this unchecks it). You can now scroll around and any frozen columns and rows stay in the display. This is independent of the printing of column and row headings. For that, you need to use the Format | Print Ranges | Edit dialog. - Dennis -Original Message- From: Steven Dayton [mailto:daytonmeis...@gmail.com] Sent: Friday, November 23, 2012 09:19 To: users@global.libreoffice.org Subject: [libreoffice-users] Can I lock a row so it doesn't move when scrolling? Can I lock a row in spread sheet so it doesn't move out of view when I scroll down in long documents. I can do this in Excel but I haven't been able to find a way to do this in LibreOffice Calc. I have set up the first row in the spread sheet as a column titles row and I have over a 150 lines in the spread sheet. I would like that first row to remain in view as I scroll down the rows. Hope that makes sense. If there is a better way to set up column headers I welcome tips and tricks. -- StevenD So you want it fast, good, and cheap. Choose any two. A bad day at the beach is better than a good day at work. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?
The docx, xslx, pptx formats and others are OOXML. There are deviations as well as features (such as encryption) that are not part of OOXML. But most of the non-support claims about Microsoft honoring OOXML are based on the fact that early implementations supported the transitional flavor of OOXML. The move to the strict flavor, a separation created in the ISO process, has been made over time along with continuing support of transitional OOXML. My experience is that deviations with respect to the OOXML standard are documented better in Microsoft on-line implementation notes than is done by any implementations of ODF-based software. Microsoft Office also supports ODF 1.1 since Office 2007 SP2 and ODF 1.2 is supported in the new Office 2013. There are public, on-line implementation notes and documentation of deviations for those too. I've also heard that European versions of Microsoft Office can be set to have ODF as the default format. I have no way to confirm that and I am not certain that is new with Office 2013 or is also the case for Office 2010. The main binary formats, and RTF (a text-carried format) are now all documented and that has been true for a few years. All of the specifications are freely downloadable. - Dennis -Original Message- From: Don C. Myers [mailto:donmy...@myersfarm.com] Sent: Monday, November 19, 2012 08:57 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ? Hi Everyone, When the Microsoft formats were approved as an ISO standard, wasn't that supposed to make the information on their formats available to everyone else? From what I've read through the years, they have failed to implement their own ISO standards. Shouldn't there be some way to enforce the ISO standards approval on Microsoft so they can become inter-operable with LibreOffice? Don On 11/19/2012 08:03 AM, VA wrote: Tanstaafl wrote: There is one more hing that could turn this around - if the EU (or some other major governmental entity) were to engage in and win an antitrust lawsuit against Microsoft and force them to *fully* document their file formats, as happened with their Windows Server SMB protocols (which I understand has benefited the Samba project immensely). It would help immensely if the Open Source folks would combine their efforts on one excellent MS alternative. The twin development of AOO and LibO (with each having its own advantages over the other), only helps MS. Virgil -- ** -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?
The OOXML specifications are at least as complete and rigorous as the ODF ones. Every indication is that the ODF 1.2 support in Office 2013 is quite good. Of particular importance to many users is that OpenFormula is now supported, and this will provide a tremendous improvement in interop between LibreOffice Calc and MSO 2013. Whether this becomes a preferable path between Office and LibreOffice instead of relying on OOXML conversion in LO is an open question. You can test the support yourself using the in-browser support of documents via Web applications in Microsoft SkyDrive. Not all features are supported on SkyDrive (for either Microsoft OOXML or ODF), but this should provide an initial smell test. Yes, more detailed testing and comparison is a good idea. - Dennis -Original Message- From: Tanstaafl [mailto:tansta...@libertytrek.org] Sent: Monday, November 19, 2012 09:59 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ? On 2012-11-19 12:43 PM, Regina Henschel rb.hensc...@t-online.de wrote: You can get the OOXML standard from http://www.ecma-international.org/publications/standards/Ecma-376.htm Are you actually suggesting that this is either complete or accurate? You can get the binary file format description from http://www.microsoft.com/openspecifications/en/us/programs/osp/office-file-formats/default.aspx Ditto... a 'description of a file format' doesn't equate to somethinhg that can be used/relied upon to build something that accurately renders and/or recreates said format. The ECMA standard is available in MSO 2013 as OOXML strict, but LO fails to read it. So, I've heard, does MSO... MSO 2013 supports ODF 1.2. Really? Have you tested this? How accurately does it render ODF 1.2 files created with LibO? If an authority demands standards or even demands ODF, this can all be fulfilled with MSO, no need to use LO. Rotflmao! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: how to crack a PW in LO?
In terms of password-based encryption, the vulnerability to direct attack on the password has not changed measurably since ODF 1.0. However, the advances in processor performance have made many more attacks feasible. The move from Blowfish and 8-bit CFB (default) to (optional) AES-CBC has also reduced the amount of work required in an attack because modern processor chips have special instructions to make AES go faster, speeding the trial of different passwords as successful for decryption. Modern x64 processors with fast graphics GPUs help accelerate other stages of an attack as well. The heavy lifting is in creating hashes of trial passwords and then carrying out a key generation process to set up a decryption attempt. There are built in time delays, although the default delay count (1024) is not that daunting. These actions increase the work factor for a password attack, but poor password choices still yield easily. There are also features of OpenOffice-lineage encrypted documents that assist an attack in determining whether it has found a promising decryption or not. TRIAL DECRYPTION I created a Save with Password document using a 4 character password chosen randomly from the full ASCII 95-character set. I used the trial version of Accent OFFICE Password Recovery 7.10 build 2425 x64, available from http://passwordrecoverytools.com/office-password.asp. That release is from July of 2012. I used a Dell Studio XPS 9000 with x64 i7-980 (12 cores @ 3.33GHz), 18GB RAM, and ATI Radeon HD 5980 dual GPU. I am running Windows 7 Ultimate x64 SP1. The Accent OFFICE software does not recognize my GPU so it just pounded the CPU cores. (I have never heard my computer fans work so hard as with this software.) 1. For the document saved from LibreOffice 3.6.2, Accent OFFICE does not recognize the ODF 1.2 use of AES and could not handle the document. (This is doubtless a temporary condition and determined attackers are certainly not so limited.) 2. With the same document and password encrypted in the ODF 1.2 default Blowfish, Accent OFFICE's default attempt had an estimated run time of 1h18m and proposed a test of 235 million passwords. That attempt failed in the 30 minute time-limit of the trial version. 3. I repeated (2) using the option to make a brute-force attack. I specified that characters from the set of all ASCII printable characters (95) were used and that there were not more than 4 characters. The estimate was 85,828,704 tries and 27m03s. In fact, the password was found in under 10 minutes. (I had stepped away that long.) PREDICTIONS 4. BAD NEWS #1: When such software also handles the ODF 1.2 AES options, it will take no longer, perhaps even less time. 5. BAD NEWS #2: No GPU power was applied to this problem. It might not have mattered, but it won't be worse and could provide even more rapid decryption. 6. GOOD NEWS #1 (for now): Even allowing for (4-5), the estimates for longer passwords are heartening: Pwd Accent OFFICE Length Time Estimate (same conditions) 5 27m03s 6 1d19h 7 173d3h 8 45y197d You can see why length and random selection from the full 95 ASCII codes matters. Using larger character sets is even better, of course. I routinely use 15-character randomly-chosen passwords that are never used for more than one purpose. 7. GOOD NEWS #2 (for now): It is possible to crowd-source this work on multiple processors or as a challenge with multiple hackers over the internet, where the attack space is subdivided. Normally, one would not want to share the document, especially if its decryption is extremely valuable. However, there are parts of encrypted ODF documents that are benign and usable in a community/cloud-based attack. Once the password is recovered for that portion, the holder of the complete document can decrypt all of it. 8. WORSE NEWS #3: The kinds of passwords that folks routinely use to encrypt their own files remain easy to discover. The default 1h14m estimate will probably snag them. This makes recovery of a lost password feasible but it also means the privacy of the password and of the encrypted file is not what you might wish it to be were such a document to leave your personal possession. - Dennis -Original Message- From: Sandy Harris [mailto:sandyinch...@gmail.com] Sent: Friday, October 19, 2012 21:29 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? Googling on open office password crack turns up dozens of things. Here's one that looks real, if outdated: http://www.theregister.co.uk/2007/04/20/openoffice_password_crack/ That's 2007; we can hope O-O have improved the system since then Anyone know? The best-known purveyors of commercial password cracking services are Elcomsoft. PDFs, Word Documents, ... This Elcomsoft presentation on Adobe e-book passwords
RE: [libreoffice-users] Re: how to crack a PW in LO?
Oh, why is (7) considered Good News, below? Well, it takes 45*365+197 16,500 cooperating culprits to crack a 7-character random password in 1 day. If that seems too feasible (it might be), try a challenging length, like 16 characters. Just remember the Worse News, (8) in my previous message. At some point, it is necessary to abandon passwords as reliable for protecting the privacy of encrypted documents. All they do is increase the risk that an ordinary user will lose a password and not be able to open one of their own private documents. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, October 20, 2012 13:15 To: 'Sandy Harris'; users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: how to crack a PW in LO? [ ... ] 6. GOOD NEWS #1 (for now): Even allowing for (4-5), the estimates for longer passwords are heartening: Pwd Accent OFFICE Length Time Estimate (same conditions) 5 27m03s 6 1d19h 7 173d3h 8 45y197d You can see why length and random selection from the full 95 ASCII codes matters. Using larger character sets is even better, of course. I routinely use 15-character randomly-chosen passwords that are never used for more than one purpose. 7. GOOD NEWS #2 (for now): It is possible to crowd-source this work on multiple processors or as a challenge with multiple hackers over the internet, where the attack space is subdivided. Normally, one would not want to share the document, especially if its decryption is extremely valuable. However, there are parts of encrypted ODF documents that are benign and usable in a community/cloud-based attack. Once the password is recovered for that portion, the holder of the complete document can decrypt all of it. [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: how to crack a PW in LO?
It is important to separate the use of passwords to set protections from use of a password to encrypt the document. Only Save with Password provides cryptographic security of the document. The Save with Password encryption is difficult to attack. The password is usually the weakest point and the password may fall to a variety of attacks that use pre-computed dictionaries of SHA1 digests and other brute-force techniques. It is also possible that an attack may break the encryption without discovering the password itself. All of these attacks are believed to required great effort. In general, one should expect that a password used in Save with Password is not discoverable unless it is carelessly chosen or heavily reused. The harder the password is to attack, the harder it is to recover, of course. In contrast, all of the protection settings are insecure. The protections are trivial to remove. It can be done by any knowledgeable user with a Zip utility and an XML editor. It is not necessary to know the password to remove the protection. However, all passwords used in making protection settings should be considered compromised. That is because the document stores an SHA1 or other unsalted hash in plain view in the document. These hashes are cracked with ease using conventional systems. A password used to set a protection should not be used for any more-private purpose. In particular, if the same passwords are used for protections on unencrypted documents and for saving with password (encryption), the encryption can be broken directly using the SHA1 digest from the protection setting. Protection settings are on spreadsheet fields and sheets. There are protection settings on text as well. The protection against altering change-tracking and the protection for keeping a document read-only are all of this kind. The protection is useful for avoiding mistaken alterations. It is easy for all of these protections to be removed, the document altered, and the protections restored with the very same unlocking password without ever having to know the password. A digital signature can prevent the document from undetected alterations, but that doesn't work for turnaround documents where some alterations are meant to be allowed. There is more explanation of the use and risk of protections, and their removal, here: https://tools.oasis-open.org/version-control/svn/oic/Advisories/9-ProtectionKeySafety/trunk/description.html A proposal for more-reliable security of protection passwords (but not the protections themselves) is before the OASIS ODF TC: https://www.oasis-open.org/committees/document.php?document_id=46220. - Dennis -Original Message- From: Dr. R. O Stapf [mailto:reinh...@stapf-online.com] Sent: Tuesday, October 16, 2012 06:30 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? you are perfectly right about this!!! On 16.10.2012 22:22, Andrew Douglas Pitonyak wrote: Unless you have a lot of time to kill (days, weeks, months, etc), you are much better off not forgetting your password. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: how to crack a PW in LO?
Some protections are preserved in conversions between Office binaries and OpenOffice. But the protections in OOXML have digital hashes that are computed differently than those in ODF. They are not inter-convertible. Since the implementations tend to drop those protections in either direction, there is an easy round-trip technique to over-ride protections (but not encryption). Of course, there may be other incompatibilities that can have the result be undesirable. - Dennis PS: To preserve the protection, you'd either have to recover the password and rehash, or ask the user for the password as part of the conversion so it could be rehashed. There are conceivable extensions in the implementation of ODF that could facilitate protection preservation, but it might not be worth the effort considering that the protections don't really protect anything [;). -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Tuesday, October 16, 2012 08:21 To: dennis.hamil...@acm.org; 'Dr. R. O Stapf'; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? Hi :) Brilliant!! Ahhh, just thought of a problem. Was it xls or xlsX? If it has an X at the end then just rename the file to replace .xlsx with .zip and then double-click on it. Can the xml files be pulled into a new file without pulling the password along at the same time? Regards from Tom :) From: Dennis E. Hamilton dennis.hamil...@acm.org To: 'Dr. R. O Stapf' reinh...@stapf-online.com; users@global.libreoffice.org Sent: Tuesday, 16 October 2012, 14:34 Subject: RE: [libreoffice-users] Re: how to crack a PW in LO? It is important to separate the use of passwords to set protections from use of a password to encrypt the document. Only Save with Password provides cryptographic security of the document. The Save with Password encryption is difficult to attack. The password is usually the weakest point and the password may fall to a variety of attacks that use pre-computed dictionaries of SHA1 digests and other brute-force techniques. It is also possible that an attack may break the encryption without discovering the password itself. All of these attacks are believed to required great effort. In general, one should expect that a password used in Save with Password is not discoverable unless it is carelessly chosen or heavily reused. The harder the password is to attack, the harder it is to recover, of course. In contrast, all of the protection settings are insecure. The protections are trivial to remove. It can be done by any knowledgeable user with a Zip utility and an XML editor. It is not necessary to know the password to remove the protection. However, all passwords used in making protection settings should be considered compromised. That is because the document stores an SHA1 or other unsalted hash in plain view in the document. These hashes are cracked with ease using conventional systems. A password used to set a protection should not be used for any more-private purpose. In particular, if the same passwords are used for protections on unencrypted documents and for saving with password (encryption), the encryption can be broken directly using the SHA1 digest from the protection setting. Protection settings are on spreadsheet fields and sheets. There are protection settings on text as well. The protection against altering change-tracking and the protection for keeping a document read-only are all of this kind. The protection is useful for avoiding mistaken alterations. It is easy for all of these protections to be removed, the document altered, and the protections restored with the very same unlocking password without ever having to know the password. A digital signature can prevent the document from undetected alterations, but that doesn't work for turnaround documents where some alterations are meant to be allowed. There is more explanation of the use and risk of protections, and their removal, here: https://tools.oasis-open.org/version-control/svn/oic/Advisories/9-ProtectionKeySafety/trunk/description.html A proposal for more-reliable security of protection passwords (but not the protections themselves) is before the OASIS ODF TC: https://www.oasis-open.org/committees/document.php?document_id=46220. - Dennis -Original Message- From: Dr. R. O Stapf [mailto:reinh...@stapf-online.com] Sent: Tuesday, October 16, 2012 06:30 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? you are perfectly right about this!!! On 16.10.2012 22:22, Andrew Douglas Pitonyak wrote: Unless you have a lot of time to kill (days, weeks, months, etc), you are much better off not forgetting your password. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help
RE: [libreoffice-users] Re: how to crack a PW in LO?
I don't understand the XML question. In ODT and ODS, the protection keys are in the content.xml and settings.xml files. You can just delete the settings.xml to get rid of those protections (read-only and change-tracking). For the protection locks in the content.xml, you need to edit the xml. The web page on Safe Use of Protection sketches one approach at the end. For OOXML (.xlsx), the structure of the files is more complicated and I have not done the work to figure out how to hunt down and defeat the protections there. The simple approach is to simply try a cross-product transfer. Open the .xslx in LO; open the .ods in Microsoft Office. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Tuesday, October 16, 2012 08:21 To: dennis.hamil...@acm.org; 'Dr. R. O Stapf'; users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? Hi :) Brilliant!! Ahhh, just thought of a problem. Was it xls or xlsX? If it has an X at the end then just rename the file to replace .xlsx with .zip and then double-click on it. Can the xml files be pulled into a new file without pulling the password along at the same time? Regards from Tom :) [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: how to crack a PW in LO?
If you're talking about files with protections, minutes is on the long side. It is trivial to remove protections. If you're talking about Libre Office files created by Save As ... | Save with Password options, I would like to know who is claiming they can do that in any reasonable time. There are some older forms of Microsoft Word save with password that are easy to crack. Not newer ones though. Although I have concerns about the quality of the encryption used in ODF documents (what Save As ... | Save with Password uses), I don't think you're going to find any commodity software that is able to crack those in any feasible time period. If there is, that needs to be widely known. Care to share any links? - Dennis -Original Message- From: rost52 [mailto:bugquestcon...@online.de] Sent: Tuesday, October 16, 2012 19:07 To: dennis.hamil...@acm.org Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: how to crack a PW in LO? Dennis, When I am reading your long and excellent explanation, I wonder again how some PW removing tools, which offer a demo with opening the file or showing the PW removed, can claim that the file could be open within a few seconds to a minute? [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] compatibility / Symphony
The donated Symphony code has been received by the Apache OpenOffice project. It can be seen on the SVN repository. There is a team of developers, mainly in China, that are working to integrate the improvements in that code, especially around bug fixes and common features, into the AOO code base. Those developers provide an extensive and growing QA capability for AOO current releases as well. Now that Apache OpenOffice (incubating) 3.4.1 is out the door, the exploration of what to migrate into a 3.5 and what to do even more dramatically in a future 4.0 is under discussion. There had been discussion of whether or not to rebase AOO on Symphony or to gradually meld Symphony into AOO. The gradual path is being taken. There are wiki pages on 3.5 feature selection as well as ideas for 4.0. Anyone can look and, with registration, add to those deliberations. - Dennis -Original Message- From: anne-ology [mailto:lagin...@gmail.com] Sent: Tuesday, August 28, 2012 09:45 To: Mirosław Zalewski Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] compatibility / Symphony Thanks for this information. On Tue, Aug 28, 2012 at 11:34 AM, Mirosław Zalewski mini...@poczta.onet.plwrote: On 28/08/2012 at 17:58, anne-ology lagin...@gmail.com wrote: Thanks for informing the list; I'm interested in hearing further on Symphony?, as to where to find it, what all it contains, ... It's official name is IBM Lotus Symphony. Basically it is OOo derivative with altered user interface. There has been news flying around some time ago that IBM decided to discontinue Lotus Symphony in favor of Apache OpenOffice. It is said that IBM donates whole Symphony code to Apache repository and pay some developers to work on it. As far as I know, they still haven't done anything. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?
No, it was a mistake. The ODF 1.0 and ODF 1.1 standards did not provide a specification for spreadsheet formulas, so what OpenOffice implemented was implementation-specific and the Office team decided, with some public consultation, to not attempt to match OpenOffice, but to work within the ODF Standard. Hence the formula support was also implementation-specific (they used a namespace that defined Excel formulas) and there was no interop between Office and OpenOffice. However, now that there is ODF 1.2 and OpenFormula, you'll be happy to know that Office 2013 Preview supports OpenFormula in reading and saving ODS in Excel. You can test this by using SkyDrive with the Office Preview Web Apps. - Dennis -Original Message- From: Gordon Burgess-Parker [mailto:gbpli...@gmail.com] Sent: Tuesday, July 24, 2012 11:43 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users? On 24/07/12 15:38, Chuck Davis wrote: Cost them some money for new licenses but they upgraded their MS licenses to read my files. You need to be aware that MS Office 2010, while it will read ods files, strips out ALL the formulae - just leaving the last value. Yeah, sure, MS Office reads odf format.seems like a deliberate ploy to me. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?
I just used Office Word 2013 Preview to open a PDF that I saved from LibreOffice Writer. It opened in Word (with conversion) and edited just like a Word document. I was able to save it as a .docx (the default suggestion). I couldn't save as PDF though. That appears to be a glitch in the Preview, because Save As ... PDF is enabled. - Dennis -Original Message- From: NoOp [mailto:gl...@sbcglobal.net] Sent: Tuesday, July 24, 2012 19:14 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Do You Share ODF Documents With MS Office Users? On 07/24/2012 03:59 AM, Johnny Rosenberg wrote: [ ... ] (besides, the next version of MS Office seems to be able to open PDF files and edit them as if they were MS Office documents). Most of the MS Office 2012? [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?
I don't qualify for your use case. I use both ODF and OOXML and I use LibreOffice, Microsoft Office, and Apache OpenOffice (as well as some old OpenOffice.org versions). But my purpose is exploring interoperability available via the standardized formats. However, I can explain some of what you are experiencing. Sometime in 2011, maybe earlier, some of the ODF-based applications started producing ODF 1.2 packages by default. Those use features not defined in ODF 1.1. Microsoft Office 2007 and 2010 support ODF 1.1 (ODF 1.2 not being approved as an OASIS Standard until later). 1. Going to Office 2007/2010 with ODS: Microsoft Office is strict about what it supports and the unexpected ODF 1.2 features lead Microsoft Office to report that the document appears to be corrupted. If you use the option to attempt to repair the document, it will usually be repaired correctly because in practice the differences in the package of an ODF 1.2 document can be safely ignored. (That is not always true all of the time, but it should be for simple cses.) 2. Going from Office 2007/2010 to ODS: There will be a warning about potential feature loss. I don't think there is a way out of it. Doesn't LibreOffice do the same thing if you choose to export an XLS or XLSX file? In the Microsoft Office 2007/2010 case, this is a serious warning. For a simple document, there may be no problem but I don't think any of the implementations check to see if there is actually some feature that won't carry over properly. 3. In addition, there *is* a serious incompatibility between Microsoft Excel 2007/2010 ODS files and ODS files from any OpenOffice-heritage application. The formulas carried in the ODS are not compatible. This situation appears to be changing for Microsoft Office 2013. The preview supports the same formulas in Excel-supported ODS files as do the OpenOffice-heritage applications that now support ODF 1.2. (ODF had no specification for spreadsheet formulas until ODF 1.2.) You can test this improved fidelity, if you like, by using SkyDrive preview to see how much better your ODS files can be used by that implementation of Excel. There are still some warnings but not the corruption case in anything I've seen so far. You can find out about the new Web Apps preview at http://www.zdnet.com/microsofts-updated-office-web-apps-whats-new-701314/ https://skydrive.live.com/?officebeta=1 You'll need a Windows Live ID if you haven't one already. - Dennis I have a little more about this at http://mail-archives.apache.org/mod_mbox/incubator-ooo-dev/201207.mbox/%3c002d01cd66bd$d44e3640$7ceaa2c0$@acm.org%3e -Original Message- From: Don Parris [mailto:parri...@gmail.com] Sent: Monday, July 23, 2012 18:04 To: users@global.libreoffice.org Subject: [libreoffice-users] Do You Share ODF Documents With MS Office Users? I would like to take something of a straw poll, if that's ok. I simply want to know whether any of you have shared documents using the ODF format with MS Office users (preferably in a business environment), and what was the reaction? What problems I am not seeking advice on how to share documents with MS Office users. Nor am I interested in an in-depth analysis of why one might experience problems in sharing such documents. I simply want to know your experience. I have been sharing a simple spreadsheet document between LO (at home) and MSO (at work) in the OD format. The experience has been interesting on the MS Office side of it. I get error messages (that don't seem to be real errors), and if I choose the repair option, it claims to fix the errors, and even gives me a link to click to see the list of alleged corrections. The list is just a near-empty XML document. And to save a document in ODF raises a warning *every single time*, with no opportunity to say stop warning me. I know most of us still have to deal with both suites. I just wonder if anyone else (how many???) has experienced similar issues. Thanks, Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and
RE: [libreoffice-users] a little math problem with Calc
What I found interesting was that Calc (in LO 3.3.2) did not have that problem: Have A1 hold 11.18 Then A2 = INT(100*(A1-INT(A1))) works just fine. I think it would be safest to do A3 = ROUND(100*(A1-INT(A1))) though. -Original Message- From: Steve Edmonds [mailto:steve.edmo...@ptglobal.com] Sent: Thursday, July 05, 2012 13:37 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] a little math problem with Calc Hi. I tried your function but made the last line Test = r(3). It does return 17. My guess is that by the completion of r(2)=r(1)*100 the value is very slightly less than 18 and int then produces 17. steve On 5/07/12 1:50 PM, alex sato wrote: Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press [F2] -Insert the formula =TEST(E1) -press [CTRL]+[SHIFT]+[ENTER] -insert 11,18 in E1 and see the result in cell D1 I think the result should be 18 but I'm getting 17 Where is the error? By the way, I downloaded and installed the latest version of LibreOffice before write this email to make sure that is not a solved bug. And I tried this at least in 3 computers. Thanks in Advance Alex Mitsio Sato -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: CALC - How to count blank cells?
@dave_ When I have an expanding set of rows, I include a blank buffer row after the last one, and I include that row in any ranges. If there is a row that will always be outside the range, before the beginning and after the end, and have no data, I will anchor my ranges on that spread. Then when adding rows, I always use the insert rows feature so that even for new rows on the end of the data, an Insert Row with the buffer row selected will make a new one above the buffer and automatically included in the range. (Of course, inserting at other internal rows of the selection also works just fine to expand the range of the selection.) But that is for data that I build up incrementally. I don't know what your use case is. More complex cases involving special cells with unique flag values take more involved work and I've never needed to do that. - Dennis -Original Message- From: Simon Cropper [mailto:simoncrop...@fossworkflowguides.com] Sent: Wednesday, July 04, 2012 16:46 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: CALC - How to count blank cells? On 05/07/12 05:22, dave_ wrote: Thanks to both Simon and Miguel for their solution (they both works). One more question and this problem is solved for good. I notice I give a range larger than the actual data (rows) needed. How can I limit the range based on the last row that has data? This will give me an actual count of blanks cells within the rows being added. Again, thanks for the help or should I say for the support. -- View this message in context: http://nabble.documentfoundation.org/CALC-How-to-count-blank-cells-tp3993572p3993714.html Sent from the Users mailing list archive at Nabble.com. It is a bit unclear what you are trying to do. It appears you are trying to establish the number of rows with data in them for some sort of import/reiteration routine. Maybe what you should be doing is counting how many values in your range using COUNTA(), DCOUNT() or DCOUNTA() rather than looking for the number of blanks, the last cell used and presumably the difference between these two values. -- Cheers Simon [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: stubborn macro security
From what Andreas says, it appears that the flag you care about is in settings.xml within the Zipped .odt package. It is generally benign to simply delete the settings.xml file. Try it on a copy to see if it accomplishes what you want. - Dennis -Original Message- From: Girvin R. Herr [mailto:girvin.h...@sbcglobal.net] Sent: Saturday, June 30, 2012 14:45 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: stubborn macro security Andreas, Andreas Säger wrote: Where is the macro stored? Obviously you store it in the template and all resulting documents from that template inherit the macro. When you store a new document from that template in some untrusted location, the macro can not be trusted anymore. I assume the macro is stored in the particular document I wanted to change. I used the process in the 3.4 Writer Guide, Updating a Document From a Changed Template attempting to change that document's template update flag. In this document and some others, in the past I must have clicked on Keep Old Styles in the popup and according to the Writer Guide, that sets a flag to never allow template updates again for the document. Apparently, the only way to re-enable it is to run this BASIC Macro to set the oDocSettings.UpdateFromTemplate flag to True. It is supposed to cancel the Keep Old Styles selection. The macro function is called FixDocV3 if that helps. I just realized that this is a *BASIC* macro, not the usual keystroke type macro. That difference may have confused you and other users when reading my message. Does a BASIC macro have a different security option somewhere? Not knowing what the file format is, is it possible to unzip the document and search for UpdateFromTemplate and edit it to True, as an alternate to the BASIC macro? If UpdateFromTemplate is hard-coded into the document rather than the symbolic name, I would need to know where it is in the document to change it, which I don't know. Thanks. Girvin -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Signing Documents with a personal Certificate
Here's something more about passwords (not digital signatures) if you are going to take password-based actions with ODF documents: https://tools.oasis-open.org/version-control/svn/oic/Advisories/9-ProtectionKeySafety/trunk/description.html This message is not about the provision for digital signatures, since that is not password based. However, the encryption is password based and the encryption is not very strong (and that has nothing to do with whether AES or Blowfish are used). Here's more about ways to either not be exposed to password discovery (AUTHZ160) or to use a password based scheme that is harder to use in determining a password (SHA1DK): https://tools.oasis-open.org/issues/browse/OFFICE-3703. In case y'all somehow missed it, there has recently been massive successful attacking on passwords for web services. The key problem is that the password itself tends to be vulnerable to discovery by using stolen or disclosed hashes for them. While use of salts helps against opportunistic attacks, it will not deter a determined attacker who can crowd-source an attack using readily available personal computers. In fact, the situation is so bad that the provider of a web service with millions of user accounts can't tell the difference between a prank and an actual hack: http://orcmid.wordpress.com/2012/06/07/password-security-1-social-engineering-an-sha1-hack/. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Thursday, June 21, 2012 11:20 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Signing Documents with a personal Certificate Hi :) Leet speak is a fav. Some sites said it was weak, others said it was fairly tough. The length of a poem would radically increase the strength! Even a little verse would be great. Regards from Tom :) --- On Thu, 21/6/12, Marc Grober m...@interak.com wrote: From: Marc Grober m...@interak.com Subject: Re: [libreoffice-users] Signing Documents with a personal Certificate To: users@global.libreoffice.org Date: Thursday, 21 June, 2012, 16:02 Use a phrase from a poem that you like and substitute - like 0s for os On 6/20/12 11:50 PM, Steve Edmonds wrote: 1 lower case letter, 1 upper case letter, a number, white space and a misc symbol, a second additional point for having it over 30 characters and don't include any section of your name, or password or email address or if it matches a word from the English dictionary. Hows an over 50 supposed to remember a password like that!! On 2012-06-21 17:47, Marc Grober wrote: https://www.cacert.org/index.php?id=1 On 6/20/12 6:14 PM, James Knott wrote: Marc Grober wrote: get a cert from CACert.org Hmmm... I just tried going to that site and got this: This Connection is Untrusted You have asked Firefox to connectsecurely to www.cacert.org, but we can't confirm that your connection is secure. Normally, when you try to connect securely, sites will present trusted identification to prove that you are going to the right place. However, this site's identity can't be verified. What Should I Do? If you usually connect to this site without problems, this error could mean that someone is trying to impersonate the site, and you shouldn't continue. Not good for a certificate site. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software
You should be able to delete all of Configurations2/..., Thumbnails/thumbnail.png, and manifest.rdf without any harm whatsoever, so long as the related manifest:file-entry elements are deleted from META-INF/manifest.xml. You should probably *not* keep the settings.xml if you are creating a different content.xml file (just in case). You might check on consistency of version attribute occurrences and their values. For ODF 1.2 documents, it is expected that there will be a consistent use of 1.2 in a variety of places. If there are any missing version attributes or ones with conflicting values of 1.0 or 1.1, that might be a problem as well. This is a bit trickier. What version of ODF are you specifying in your template and the subsequent manipulations? It could be none of these that are derailing LO. It could be some sort of problem being caught in the resolution of styles, or some problem where automatic styles are involved. SOMETHING ELSE TO TRY When LO says the document is corrupted, do you have an option to attempt recovery or repair? When you exercise that option, can you save the result and reopen *that* successfully in LO ? I think you have done this according to your other report. If that works, you then need to figure out what it is that is different in the repaired one and the one that was declared corrupt. Look at the manifest and the files that are present, and in the root element opening tags for styles.xml and content.xml. (Notice the office:version attributes and any manifest:version attributes as well.) Check to see whether automatic styles were added to content.xml where there are none (?) for your corrupted document. - Dennis -Original Message- From: Eric Brunel [mailto:eric.bru...@pragmadev.com] Sent: Tuesday, June 05, 2012 01:25 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software [ ... ] Working from memory in order to reply quickly, I believe that there *IS* an ODF requirement for every stream in the package (a Zip) to be accounted for in META-INF/manifest.xml except the manifest itself, mimetype, and anything else in META-INF/ (except if it is meant to be encryptable). I suspect the specifications are silent concerning META-INF/manifest.xml entries that have no corresponding stream in the Zip. I need to confirm the facts. Thanks for the hints. Worked on that, but no luck so far: I removed the references to the non-existing files and directories in the META- INF/manifest.xml file, but the document is still reported as corrupt. Then I did the reverse: keeping the existing META-INF/manifest.xml file and copying all the missing files and directories from the repaired document: LO still says the document is corrupt… I've checked the manifest.xml file thoroughly, and it does reference exactly all the files in the document, except everything in the META-INF directory itself and the mimetype file. I would not be surprised if this tightening of consistency with the manifest is for purposes of improved detection of tampering and the possible incidence of a security exploit of one kind or another. There is a practice in security cases to avoid providing details since it provides too much information for someone attempting to craft an exploit. That's a stretch in this case. This was what came to my mind too… It would be useful to soften the message to one of There are inconsistencies and it is possible the document is corrupted. The request for permission to attempt correction by eliminating the inconsistencies should be quite clear. It would also be valuable to report whether there was any apparent data loss or that repair did not involve loss of anything critical to the document. Encouraging a save-as of the repaired document to a different location would also be handy in restoring the confidence of the user in the successful effort. Well again, telling the reason why the document is reported as corrupt would be a great help too. As it is now, we have to rely on wild guesses to figure out what to correct in the generated document, and that's a long and painful thing to do… Anyway, thanks a lot again for your answers. - Eric - -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software
Corruption could indeed be triggered by there being an inconsistency between META-INF/manifest.xml and what is present in the package. It is interesting if that is a complaint about Configurations/.../current.xml (usually a zero-length useless component), which is private information from the producer that is not defined by ODF and can't be meaningfully used by any software other than the producer. For the most part, that material appears to be gratuitous and unnecessary. The missing Thumbnails/thumbnail.png is also benign. Working from memory in order to reply quickly, I believe that there *IS* an ODF requirement for every stream in the package (a Zip) to be accounted for in META-INF/manifest.xml except the manifest itself, mimetype, and anything else in META-INF/ (except if it is meant to be encryptable). I suspect the specifications are silent concerning META-INF/manifest.xml entries that have no corresponding stream in the Zip. I need to confirm the facts. - Dennis THINKING OUT LOUD: I would not be surprised if this tightening of consistency with the manifest is for purposes of improved detection of tampering and the possible incidence of a security exploit of one kind or another. There is a practice in security cases to avoid providing details since it provides too much information for someone attempting to craft an exploit. That's a stretch in this case. It would be useful to soften the message to one of There are inconsistencies and it is possible the document is corrupted. The request for permission to attempt correction by eliminating the inconsistencies should be quite clear. It would also be valuable to report whether there was any apparent data loss or that repair did not involve loss of anything critical to the document. Encouraging a save-as of the repaired document to a different location would also be handy in restoring the confidence of the user in the successful effort. MORE THINKING OUT LOUD: PS: If the original document was digitally signed, repair will lose the signature of course, but there should have been difficulties with verification of the presumed original too. If the original document was encrypted (Saved with Password), how that fails is very dicey. PPS: It is cumbersome to put too much into the analysis and repair as part of the mainstream operation of a product such as LibreOffice where performance is an important feature. A separate analysis and repair utility might be more valuable (and LO could launch it, of course) for providing smoother handling and forensic analysis when the product software detects an inconsistency. -Original Message- From: Barry Say [mailto:barr...@nspipes.co.uk] Sent: Monday, June 04, 2012 13:36 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software Eric Brunel wrote: So if anyone could have a look and tell us what we are doing wrong. Or even better, if there's a way to make LibreOffice tell us what's actually wrong in the document, that would be great. Hi Eric, I've followed most of the discussion to date and I have had similar experiences in the past. When I repaired the document you posted, two new directories appeared, Configurations2 and Thumbnails. In your original document, the directory META-INF contains a file manifest.xml whose contents contain references to the two missing directories and two files: Configurations2/accelerator/current.xml Thumbnails/thumbnail.png The first is empty and the second is a 181x 256 image of the page. I do not not know whether this is the core of your problem or not, but it is a place I for one would investigate. Barry -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?
Lotus Symphony is different from LibreOffice (all versions) and Apache OpenOffice 3.4. It forked much farther back than OO.o 3.x, as well as I can tell. Although it has unique features, it does not appear to have kept up with OpenOffice.org and its descendants in other respects. I just started a fresh Text document in Lotus Symphony 3.0.1 and tried a Save As ... . The only Microsoft Office formats I am offered are Microsoft Word 97-2003 (*.doc), Microsoft Word 97-2003 Template (*.dot), and Microsoft Rich Text Format (*.rtf). The only other formats are .txt, .sxw, .ott, and .odt. (There is an Export as PDF ... ). The only file formats I can make the default for Save are Open Document Format (no version), and Microsoft Office 97-2003. There are some other options for automatically converting from one to another on load and save. Lotus Symphony is going to end-of-life, with replacement by a Lotus packaging/customization of Apache OpenOffice in the future. The contribution of the non-Java Symphony-unique code to Apache OpenOffice is now under review.My personal prediction (FWiW) is that not much of that will be seen until Apache OpenOffice 4.0. There will be a 3.4.1 and perhaps progression to an AOO 3.5 before that. - Dennis -Original Message- From: Ken Springer [mailto:snowsh...@q.com] Sent: Monday, June 04, 2012 19:13 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Is 3.5.4 ready for business users? On 6/4/12 4:00 PM, Russell Wilson wrote: why? further complicate the issue, Aoo works I was curious as to whether Lotus Symphony was identical to Aoo, or if there were things that were better or worse in that release. -- Ken Mac OS X 10.6.8 Firefox 12.0 Thunderbird 12.0.1 LibreOffice 3.5.2.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?
I followed up on Lotus Symphony 3.0.1 already. For additional comparison, here are the corresponding details for Apache OpenOffice 3.4.0. The Microsoft Office Save As ... format cases are Microsoft Word 97/2000/XP (*.doc) Microsoft Word 95 (*.doc) Microsoft Word 6.0 (*.doc) Rich Text Format (*.rtf) Microsoft Word 2003 XML (*.xml) The only other formats are .odt, .ott, .sxw, .stw, .txt (two flavors), and .html Some folks notice the loss of WordPerfect conversions. I haven't seen much on the inability to export OOXML formats. I suppose an elephant in the room, at least for Windows platforms, is the possibility that the next version of Office (currently known as Office 15) might provide better interoperability with ODF formats than the *Office clan provide for OOXML. I have no reason to believe that will be the case, despite the opportunity that appears to exist for tipping the equation around business use even farther. Also interesting is the fact that Windows Live SkyDrive now supports native (and free) web-based upload, editing, and download of ODF documents at something around the current ODF 1.1 support from Microsoft. It will be interesting to see how that evolves along with the arrival of Office 15 too. This is a way to extend support for Office documents to non-Windows platforms using browsers and the cloud. [On my WindowsPhone 7.5, the Microsoft Office applications are still only for Microsoft Office documents, although OneNote is being provided as an App on other mobile platforms. If I attempt to edit an ODF document that I've uploaded to Skydrive, my phone switches to the browser access for editing the document. That could change too.] - Dennis -Original Message- From: Russell Wilson [mailto:russwilso...@yahoo.com.au] Sent: Monday, June 04, 2012 20:30 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Is 3.5.4 ready for business users? it's been some months since I tried it; I think there are supposed to be some added extras, but they're all much the same, depends on what features one wants / needs, and most importantly, what works for you, which as someone said, one can only determine subjectively, after trying it out for oneself From: Ken Springer snowsh...@q.com To: users@global.libreoffice.org Sent: Tuesday, 5 June 2012 2:12 PM Subject: [libreoffice-users] Re: Is 3.5.4 ready for business users? On 6/4/12 4:00 PM, Russell Wilson wrote: why? further complicate the issue, Aoo works I was curious as to whether Lotus Symphony was identical to Aoo, or if there were things that were better or worse in that release. -- Ken Mac OS X 10.6.8 Firefox 12.0 Thunderbird 12.0.1 LibreOffice 3.5.2.2 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Microsoft .TLA and .TLAx Extensions (was RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?)
The speculative responses to this suggestion are very amusing. I tried it. After all, computing is an empirical science [;). Here is what happened when I renamed a .xls to .xlsx: Excel [2010] cannot open the file 'longname.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. LibreOffice 3.3.2 Calc was perfectly happy to open the file correctly as the .xls that it actually is. I renamed a .doc to .docx and got this message from Word 2010: Word cannot open the file because the file format does not match the file extension. (\\Whs\...Spec9-copy.docx) LibreOffice 3.3.2 Writer was also successful in importing the file without complaint. I leave renaming .ppt to .pptx as an exercise. - Dennis -Original Message- From: Andreas Säger [mailto:ville...@t-online.de] Sent: Sunday, June 03, 2012 13:04 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Is 3.5.4 ready for business users? Am 03.06.2012 20:14, Felmon Davis wrote: I am curious: what happens if one just changes the file extension from .doc to .docx? F. Brilliant idea! This way you get much better results while the WinWord user will not notice any difference at all. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Microsoft .TLA and .TLAx Extensions (was RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?)
There are security issues around allowing MSO binaries being disguised as OOXML and then silently accepted anyhow. The decision, stupid or not, is clearly by design. To see the importance of this, note that you cannot rename a *.docm (macro-enabled) as a *.docx (no macros here, ever) and get away with it. Please keep in mind that the disguise was proposed on this list as a deception (regardless of whether the requirement was wrong-headed or not). And the deception is needed to compensate for the fact that Save As ... .docx is not the greatest thing since sliced bread in OpenOffice-lineage implementations. (Um, I am not sure that Save As ... .docx is even possible in Apache OpenOffice, although I am confident that will change.) - Dennis -Original Message- From: Andreas Säger [mailto:ville...@t-online.de] Sent: Sunday, June 03, 2012 18:00 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Is 3.5.4 ready for business users? Am 04.06.2012 00:50, Brian Barker wrote: You are implying that a file with a .docx extension but actually in .doc format will be happily opened by Microsoft Word - that Word will simply interpret the contents and ignore the inappropriate extension, that is. Sadly for your theory, that appears not to be the case. Brian Barker Thank you for trying. I did not know how stupid that program is. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] File associations - LibreOffice and OpenOffice on Windows 7
Here's the tip that I provided over on ooo-users. My system is busy right now so I can't check to see how well it works with AOO 3.4.0 also: You can try to add AOO associations manually, but it might not be effective. The problem is that LibreOffice, OpenOffice.org, and Apache OpenOffice all use the same (old Star Office) names for the individual application programs. Even if you succeed in having multiple swriter.exe associations, for example, you may have trouble telling them apart [;). I think you already know how to do this, by using the Open With ... context-menu and take the Choose Default Program option. You'll have to find the installed files and select them. Perhaps even make it the default at first, although you can select the program and remove the check mark on Always use the selected program ... . Thereafter, they should all be offered in the Open With ... without having to be added. But I suspect this is where you might be frustrated. (This is how I add WinZip to all of the ODF and OOXML extension names so I can simplify document-forensic work.) - Dennis PS: I just got this working for .odds on a Vista configuration that has OpenOffice 3.3.0, Symphony 3.0.1, and LibreOffice 3.4.3 installed. PPS: Installing Apache OpenOffice 3.4.0 seems to steal the default file associations, no matter who has them. Because of that I tend not to keep it around on any configurations where I want to use other ODF-supporting programs. (When uninstalled, AOO 3.4.0 leaves no associations behind.) I haven't tried the above procedure to get the other associations back. That's out of pique. Let me know if it works for you. -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Monday, May 21, 2012 13:13 To: LibreOffice Subject: [libreoffice-users] File associations - LibreOffice and OpenOffice on Windows 7 I previously installed OpenOffice on my computer and recently LibreOffice. I have also installed the various free Microsoft viewers. One thing I've noticed is that I can't have both LO and OO associated with the various file types. Please note that I'm just talking about association, not default association, so that when I right click on a file I can chose from among LO, OO or the Microsoft viewer. At the moment, my choices are just LO and the viewer. If I want to use OpenOffice, I have to open the app first and then the file. Any way around this? tnx jk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7
What I discovered in the Vista VM was that the icons are different between LibreOffice and OpenOffice.org scalc and they appear in the Open With ... dialog. There is no confusion there as a result. Lotus Symphony uses a different file name so there is no problem there. I don't know whether the choose program dialog will allow a shortcut to be used. That's an interesting idea though. -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Monday, May 21, 2012 14:25 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7 James Knott wrote: Dennis E. Hamilton wrote: [ ... ] I think you already know how to do this, by using the Open With ... context-menu and take the Choose Default Program option. You'll have to find the installed files and select them. Perhaps even make it the default at first, although you can select the program and remove the check mark on Always use the selected program ... . Thereafter, they should all be offered in the Open With ... without having to be added. But I suspect this is where you might be frustrated. (This is how I add WinZip to all of the ODF and OOXML extension names so I can simplify document-forensic work.) Got it. You gave me the idea. Instead of going into the OpenOffice folder and selecting, for example, swriter, I selected OpenOffice and it now appears as a choice when I right click. It also now possible to choose any of the three to be the default app. tnx jk I have found another way. Change the OpenOffice files to owriter etc. This way, OpenOffice Writer is displayed, instead of just OpenOffice.org 3.4, when right clicking. Perhaps creating a shortcut there may work too. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7
@James, I see. It happens that Windows XP will not let you assign a different program of the same name to be associated with the same file extension via Open With ... . When you go find the second program, it behaves as if you already have it in the list and won't add another to the list. This is *not* the case for Windows Vista (and therefore Windows 7 and Windows 8, I surmise). Those will provide all of the associations without trickery. To work around the Windows XP limitation, your trick of using soffice.exe instead of swriter.exe, scalc.exe, etc., works great. Until there are more than two that you want to hook up to the same extension [;). Changing the program-file names probably works so long as you don't change soffice.bin. I wouldn't do that except as a last resort. (It will mess up program updates and the uninstaller, for example.) I have a set of screen captures for walking through this on Windows XP. I'll put them in some mutually useful place. - Dennis PS: I confirmed this on a Windows XP where the install of Apache OpenOffice 3.4.0 stomped on the associations of LibreOffice 3.5.2.2. PPS: Unfortunately, something else was stomped on so sometimes the programs get blocked and there are multiple soffice.bin and soffice.exe instances running, but nothing useful happens. I am not sure that is repeatable. I'm going to try installing LibreOffice 3.5 *after* the AOO 3.4.0 to see if that is better. I suspect it might be. -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Monday, May 21, 2012 14:39 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7 What I discovered in the Vista VM was that the icons are different between LibreOffice and OpenOffice.org scalc and they appear in the Open With ... dialog. There is no confusion there as a result. Lotus Symphony uses a different file name so there is no problem there. I don't know whether the choose program dialog will allow a shortcut to be used. That's an interesting idea though. -Original Message- From: James Knott [mailto:james.kn...@rogers.com] Sent: Monday, May 21, 2012 14:25 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7 James Knott wrote: Dennis E. Hamilton wrote: [ ... ] I think you already know how to do this, by using the Open With ... context-menu and take the Choose Default Program option. You'll have to find the installed files and select them. Perhaps even make it the default at first, although you can select the program and remove the check mark on Always use the selected program ... . Thereafter, they should all be offered in the Open With ... without having to be added. But I suspect this is where you might be frustrated. (This is how I add WinZip to all of the ODF and OOXML extension names so I can simplify document-forensic work.) Got it. You gave me the idea. Instead of going into the OpenOffice folder and selecting, for example, swriter, I selected OpenOffice and it now appears as a choice when I right click. It also now possible to choose any of the three to be the default app. tnx jk I have found another way. Change the OpenOffice files to owriter etc. This way, OpenOffice Writer is displayed, instead of just OpenOffice.org 3.4, when right clicking. Perhaps creating a shortcut there may work too. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: DocX
@Brian, Thanks for the helpful rundown on viewers. For Windows and non-Windows platforms, the on-line SkyDrive viewers and editors can be used as well. There is reduced functionality, but it is probably still better than what happens attempting to use DOCX in OpenOffice-lineage software. Recently, they added not only storage but viewer/editor support for some ODF Formats, primarily ODF Text. See https://skydrive.live.com/. (There is now access to some of these on Smartphones too.) -Original Message- From: Brian Barker [mailto:b.m.bar...@btinternet.com] Sent: Sunday, May 13, 2012 09:50 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: DocX At 19:27 13/05/2012 +0300, Dotan Cohen wrote: Note that those [the freeware Microsoft viewers for Word, Excel, and Powerpoint document files] will not open .docx files: ... Natively, this is true, but read on ... http://support.microsoft.com/kb/891090 Please note that there was not a Word Viewer created for Word Viewer 2007 or Word Viewer 2010. To view Word 2007 and 2010 documents, please download the following link and install the Office Compatibility Pack noted below I like the typos on the MS site! The following link links to an Office Compatibility Pack for older versions of MS Office, so those with no MS Office installed cannot view Word 2007/2010 files. I think you miss the point here: the instruction is both to download (the viewer) and install the Compatibility Pack. The Compatibility Pack is indeed intended for systems with Microsoft Office XP (2002) or 2003 and it enables those versions of Office, as modified, to open, edit, and save documents in the new x formats. But it is equally applicable to the freeware viewers (which are effectively cut-down versions of components of Office 2003) and enables the viewers, as similarly modified, to open, display, and print documents in the newer formats too. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: rtf import broken in 3.5.1?
@Milos, I think a more reliable resource on the actual status of RTF can be found on Wikipedia at http://en.wikipedia.org/wiki/Rich_Text_Format. I have no idea what format Tom Davies has in mind. As far as I know it is not RTF. It appears that the RTF specification is quite stable. The format has a built-in provisions for future extensions to specify how a implementations that do not recognize the extension should fall back to an understood alternative. Although anyone could use that provision, it seems to me that some future extension will include carrying new features introduced in OOXML (ISO/IEC IS 29500) in RTF via XML-format inserts. That provision is already defined for RTF. The latest versions of the specification are quite comprehensive and are freely available. There is even sample code for processing the RTF data stream. To the best of my knowledge, RTF was not subject to any particular regulatory or legal problems. - Dennis MORE BACKGROUND AND RESOURCES In the work undertaken to satisfy regulatory requirements in the EU and the United States, there was a concerted effort to provide and maintain documentation on interfaces and formats that would provide for interoperability with Microsoft systems. That effort spanned several years. The technical-oversight body that was established to review that work has reported that the specifications are acceptable and that updating for current systems is happening in an acceptable way. RTF is not listed as one of those specifications. The RTF specifications are made available separately from these sets: http://msdn.microsoft.com/en-us/library/gg134032.aspx. http://msdn.microsoft.com/en-us/library/gg134034.aspx Nevertheless, RTF is covered under the Microsoft Open Specification Promise. See the end of the list at http://www.microsoft.com/openspecifications/en/us/programs/osp/office-file-formats/default.aspx. The Open Specification Promise itself and the span of its coverage can be found at http://www.microsoft.com/openspecifications/en/us/programs/osp/default.aspx. (Those OpenDocument Format specification versions that Microsoft has participated in, such as ODF 1.2, are also covered.) Finally, Microsoft provides implementation notes that account for deviations and implementation-defined provisions in Microsoft's implementation of public standards. Note the documents [MS-OI29500], [MS-OODF], and [MS-OODF2], among others, in this list: http://msdn.microsoft.com/en-us/library/gg134034.aspx. -Original Message- From: Milos Sramek [mailto:sramek.mi...@gmail.com] Sent: Friday, April 27, 2012 00:13 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: rtf import broken in 3.5.1? Dňa 26.04.2012 21:28, Tom Davies wrote / napísal(a): Hi :) What!! An agreed 'Open' Standard that MS never quite implemented in the way they had promised but still managed to push as the unifying standard that all other companies had to follow. The format they promised would have long term support so that historical archives and such could reliably store documents for the long-term future in much the way that books have lasted. The one that no-one other than MS (hmm, not even MS) managed to implement because MS never quite got around to publishing how they had messed up the format in any particular release. The format that resulted in court actions which MS apparently lost. The one that MS is quietly dropping support for and not developing any further so that all existing problems remain. Dear Tom, do you have any references to those court cases? Sounds very interesting. RTF is in Slovakia one of the officialy approved standards to be used by public administration (besides pdf, odf and HTML). Of course, since MS is everywhere and everybody uses RTF. Information about those court trials would be a nice argument against RTF, the compatibility of which in LO/OO/OOO is really pain. This would show why is it so. Milos Luckily we have all learned our lesson and anyway MS wouldn't try to fool us the same way again, right? lol ;) Regards from Tom :) --- On Thu, 26/4/12, Andreas Sägerville...@t-online.de wrote: From: Andreas Sägerville...@t-online.de Subject: [libreoffice-users] Re: rtf import broken in 3.5.1? To: users@global.libreoffice.org Date: Thursday, 26 April, 2012, 20:06 RTF never really worked in OOo nor LibO and there are reasons why: http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare -- View this message in context: http://nabble.documentfoundation.org/rtf-import-broken-in-3-5-1-tp3877445p3942245.html Sent from the Users mailing list archive at Nabble.com. -- email jabber: sramek.mi...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:
RE: [libreoffice-users] Re: rtf import broken in 3.5.1?
@Tom I'm not sure what you are asking, but this might be relevant: In this 2010-12-09 document, http://technet.microsoft.com/en-us/library/cc179199(office.14).aspx#BKMK_Changed It says that the The RTF file format is no longer enhanced to include new features and functionality. Features and functionality that are new to Word 2010 and future versions of Word are lost when they are saved in RTF. In addition, Word 2010 supports a new converter interface based on Open XML Formats. I suppose LibreOffice and OpenOffice could make the same statement concerning features and functionality of ODF (now or in the future) that do not map to RTF. In other, more recent statements, there is assurance that RTF 1.9.1 is stable enough for meaningful reference from International Standards even though there is no International Standard for it. There is no indication that Saving documents as RTF and opening documents in RTF format is going away any time soon. As to the quality of RTF support in various software products, this tells us nothing. Those who maintain implementations need to be consulted about problems in their handling of the format. Bugs in the format specification are a different matter. There are Microsoft forums for some discussions on both of those concerns: http://social.msdn.microsoft.com/Search/en-US/openspecifications?query=RTFbeta=0ac=8 is a general search. Using Refine search, By Source: on the left sidebar is interesting. - Dennis MORE ANALYSIS There are two different statements in the 2010-12-09 quoite, and I don't quite know why the supports a new converter interface based on Open XML Formats is mentioned. However, there are ways for OOXML features and functions to be passed to RTF, as I mentioned. I imagine there are or will be features and functions in OOXML (and ODF) that can't be embedded in RTF in any useful way. Also, there is a difference between enhancing the RTF format and using the RTF formats for carrying extended material that is not in RTF format. It would obviously be better to go to an XML-based format, such as OOXML/ODF as a vehicle for interchange in the future. It seems to me that handling the OOXML features that are passed around in RTF requires the ability to faithfully accept OOXML as well [;). There is a 2011-03-17 statement to ISO considering RTF that assures stability and availability. The 2011-03-17 statement describes the acceptability of referencing RTF specification in International Standards even though there is no International Standard for RTF. (The same considerations apply to the use of Zip in the ODF and OOXML specifications.) RTF is referenced in the IS 29500 specification as a format that OOXML documents can link to, although IS 29500 does not include the RTF specification: The RTF Specification [for RTF] was last updated in 2008, and the RS Originator [Microsoft] anticipates no further updates. However, the RTF Specification will remain under maintenance and Defect Reports [an ISO technical term] will be fully considered and discussed with SC34 [the OOXML ISO maintenance body]. ... The RS Originator is willing to consider editorial and non-substantive modifications of the RTF Specification during an associated IS 29500 [OOXML] balloting period, but would not make change which alter normative functions in this RTF Specification. Other text indicates that the RTF specification is freely available and covered under Microsoft's Open Specification Promise, as I have already described. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Friday, April 27, 2012 11:36 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: rtf import broken in 3.5.1? Hi :) Who is developing the Rtf format? Who is maintaining it and working at any problems that arise with it? Regards from Tom :) --- On Fri, 27/4/12, Dennis E. Hamilton dennis.hamil...@acm.org wrote: From: Dennis E. Hamilton dennis.hamil...@acm.org Subject: RE: [libreoffice-users] Re: rtf import broken in 3.5.1? To: users@global.libreoffice.org Cc: 'Milos Sramek' sramek.mi...@gmail.com Date: Friday, 27 April, 2012, 18:38 @Milos, I think a more reliable resource on the actual status of RTF can be found on Wikipedia at http://en.wikipedia.org/wiki/Rich_Text_Format. I have no idea what format Tom Davies has in mind. As far as I know it is not RTF. It appears that the RTF specification is quite stable. The format has a built-in provisions for future extensions to specify how a implementations that do not recognize the extension should fall back to an understood alternative. Although anyone could use that provision, it seems to me that some future extension will include carrying new features introduced in OOXML (ISO/IEC IS 29500) in RTF via XML-format inserts. That provision is already defined for RTF. The latest versions of the specification are quite comprehensive and are freely
RE: [libreoffice-users] Re: Calc: cell protection + cut paste
It is not trivial to add finer control on how protection of cells deals with formula-changing cut-paste and other move/insert/delete operations involving cells that protected formulas depend on. For starters, there needs to be a way to communicate the enhanced conditions on protected cells via the ODF format. There is no such provision at the moment. It is possible to handle this with configuration parameters carried in ODF. Unfortunately, that is intensely implementation-specific and frowned upon for something this deep into interpretation of the format. Either way, there remains the problem of having this work in interchange among enough other products that the feature is safe to rely on outside of a situation where all users can be required to use the same software. Interoperability with use of Excel is often a significant factor for many users, especially once Excel supports OpenFormula in its handling of .ods files (something expected eventually although I have no idea when). It might be worthwhile to review what the flavors of protection are in .xlsx and in Excel 2010. There might be an avenue there to something that could be done compatibly in ODF, digging into ISO OOXML for how it is done at the format level. I'm curious to know if the finer-grain options that are available there are helpful in your use case. Can you take a look? - Dennis PS: There is still a problem with the protection lock passwords not being portably-supported between Office formats and ODF formats, although there are ways to make that work better. Presently, the protection is simply turned off when transferring in either direction between formats. -Original Message- From: miakoiv [mailto:miak...@mbnet.fi] Sent: Friday, April 13, 2012 13:36 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Calc: cell protection + cut paste -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Thursday, April 12, 2012 11:15 To: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste I spoke too soon. Absolute references don't solve this problem, because even those are updated when moves happen, such as the cut and paste in the demonstration example. There actually needs to be a way to block cutting and other operations that relocate cells if formulas are to be protected from movement of their operands. It looks like a bigger issue might be whether it is possible to prevent editing operations (cut especially but also row-column insertions and deletions) in a sheet with protections turned on. All while still allowing data entry into unprotected cells. Yes, absolute references don't solve it. And I really do agree that there should be a way to control how these editing operations affect protected cells. One of the core fuctions of a speadsheet program (in my opinion) in that somebody skills can make a calculation sheet and other people can use it to fill needed data and do the calculations and get the needed data. In excel you build your own UI to enter data and with VB you can do a lot of things. But in my opinion that's just overkill for most of the cases. Somebody said that it's an expected (and maybe even wanted?) behaviour, but I just can't understand it. I wish I could do the coding needed, but unfortunately I'm not skilled enough. I think that with a small improvement LibreOffice could be a lot better tool without too complicated things (like Excels UI + VB) I hope somebody, who could do something about this, finds this interesting and needed. :) Mikko -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Calc: cell protection + cut paste
Although that is surprising behavior, it is what happens when a cell used by a formula is moved by cut and paste. The formula can't be edited, but it is still responsive to relocation of cells it depends on. It is a little surprising in the case of a protected-formula cell. The way to deal with it in a protected sheet is to use absolute references in the protected formula. (Unfortunately, disallowing selection of unprotected cells prevents too much.) It looks like a bigger issue might be whether it is possible to prevent editing operations (cut especially but also row-column insertions and deletions) in a sheet with protections turned on. All while still allowing data entry into unprotected cells. - Dennis PS: I just tried this in Excel 2010. The same thing happens to the C1 formula but pasting the cut of A1 into A2 causes the C2 formula to show a #REF! error. But if I cut the two-cell selection of A1:A2 and paste it into A2 (so A2:A3 get the result), there's no complaint and both the C1 and C2 formulas have their references to column A adjusted. (Excel 2010 offers an incredible number of controls on what can be done with the protected sheet though, including control of what can be selected.) -Original Message- From: MiguelAngel [mailto:mari...@miguelangel.mobi] Sent: Thursday, April 12, 2012 09:01 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Calc: cell protection + cut paste El 12/04/12 6:28, miakoiv escribió: miakoiv wrote (11-04-12 20:32) If a protected cell reads data from non protected cell and the user decides to cut + paste the information, the orginal formula in the protected cell will be modified. I don't get this. When data, that is used in a formula is changed, removed, the result of the formula will change, not the formula. Example: A1: 1 B1: 2 C1: =A1+B1 (result: 3) A2: 2 B2: 1 C2: =A2+B2 (result: 3) Now you protect cells C1 and C2. Now this is an important spreadsheet to customer and their employees fill the data to cells A1, A2, B1, B2. And it's of course important that the calculations are correct. Now the customer enters data to A1 which was supposed to go to A2. He/She cuts the data from A1 and pastes the data to cell A2. This is the result: (he/she wanted to enter 1 to A2, but entered it to A1 and then cut + pasted it to A2. Then he/she entered number 2 to A1) A1: 2 B1: 2 C1: =A2+B1 (result: 3) A2: 1 B2: 1 C2: =A2+B2 (result: 2) So the formula in C1 is now A2+B1 which is different than A1+B1 so it changed. And since the cell is protected, you can't change it back to correct one unless you cut + paste again. But if the formulas are also hidden, then it's totally impossible to fix it anymore. I've heard some comments like This is expected and wanted behaviour in all spreadsheet applications., but then I would like to ask what's the point of protection when you can't protect the formulas from even the simpliest user errors? I know that this happens in Excel too, but there you are able to prevent user from using cut+paste (and if googled, you'll notice that people use this quite much just for this reeason). If this is a wanted behaviour, it should atleast give a warning to the user. Are you sure you want to cut + paste data? It will modify protected formulas and you won't be able to fix those anymore and you will get wrong results afterwards? So are you sure? :-) Miakoiv -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3904507.html Sent from the Users mailing list archive at Nabble.com. A workaround is INDIRECT() function to avoid the cut/paste: C1: =INDIRECT(A2)+INDIRECT(B1) This need edit C1 to change the reference to cells, because as you can see the references are texts and don't change with cut/paste A2 and B1. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Calc: cell protection + cut paste
I spoke too soon. Absolute references don't solve this problem, because even those are updated when moves happen, such as the cut and paste in the demonstration example. There actually needs to be a way to block cutting and other operations that relocate cells if formulas are to be protected from movement of their operands. -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Thursday, April 12, 2012 11:15 To: 'users@global.libreoffice.org' Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste Although that is surprising behavior, it is what happens when a cell used by a formula is moved by cut and paste. The formula can't be edited, but it is still responsive to relocation of cells it depends on. It is a little surprising in the case of a protected-formula cell. The way to deal with it in a protected sheet is to use absolute references in the protected formula. (Unfortunately, disallowing selection of unprotected cells prevents too much.) It looks like a bigger issue might be whether it is possible to prevent editing operations (cut especially but also row-column insertions and deletions) in a sheet with protections turned on. All while still allowing data entry into unprotected cells. - Dennis PS: I just tried this in Excel 2010. The same thing happens to the C1 formula but pasting the cut of A1 into A2 causes the C2 formula to show a #REF! error. But if I cut the two-cell selection of A1:A2 and paste it into A2 (so A2:A3 get the result), there's no complaint and both the C1 and C2 formulas have their references to column A adjusted. (Excel 2010 offers an incredible number of controls on what can be done with the protected sheet though, including control of what can be selected.) -Original Message- From: MiguelAngel [mailto:mari...@miguelangel.mobi] Sent: Thursday, April 12, 2012 09:01 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Calc: cell protection + cut paste El 12/04/12 6:28, miakoiv escribió: miakoiv wrote (11-04-12 20:32) If a protected cell reads data from non protected cell and the user decides to cut + paste the information, the orginal formula in the protected cell will be modified. I don't get this. When data, that is used in a formula is changed, removed, the result of the formula will change, not the formula. Example: A1: 1 B1: 2 C1: =A1+B1 (result: 3) A2: 2 B2: 1 C2: =A2+B2 (result: 3) Now you protect cells C1 and C2. Now this is an important spreadsheet to customer and their employees fill the data to cells A1, A2, B1, B2. And it's of course important that the calculations are correct. Now the customer enters data to A1 which was supposed to go to A2. He/She cuts the data from A1 and pastes the data to cell A2. This is the result: (he/she wanted to enter 1 to A2, but entered it to A1 and then cut + pasted it to A2. Then he/she entered number 2 to A1) A1: 2 B1: 2 C1: =A2+B1 (result: 3) A2: 1 B2: 1 C2: =A2+B2 (result: 2) So the formula in C1 is now A2+B1 which is different than A1+B1 so it changed. And since the cell is protected, you can't change it back to correct one unless you cut + paste again. But if the formulas are also hidden, then it's totally impossible to fix it anymore. I've heard some comments like This is expected and wanted behaviour in all spreadsheet applications., but then I would like to ask what's the point of protection when you can't protect the formulas from even the simpliest user errors? I know that this happens in Excel too, but there you are able to prevent user from using cut+paste (and if googled, you'll notice that people use this quite much just for this reeason). If this is a wanted behaviour, it should atleast give a warning to the user. Are you sure you want to cut + paste data? It will modify protected formulas and you won't be able to fix those anymore and you will get wrong results afterwards? So are you sure? :-) Miakoiv -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3904507.html Sent from the Users mailing list archive at Nabble.com. A workaround is INDIRECT() function to avoid the cut/paste: C1: =INDIRECT(A2)+INDIRECT(B1) This need edit C1 to change the reference to cells, because as you can see the references are texts and don't change with cut/paste A2 and B1. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how
RE: [libreoffice-users] CVE-2012-0337
This was a common vulnerability in software having lineage from OpenOffice 3.x, where it was introduced as part of support for features that are new in ODF 1.2. I have provided an unofficial, personal analysis on the ooo-users list. See http://mail-archives.apache.org/mod_mbox/incubator-ooo-users/201203.mbox/%3c008c01cd08af$dd22b230$97681690$@acm.org%3e. (I considered posting that here, but wasn't sure if it would be seen as appropriate.) - Dennis -Original Message- From: Nino Novak [mailto:nn.l...@kflog.org] Sent: Friday, March 23, 2012 06:29 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] CVE-2012-0337 Hi Dan, On Friday 23 March 2012, 08:53:54 Dan Lewis wrote: On Fri, 2012-03-23 at 08:10 -0400, drew jensen wrote: On Fri, 2012-03-23 at 07:55 -0400, Dan Lewis wrote: ... [vague security announcements] What security issues? I'm not sure I know from what I read. I tend to share your wish for a clearer information here. Another thing that comes from trying to find this information: What is a link that I can use to list my concerns or other comments about the layout of the LO website? As the project is self organized I'd suggest to raise your concerns in the website[1] list. There's also a more formal procedure to file an issue in bugzilla[2] (component WWW) HTH Nino [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Default Encryption Fails for Down-Level Implementations
Here is a message that I have just sent to ooo-dev about the silent switching to AES256 being an interoperability problem. The recommendation is to stay with the only cross ODF 1.0/1.1/1.2-conforming encryption of Save with Password by default, while accepting the newer optional ones (including AES256) on input. The patch and bug report for LibreOffice 3.5.x is here: https://bugs.freedesktop.org/show_bug.cgi?id=47484. If anyone thinks a license statement is needed from me to change two defaults from sal_False to sal_True I will be happy to provide it. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Friday, March 23, 2012 13:24 To: 'ooo-...@incubator.apache.org' Subject: RE: [RELEASE,CODE]: Bug 119090 - Default Encryption Fails for Down-Level Implementations [ ... ] The current builds of OOo-dev 3.4 (from Oracle) and all Apache OpenOffice 3.4 developer previews install with Save with Password pre-wired to encrypt using AES256-cbc and SHA256, and SHA256-1k digests, in conflict with the Blowfish CFB and SHA1, SHA1/1K digests that are all that down-level versions of OpenOffice-lineage and ODF 1.1 consumers can decrypt*d4e2h2* , including Lotus Symphony, Libre Office prior to 3.5.x, and OpenOffice.or 3.3.0 (and earlier). There is no dialog that notifies users that the encryption cannot be decrypted with earlier versions. Changing the behavior requires knowing how to manipulate configuration settings. There is no UI or Tools | Options dialog for this. Fortunately, whichever default is used for Save with Password, both forms of encryption are accepted when opening a document. THE PROPOSAL: Change the default so that the ODF 1.0/1.1/1.2-compatible and conformant encryption is used (Blowfish CFB and SHA1 for digests). Users who want to produce documents using AE256, despite the loss of interoperability with all consumers but those who can accept AE256 -- LO 3.5.x, OO.o-dev 3.4, and AOO 3.4+ -- can still change their configuration files to alter the default behavior on ODF 1.2 Save with Password. THE PATCH: There is a simple two-line patch to reverse the default behavior when there is no over-ride in the user configuration. This is provided with r119090: https://issues.apache.org/ooo/show_bug.cgi?id=119090. This patch needs to be approved and accepted. (As a committer, I could have actually applied it. I didn't want that done without review first, so this is an RTC submission.) THE BENEFIT: Non-expert users will not be surprised by the misleading failure of their password to work when using a machine with an older version of OO-line software. (The error message suggests that the file is damaged, not that the encryption is not understood.) In addition, files that are encrypted using AES will also be decryptable by these new releases without the user having to figure anything out. THE DEBATE: There is extensive technical discussion on the Bugzilla comments. Here is a summary of what all of that technicality is about: 1. Some presume that switching to AES256 increases the security of the document. 2. The counter-argument is that it does no good to improve the security in parts of the encryption that do not improve the security of the weakest-link in the encryption technique. It will simply give a false sense of security where there is no improvement. The weak link in ODF 1.0/1.1/1.2 encryption is the way that passwords are used. Not in the encryption technique that is used for the document. All of the extensive technical material is about explaining how it is that (2) is the case and that doing (1) simply inconveniences users and raises technical and reputation issues. - Dennis PS: An equivalent patch has also been contributed to LibreOffice for remedying the fact that the change to AES has been instituted in LO 3.5.x .) [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
The Wonderful Wizard of Oz (was RE: [libreoffice-users] Documentation URL)
This is probably not a good place to discuss the copyright status of an existing work. It seems to me that the only matters to address here are the technical question concerning how to get chapters starting with the text pages lined up as the OP wants. I am surprised that it requires a Master Document to accomplish, though. - Dennis MORE THAN YOU MIGHT CARE TO KNOW: The Wonderful Wizard of Oz was copyright in 1899 by L. Frank Baum and W. W. Denslow (the illustrator). It was published in 1900. The original is no longer under US copyright (that is, it has entered the public domain). You can still purchase the book. I did that recently, in fact. I first downloaded a free Kindle version, but it didn't have the illustrations. There are versions of the book that have content still in copyright. This includes versions that have newer illustrations and also books that have added content about the history of the book, etc. For example, the book I purchased recently has the an Afterword that is copyright 1987. While that notice at the front of the book is accompanied by boilerplate claiming No part of this book may be used or reproduced in any manner whatsoever ... it can't apply to content that is not subject to the 1987 copyright. (It happens that the scene I was looking for, and the dialog that goes with it, ... ignore the man behind the curtain, is specific to the motion picture, so I didn't find what I was looking for.) There is no way of knowing, without further information, what the copyright status of the bilingual plaintext is, what the rules are in the jurisdiction where that was produced/is-used, and whether or not the illustrations being added are subject to someone's copyright. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Saturday, March 17, 2012 06:52 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Documentation URL Hi :) At a guess The Wizard of Oz is copyrighted by some fairly hefty people that wouldn't like to see copies of the story floating around unless they got paid for each copy! I'm not even sure they would accept a single private use copy. So, i think this list has to officially assume that you were just using that name as an example to give us a rough idea of the sort of size project you are dealing with ;) Many of us are far more familiar with copyleft agreements that aim to help people share and spread ideas and knowledge rather than to try to contain and cage it to prevent people from learning things. Regards from Tom :) --- On Sat, 17/3/12, Dan Lewis elderdanle...@gmail.com wrote: From: Dan Lewis elderdanle...@gmail.com Subject: [libreoffice-users] Documentation URL To: users@global.libreoffice.org Date: Saturday, 17 March, 2012, 13:16 On Sat, 2012-03-17 at 18:41 +0700, John Francis Lee wrote: Hi, I've found a bilingual plain text copy of Wizard of Oz and have set up the individual chapters, right page/left page with chapter headings. I found the illustrations as well and will print them separately in color and just insert them as right pages. But how do I put all the individual chapters together to make the book? All the chapters begin with a right hand page. I thought I could just insert each chapter, add a blank left page if need be... although I thought LibreOffice might be smart enough to put a left page betwen two right pages... until I was finished. If I insert the files into a new file LibreOffice gets stupid and tries to use the style settings from Chapter 1 for the whole book... it looks like. I tried inserting the chapters as so-called sections, but LibreOffice got stupid again and used its own idea of style to format the thing. Any help appreciated. -- This message may have been intercepted and read by U.S. government agencies including the FBI, CIA, and NSA and/or the present government of Thailand without notice or warrant or knowledge of sender or recipient. John Francis Lee 246/3 Thanon Kaew Wai Mueang Chiangrai 57000 Thailand What you need to do is use Master Documents. The Writer Guide contains a chapter on this topic. Link to this guide below: http://wiki.documentfoundation.org/Documentation/Publications. (FYI: The Writer Guide was written in chapters which were then combined using Master Documents.) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:
RE: [libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file
For the reported difficulty, replacing CELL(CONTENTS;ref) by =ref is a preferable solution. A bit more about CELL and how it should work, however. The full description for CELL is in section 6.13.3 of the OASIS ODF Standard Version 1.2, Part 2: Recalculated Formula (OpenFormula) Format. This and the other parts of ODF 1.2 can be found at http://docs.oasis-open.org/office/v1.2/os/. Note that there are 13 different information types that can be specified for the referenced cell, including CONTENTS. Also, a CELL(CONTENTS; ref) returns the content but not any formatting. CELL is not required to be supported by any level of conformant OpenDocument Formula Evaluator, however. If it is supported, the reference should work. It might make a difference if the reference is given in complete reference notation. E.g., CELL(CONTENTS;['file:///win-adatok-1/Iskola/OsztalyFonok_vagyok/6.c_osztalyom/NaploBizonyitvanyKitoltesetSegitoTablazatok/6oszt_NaploBizonyitvany_KitoltesetSegitoTablazat.ods'#$'1.'.B6] ) I haven't tested this. - Dennis -Original Message- From: csanyipal [mailto:csanyi...@gmail.com] Sent: Saturday, March 10, 2012 11:16 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file Andreas Säger wrote Am 10.03.2012 19:59, csanyipal wrote: Andreas Säger wrote The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the filename option there is no use for it in Calc. So which function can be used instead of CELL function? =CELL(content;A1) returns the exact same value as =A1 does. Thank you very much for help! - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/CELL-doesn-t-show-the-cell-content-of-another-CALC-file-tp3815399p3815581.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Table Format
Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.) Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both. - Dennis -Original Message- From: Sylvain Bromberber [mailto:sbrom...@mit.edu] Sent: Sunday, March 04, 2012 17:29 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format Hi Drew, Thank you for your long explanatory message, but I seem to miss something essential. Whenever I press the F4 key no matter where I am in Libre Office Base or Writer I get a set of four windows presuming that I have a projector on and giving me options on how to connect to it! I even tried the letter F key followed by the 4 one. No cigar! I don't know what this focused data control is about. I am puzzled but appreciate the trouble you are taking to help me. Sylvain -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 3:33 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sun, 2012-03-04 at 15:18 -0500, Sylvain Bromberber wrote: Thank you, but I meant my computer screen, not a screen on which the table was projected. Howdy Sylvain Right and that is what I was speaking to - albeit, too briefly I suppose. By-default, with a writer document window the F4 key will open the data source window, docked, in the top of the document window frame. This is often referred to as the 'beamer'...a name for whatever reason I just always liked.. OK - if you have a form definition within an ODB file, when that window is open (this is just a special case of a writer document window) and you hit F4 the beamer is displayed - however, as this is now attached to a Base embedded form it behaves differently. The record set linked to from the CURRENTLY FOCUSED DATA CONTROL on the form is displayed in a grid view in the beamer. (important to remember the bit about the focused control, the forum can have multiple record sets open at a time) This is just another live view to the record set, if you can update this record set in the form you can do so in the beamer. If you use filters to limit the result set in the beamer it also limits the records in the form detail control. I assumed that was what you where talking about. Best wishes, //drew -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] separate apps in Windows version
[Replying directly. The list has decided it doesn't like my e-mail address.] Click the Start Button on Windows 7. Click the | All Programs item at the bottom of the Start Menu. Scroll through the folders to LibreOffice 3.4 and click to expand that folder. Right click on the LibreOffice Writer entry. Pick any of Pin to Start Menu and Pin to Taskbar that you desire. You can also use Send To Desktop and make icons. Do the same for LibreOffice Calc. Enjoy ... - Dennis -Original Message- From: Doug [mailto:dmcgarr...@optonline.net] Sent: Sunday, February 19, 2012 15:52 To: users@global.libreoffice.org Subject: [libreoffice-users] separate apps in Windows version Using version 3.4, just installed on Windows 7. Is there any way to separate the apps and make icons for just Writer and Spreadsheet? (They're the only apps from LO I ever use.) It's a pain to have to open the whole thing and then select one. --doug -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Word incompatibilities with changes and comments
This behavior would only be possible if for some reason the Save from LibreOffice was leaving the change-tracking information in the document as if it had not been saved after the changes were accepted/rejected, etc. If the changes have been accepted, there is no reason for them to appear in the document taken to Microsoft Word. (LO and the ODF document format do not have a way to retain the unapproved form of approved changes in saved documents.) When you open the document that Microsoft Office still sees change-tracking in directly in LibreOffice, does LO also still see the change-tracking (once it is made visible if previously made not visible)? Finally, since I am a wannabe change-tracking wonk, can you make a small LibreOffice demonstration document that you believe change tracking has been removed from by accepting and rejecting the changes as desired, so there are no tracked changes left? Save it as ODT first, not just DOC or DOCX. Then save it as the form taken to Microsoft Word. I will be happy to examine the situation more closely with you. - Denis -Original Message- From: Rogier F. van Vlissingen [mailto:vlisc...@gmail.com] Sent: Sunday, February 19, 2012 18:25 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Word incompatibilities with changes and comments So quite apparently, the problem is in MSW2007, where it opens the files to the last version prior to the changes, and you then have to deliberately display the final version, and the only way to get a clean version in MSW2007 is apparently to accept the changes there. I've now tried it a few times, but MSW2007 stubbornly keeps opening up docs in which all changes were accepted in LibreOffice (and I just went to 3.5), to display showing markup, which you then have to either switch off, or accept all the changes in order to display a clean version in MSW2007. In a collaboration like I'm having it means that in practice I must accept the changes twice, once in LO, and then once again in MSW2007, before I hand it off to colleagues using MSW2007 On Sun, Feb 19, 2012 at 7:56 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 19:33 19/02/2012 -0500, Rogier F. van Vlissingen wrote: During a book project where some are using LibreOffice and some are using MSWord, we're noticing that if corrections are processed in Libre office 3.4.4 and the file looks totally clean, when you open it up in Word, they are still there, and you end up having to delete them a second time. What settings are you using for tracking changes? If you have Edit | Changes | Record ticked in LibreOffice, you will be preserving the original along with the changes. If you have Edit | Changes | Show unticked, you will see just the edited version and not the hidden originals (so your document will look clean). When you open a document that includes tracked changes in Word, the original items will be there along with the changes. What you see will depend on your Review setting in Word. In particular, if you have this set to Original, you will not see any of the changes. o If you don't want to track changes, untick Edit | Changes | Record in LibreOffice. o If you want to track changes but then want to see in Word what you have done, change the Review setting in Word. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Rogier F. van Vlissingen, NY (917) 549 0959 www.acimnthomas.com www.securitybitbybit.com www.dabxdemandsidesolutions.com http://www.dabxenergymanagement.com Making Green Power financially rewarding ** Independent Representative ** *sign up for power here www.napower.com/124436* *sign up for American wind here www.napower.com/132240/renewable-http://www.napower.com/132240/renewable-wind **wind http://www.napower.com/132240/renewable/wind* * * And grow some glutathione while you're at it: http://vliscony.max4u.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
RE: [libreoffice-users] No longer able to open a ODB file
The two uploads to DropBox, Books.odb are the same. The document fails to load because it has been truncated -- it is not all there. The beginning of the Zip is present, but the end is not there. That is why it doesn't open as an ODF document and as a Zip document either. (The .odb is a Zip file carrying an ODF Database document.) Scrolling through the document in a hex editor, the following parts are present: mimetype forms/Obj21/meta.xml forms/Obj21/settings.xml forms/Obj21/content.xml forms/Obj21/manifest.rdf forms/Obj21/Configurations2/images/Bitmaps (empty) [... more empty Configuration cruft (this is all an ODT document that is embedded in the ODB to provide the form] forms/Obj21/styles.xml forms/Obj31/meta.xml forms/Obj31/settings.xml forms/Obj31/content.xml forms/Obj31/manifest.rdf forms/Obj31/Configurations2/ ... the usual forms/Obj31/styles.xml database/data There are no Zip records after the database/data header and there is no global directory at the end. - Dennis -Original Message- From: Scott D Friedemann [mailto:sc...@friedemann.us] Sent: Thursday, January 26, 2012 11:30 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] No longer able to open a ODB file Regina, I've put the file back on the Web and will leave it there for a while. http://db.tt/CN65sXtn On 1/26/12 1:25 PM, Regina Henschel wrote: Hi Scott, Scott D Friedemann schrieb: When I try to open this file: http://db.tt/CN65sXtn I would like to look at it, but cannot get it. Perhaps send it to me directly? Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] No longer able to open a ODB file
The database/data beginning is there, but it is incomplete. I did not examine the header closely to see how much data was lost in the truncation of the file. -Original Message- From: Regina Henschel [mailto:rb.hensc...@t-online.de] Sent: Thursday, January 26, 2012 12:44 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] No longer able to open a ODB file Hi Scott, Scott D Friedemann schrieb: Regina, I've put the file back on the Web and will leave it there for a while. http://db.tt/CN65sXtn I got a file with 250KB. I have opened it with IZarc, which tried to repair it. I have tried to repair it with Zip Repair and with DiskInternals Zip Repair Tool. In all cases I see the forms but the data folder is empty. Normally the data folder holds the database itself and the queries. I cannot determine, whether the data folder is really empty, but you cannot recover it with this tools. :( Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] hide and protect the cells
Check to see if the Format | Cells ... | Cell Protection | Protected is checked on all of the cells on the sheet. If so, you need to clear them all and set the protection on just the cells you want to be protected. You should also check Format | Styles and Formatting | Cell Styles (All Styles) | Default and see if Cell protection is on for the default cells. Turn it off. Make a new cell style from the default for your red cells that has protection on, if that is how you want it done. If you need it to be conditional, someone else may have ideas about how to do that. I've not worked with conditional styling. - Dennis -Original Message- From: ARIS MUNANDAR [mailto:ari...@gmail.com] Sent: Sunday, January 15, 2012 15:50 To: users@global.libreoffice.org Subject: [libreoffice-users] hide and protect the cells Good Morning global libreoffice user, I have some questions the security of libreoffice Calc 4.3 1. How to hide and protect the red font cells so the others can not edit or change it ? 2. How can the black font cell still be edited or changed by the others ? I have tried to hide and protect the red font cells by Format – Cell. Tools – Protect Documents – Sheet. It runs well but I can not edit or change the black font cells. Please, guys. I really need your helps . Thanks for All -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Encryption algorithms in Libre Office?
Saving a document with password is indeed an encryption. The encryption methods are specified in the ODF Specification for encrypting the parts of the Zip package. (There is no ODF-specified encryption for the single- XML-file form of an ODF document.) The default method, that works for all ODF 1.0/1.1/1.2 documents in packages (e.g., ODT, ODP, and ODS files), is by Password Based Key Derivation (PBKDF2) using HMAC and SHA1 starting with an SHA1 digest of the UTF-8 user-chosen password. The encryption with the derived key is Blowfish with 8-bit Cipher Feedback (8-bit CFB). This is done on each file of the Zip package that carries the parts of the ODF document. (Each part has a different, randomly-derived initialization vector, but the derived key is the same for all of them.) Starting with ODF 1.2, additional encryption methods can be chosen. However, there are interoperability issues if the document is intended to be opened with anything but the computer and software that was used to encrypt it (actually a common use case but not when secure interchange is intended). The fundamental weakness of the current approach is the use of human-entered passwords (which tend to be memorable and easily attackable), some well-known problems with information leakage from Zip files and known-/predictable-plaintext attacks. There is also a vulnerability if the password used is used anywhere else (e.g., for protecting fields in documents) such that its SHA1 digest becomes known or suspected. - Dennis -Original Message- From: Riccardo Bernardini [mailto:framefri...@gmail.com] Sent: Saturday, January 14, 2012 01:18 To: users@global.libreoffice.org Subject: [libreoffice-users] Encryption algorithms in Libre Office? Dear all, I apologize in advance if this is a FAQ, but I was not able to find an answer both in the FAQ page and in the first 4-5 pages of the mail archives (I searched for password and encryption). I know that Libre Office allows you to save a password protected document, but I would like to know some more details about it. For example, is the document actually encrypted or simply Libre Office refuses to open it without the right password? (I expect [and hope] the former). If the former hypothesis is correct, which encryption algorithms are used? Thank you for any help. Riccardo -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Encryption algorithms in Libre Office?
Yes, the Java library is defective in how it handles PBKDF2, making it impossible to match the PBKDF2 key generation that is specified for ODF. (PBKDF2 is defined to work with any binary initial key, but the Java implementation does not provide for that. The ODF use of PBKDF2 requires starting with a binary initial key.) I did not know about Schuermann's analysis. However, this problem was also encountered by the ODF Toolkit project last year. They have worked around this by creating their own implementation of PBKDF2 that works properly with the UTF8 of an entered password. The ODF Toolkit project is just now accomplishing their first Apache ODF Toolkit podling release. I am told the next release is expected to support the ODF digital signature and encryption provisions. - Dennis -Original Message- From: Andreas Säger [mailto:ville...@t-online.de] Sent: Saturday, January 14, 2012 04:08 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Encryption algorithms in Libre Office? http://ringlord.com/dl/Decrypting%20ODF%20Files.pdf -- View this message in context: http://nabble.documentfoundation.org/Encryption-algorithms-in-Libre-Office-tp3658602p3658798.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Encryption algorithms in Libre Office?
The digests and the block ciphers used in ODF encryptions are not alphabetic transpositions. They work at the binary bit level and are difficult to invert, although some digests may leak some modest information. The encryption of textual content is on its compressed binary form, and that by its nature adds some entropy: it is the compressed file that is encrypted. Consequently, the easiest language-based attack is on the password since so many are memorable and may even be pronounceable. Brute-force attacks on passwords with known digests just get better all of the time and that is an indirect hazard if the same password is used for protection of some files and for encryption of others. (All passwords used in setting protection locks should be assumed to be compromised and not used for anything else.) There is structure in the uncompressed ODF plaintexts (e.g., many of the parts in the Zip are XML files with known schemas as well as text content). That structure and other clues can help discern whether a password attack has succeeded, though. There are also a few known plain-texts and predictable plain-text portions that are commonly found compressed the same way in almost all current ODF packages. That provides easier confirmation of a success and possible clues to the presence of attack-worthy material as well. - Dennis -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Saturday, January 14, 2012 14:28 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Encryption algorithms in Libre Office? On 01/14/2012 04:28 PM, Dennis E. Hamilton wrote: [ ... ] The fundamental weakness of the current approach is the use of human-entered passwords (which tend to be memorable and easily attackable), some well-known problems with information leakage from Zip files and known-/predictable-plaintext attacks. There is also a vulnerability if the password used is used anywhere else (e.g., for protecting fields in documents) such that its SHA1 digest becomes known or suspected. One problem in cryptography is that fact that all alphabetic languages and alphabetic transcriptions have definite letter frequency in plain text. For example in English the letter occurs 7% of the time. This was first discovered and used by William Friedman in the 1920's. Also, grammatical construction of a sentence could provide clues for the key. The word 'the' is very common and often before a noun or at the start of sentence. The sentence structure will provide clues because every language has rules about proper word order, etc. This is an often overlooked problem with cryptography, if I know the original language I know the probable letter frequency and can look for grammatical patterns to break the key. This is in addition to any other problems such as weak password/keys, weaknesses in the encryption algorithm, etc. - Dennis -Original Message- From: Riccardo Bernardini [mailto:framefri...@gmail.com] Sent: Saturday, January 14, 2012 01:18 To: users@global.libreoffice.org Subject: [libreoffice-users] Encryption algorithms in Libre Office? Dear all, I apologize in advance if this is a FAQ, but I was not able to find an answer both in the FAQ page and in the first 4-5 pages of the mail archives (I searched for password and encryption). I know that Libre Office allows you to save a password protected document, but I would like to know some more details about it. For example, is the document actually encrypted or simply Libre Office refuses to open it without the right password? (I expect [and hope] the former). If the former hypothesis is correct, which encryption algorithms are used? Thank you for any help. Riccardo -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] What about the standard state of the hybrid pdf format?
A variety of PDF specifications have become established as international standards. The first was for PDF/A (archival purposes) and there have been others since. There are of course open-source versions of PDF and Postscript viewers and creators. The code that produces and reads PDF in LibreOffice is clearly an open implementation. The inclusion of attachments and even having an index of attachments is covered in the ISO PDF Standard. It is this feature that is used for hybrid ODF-PDF documents: http://blogs.adobe.com/insidepdf/2010/11/pdf-file-attachments.html. (You'll notice that making hybrid Microsoft Office - PDF documents is a feature of Adobe Acrobat products.) The agreement for interoperability with ODF attachments in PDF documents and how they are handled automatically is up to the supporters of ODF-PDF hybrid documents. There is nothing that Adobe needs to do. Any ODF-specific protocol is a matter for the ODF-supporting office suites to work out. If someone wanted to work up and publish an agreed profile for this use case, the OASIS ODF Interoperability and Conformance TC could be used for that purpose. It would then be up to ODF Consumers that also produce and consume PDF to line up. This is also something that could be made the subject of ODF Plugfest activity. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Wednesday, January 11, 2012 11:39 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] What about the standard state of the hybrid pdf format? Hi :) Pdf is a proprietary format. There is no Open version and no community. Testing is done on a relatively small number of machines. It would be really great if there were a successfull OpenDocument Format equivalent that gained even as much traction as Odt etc have. Regards from Tom :) --- On Wed, 11/1/12, Carlo Strata carlo.str...@tiscali.it wrote: From: Carlo Strata carlo.str...@tiscali.it Subject: [libreoffice-users] What about the standard state of the hybrid pdf format? To: LibreOffice, users users@global.libreoffice.org Date: Wednesday, 11 January, 2012, 19:12 Hi Everyone, I'm asking about the standardization of *hybrid pdf* format. This is because I think it is a very useful thing, but I don't want to use it too much if it is a weak standard that is pretty near to be changed or abandoned. Is Oasis-Open or ISO or other standard Organization well defining this format? What do you think about? Have a nice evening, Carlo -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Stack Overflow Question: OOo Computer Terms Spell-Checker/Dictonary
Open sourced dictionary file for computing terms http://stackoverflow.com/q/8437358/33810 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Looking for Old Source for LibreOffice (OOo)
It appears that some of these are also to be found, now, at http://archive.apache.org/dist/incubator/ooo/ and access may be a bit more reliable than archive.services.oo.o - Dennis -Original Message- From: NoOp [mailto:gl...@sbcglobal.net] Sent: Tuesday, December 06, 2011 10:56 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Looking for Old Source for LibreOffice (OOo) On 12/06/2011 08:47 AM, Joel Madero wrote: Hi All, I'm hoping someone can link me to a mirror that has old (2.0.0 - Present) source for OOo. I'm trying to track down a bug to see how long it's been around and hopefully to find the source of the bug but as of yet have had a really difficult time finding the old source code. Thanks you http://distribution.openoffice.org/mirrors/archive.html http://archive.services.openoffice.org/pub/openoffice-archive/stable/ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: deleting hard returns
If the regular-expression technique given in later replies works, that's terrific. If not, there is another way to make it happen by digging into the ODT (if that is the document you have). MINING THE ODT It is possible to remove all of the hard line breaks in an ODF text (Writer ODT) document. The main risk is loss of all paragraphing too. If the document is entirely formatted using hard line breaks, paragraphing by insertion of extra line breaks (blank lines) will also be lost. It takes some surgery on the document. 1. Use a Zip utility to open A WORKING COPY of the *.odt file. (Rename it *.odt.zip is one way to make this easy.) 2. Extract a copy of the file named content.xml. 3. In a text editor do a search and delete (replace by nothing) of all text:line-break/ strings in the content.xml file. (It is helpful if you have a text editor that is XML friendly and doesn't show the document as if it is all one line of text. But it should work anyhow so long as the text editor can handle a line that long [;). 4. Add the modified context.xml back into the Zip and close the Zip. 5. Rename back to *.odt if needed. 6. Open it in Writer and see if the paragraphs survived. If not, decide how badly you want to go through the document and add paragraph breaks using the ENTER key where the breaks are needed. ALTERNATIVES TO PLAYING IN THE ZIP Another way, still requiring a text editor (not Writer), is to work on a .txt file and bring the corrections back into Writer: If (6) is really ugly, and the document is simple enough, the ODT can be saved as text instead. Use a text editor to replace every consecutive *pair* of line endings with something absurd such as *nl*. Then use the text editor to replace all remaining line endings with a single space each. Then use the editor to replace each remaining *nl* (or what you used) with a line ending. Now bring the .txt file back into Writer and save it as an ODT real fast. There will still need to be cleanup. For example, if any words were hyphenated between lines, those will have to be repaired. Even if the document has images and other decorations that make this difficult, you might want to make a .txt version anyhow, and copy and paste from the cleaned up text back into the better-formatted, more-complete original. Without seeing the original problem document, it is difficult to suggest anything that might be even simpler. - Dennis -Original Message- From: Pedro [mailto:pedl...@gmail.com] Sent: Sunday, November 27, 2011 23:42 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: deleting hard returns If your file contains plain text you can easily fix that with an advanced text editor like Notepad2-mod. However if the text is formatted it requires some LibreOffice function that I'm not aware of but would be interested to learn :) Anyone? -- View this message in context: http://nabble.documentfoundation.org/deleting-hard-returns-tp3541244p3541556.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] RE: My Pilcrow is gone. (Non printing Characters)
Are you talking about an ACTUAL PHYSICAL inclusion of the ¶ that you want to see in printed copy and on the display? Or are you talking about an option in your software (View | Non-printing characters) that SHOWS where the paragraphing is by displaying pilcrows. These are not actually in your text but are being presented by the software on your display to show you the details that you asked to see (there really isn't any non-printing character there either, but that doesn't matter). This setting is not (necessarily) conveyed in your document, so if you look at the document in another installation of the software, you have to turn on their display in the new place. They still won't print though, unless you've found a separate File | Printer Settings ... | Options for that. Is this helpful in your case? - Dennis -Original Message- From: Bob Houston [mailto:bob_hous...@hotmail.com] Sent: Saturday, November 26, 2011 12:02 To: Users Global.libreoffice.org Subject: RE: [libreoffice-users] RE: My Pilcrow is gone. (Non printing Characters) Tom,Thanks for the input.And also to MJK. I took a quick look at the link supplied by MJK. But have not had time to read to much other than that the Pilcrow disappearance may be a bug. If in fact it is a bug, what is the procedure to let the software types at LibreO.o know about it? I'd rather not re-install LibreOffice on both of my systems from scratch and have it happen again while I'm in the middle of working on something. It's very hard doing what I do without being able to see the hidden characters. Thanks again. Bob Bob Houston eBook Formattinghttp://about.me/BobHouston http://facebook.com/eBookFormatting Date: Sat, 26 Nov 2011 11:28:47 -0800 From: tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Subject: [libreoffice-users] RE: My Pilcrow is gone. (Non printing Characters) Hi :) I had no idea what a pilcrow was ... http://en.wikipedia.org/wiki/Pilcrow Now i know hat that back-to-front invisible P thing is called too. With regards to reinstalling this guide might help http://wiki.documentfoundation.org/UserProfile Other OpenSource programs such as Firefox, Gimp, Vlc and the rest tend to follow the same strategy. (thanks Hagar) Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/My-Pilcrow-is-gone-Non-printing-Characters-tp3538414p3538593.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: MS font exploit
Take heart: I just received an update and install notice for two patches concerning TrueType fonts on my Windows XP SP3 Tablet PC. I don't know whether there are more coming. I don't see anything for Vista or Windows 7 yet. Stay tuned. If you are running Windows XP, it might be a good time to check for updates. - Dennis Tom, The security issue is not about a virus or the ways a virus is spread. It is certainly about the prospect of a machine being compromised and used as part of a zombie army or whatever. The compromise could also be used to compromise security on the machine that is successfully attacked. I wouldn't say that LO is safe. Any application that allows selection of TTF fonts and that uses Windows to render fonts on the display and for printing might be vulnerable -- all of the attack routes have not been disclosed. But as someone else commented, the vulnerability is in Windows. Also, the malicious fonts need to be installed or accessed somehow. The embedded case that had a workaround is presumably but one of the attack entries. - Dennis -Original Message- From: Tom [mailto:tomdavie...@yahoo.co.uk] Sent: Saturday, November 05, 2011 11:20 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: MS font exploit Hi :) That seems to list all the supported versions/distros of Windows but doesn't included unsupported ones such as Win98. Does that mean Win98 is safe or just that they don't bother to look to see if it's vulnerable? Tbh my interest suddenly dropped away when i found that LO is safe even if we read a doc file in it and creating doc files is still safe too in LO. I'm a little worried about the works machines especially after the work i have put in these last 2 weeks but if they suffer because of using MS Office then it might encourage them to move to LO and that would be fine by me. The problem would be if the machines got infected right after me working on updating everything and installing weird stuff such as LO. If LO prevents the machine itself getting infected that is one good thing but if it inadvertently passes infections on then the wrong people, ie LO users, might start getting the blame for something that is not their/our fault. Of course they/we would also be passing it on if we were using MS Office but at least we would have had more warning about it as our machines got infected. Hmmm, this whole lack of security in MS products really creates a lot of weird blame issues. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/MS-font-exploit-tp3481492p3483006.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: MS font exploit
Not so fast there Sparky (to Dennis). Those two updates are apparently for 2010 patches to the EOT code. I get repeated requests to install them, over and over again. I don't know if it was my running the Fixit workaround or not, but I have blocked the two updates from installing any longer. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Sunday, November 06, 2011 16:55 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Re: MS font exploit Hi :) Thanks Dennis. :) I know i am pretty safe at home. A targeted attack could probably compromise me fairly easily but i am pretty safe from drive-by and casual attacks. Reinstalling an OS is no big deal either. The main place i worry about uses mostly Xp machines and tomorrow is a good day for me to get access to all but 2 of the machines. Regards from Tom :) --- On Sun, 6/11/11, Dennis E. Hamilton dennis.hamil...@acm.org wrote: From: Dennis E. Hamilton dennis.hamil...@acm.org Subject: RE: [libreoffice-users] Re: MS font exploit To: users@global.libreoffice.org Date: Sunday, 6 November, 2011, 23:45 Take heart: I just received an update and install notice for two patches concerning TrueType fonts on my Windows XP SP3 Tablet PC. I don't know whether there are more coming. I don't see anything for Vista or Windows 7 yet. Stay tuned. If you are running Windows XP, it might be a good time to check for updates. - Dennis Tom, The security issue is not about a virus or the ways a virus is spread. It is certainly about the prospect of a machine being compromised and used as part of a zombie army or whatever. The compromise could also be used to compromise security on the machine that is successfully attacked. I wouldn't say that LO is safe. Any application that allows selection of TTF fonts and that uses Windows to render fonts on the display and for printing might be vulnerable -- all of the attack routes have not been disclosed. But as someone else commented, the vulnerability is in Windows. Also, the malicious fonts need to be installed or accessed somehow. The embedded case that had a workaround is presumably but one of the attack entries. - Dennis -Original Message- From: Tom [mailto:tomdavie...@yahoo.co.uk] Sent: Saturday, November 05, 2011 11:20 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: MS font exploit Hi :) That seems to list all the supported versions/distros of Windows but doesn't included unsupported ones such as Win98. Does that mean Win98 is safe or just that they don't bother to look to see if it's vulnerable? Tbh my interest suddenly dropped away when i found that LO is safe even if we read a doc file in it and creating doc files is still safe too in LO. I'm a little worried about the works machines especially after the work i have put in these last 2 weeks but if they suffer because of using MS Office then it might encourage them to move to LO and that would be fine by me. The problem would be if the machines got infected right after me working on updating everything and installing weird stuff such as LO. If LO prevents the machine itself getting infected that is one good thing but if it inadvertently passes infections on then the wrong people, ie LO users, might start getting the blame for something that is not their/our fault. Of course they/we would also be passing it on if we were using MS Office but at least we would have had more warning about it as our machines got infected. Hmmm, this whole lack of security in MS products really creates a lot of weird blame issues. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/MS-font-exploit-tp3481492p3483006.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages
RE: [libreoffice-users] LO 3.4.3 Writer cannot handle RTF document
Using the RTF as provided in Robert's e-mail, Wordpad displays everything through the Total amount due row and that is the end. The additional RTF after that row is has no effect. In Microsoft Word 2010, the document displays completely, all the way down to the Registered in England line with VAT number placeholder at the bottom of the page. Libre Office 3.3.2 also opens the RTF document perfectly, except that one line at the bottom of the page rolls off onto a separate sheet. The layout is not quite so faithful as the Word 2010 appears to be. I saved the Word version as an ODF Text (.odt) document and it is all there. I had to delete two rows of blank lines to get the bottom matter back onto the single sheet (perhaps because of default paper-size differences on my US configuration). I can make the ODT available to Robert if that satisfies his short-term requirement. It doesn't explain why WordPad 6.1 SP1 stumbles. PS: Wordpad also opens the ODT just fine. There is a warning about not all features being preserved. The only obvious difference is that the table in the middle of the page now has visible borders and cell separators. I also notice some places where there is no space between words. The line justification and centerings seem to be perfect. -Original Message- From: Jay Lozier [mailto:jsloz...@gmail.com] Sent: Sunday, November 06, 2011 17:18 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] LO 3.4.3 Writer cannot handle RTF document Robert, On 11/06/2011 05:32 PM, prino wrote: System: Windows XP SP3 (+everything after it) LO: LibreOffice 3.4.3 OOO340m1 (Build:302) Recently my PC died (and with it the freebie version of Word 2002 (10.2627.2625)) and I having never had any problems with XLS files and LO Calc, I expected LO Writer to have little trouble with he following very simple Word .RTF document. How wrong can one be... I would appreciate it if someone could have a look at to why this document doesn't display the way it should be displayed. Can you open the file in WordPad? I am wondering if the file itself is corrupted. The rtf format normally is well behaved and opens properly in a variety of programs. === CUT === [ ... ] === CUT === Robert -- View this message in context: http://nabble.documentfoundation.org/LO-3-4-3-Writer-cannot-handle-RTF-document-tp3485447p3485447.html Sent from the Users mailing list archive at Nabble.com. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] MS font exploit
There are two microsoft.com pages that relate to this situation. The problem is that the exploit happens against the kernel (in GDI, etc.) so there is not much to do about it in any applications. The knowledge-base KB article is the most helpful in terms of mitigation. Any application that handles its own TrueType font handling by other than the Windows call that accomplish font handling and rendering need to look to see if they have any vulnerability in their parser. This also applies to any non-Windows support for TrueType fonts that run on the same architectures as Windows. There's not enough public information to know what to look for. I expect that there is cross-platform cooperation at the security-team levels on this one. Meanwhile, the only remedy at the moment is to apply the workarounds that apply to Windows. Here is what I can discern from the sketchy information: 1. The exploit requires a specially-crafted TrueType Font package. 2. The vulnerability is exploited when such a font is parsed as part of rendering of any presentation using the Windows internal support TrueType fonts. 3. There is a fix available at the knowledge base article. It *appears* in my non-expert reading to prevent use of the intrinsic support for embedded fonts, since this a potentially-appealing avenue of attack via specially-crafted documents. Fixes to close that door, and to reopen it later, are available at the KB article. I suspect that the workaround has no impact on LO and OO.o operability, although I guess the thing to do is turn on the workaround and see for sure. I'm going to do that as soon as I do some system backups first. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Bob Williams [mailto:li...@barrowhillfarm.org.uk] Sent: Saturday, November 05, 2011 10:25 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] MS font exploit On 04/11/11 22:54, Tom Davies wrote: Hi :( Bad news from MS again. http://technet.microsoft.com/en-us/security/advisory/2639658 http://support.microsoft.com/kb/2639658 http://www.symantec.com/connect/w32-duqu_status-updates_installer-zero-day-exploit I'm not sure what they mean by Unfortunately, no robust workarounds exist at this time other than following best practices, such as avoiding documents from unknown parties and utilizing alternative software.. Alternative to what? Is it just MS Office or would this affect LO too (since it goes through fonts?)? The common sense methods for avoiding it have limited use as we have to sometimes read documents from sources we are not completely confident about. It's ok for a few days. Regards from Tom :) APPLIES TO Windows 7 Service Pack 1, when used with: Windows 7 Enterprise Windows 7 Professional Windows 7 Ultimate Windows 7 Home Premium Windows 7 Home Basic Windows 7 Enterprise Windows 7 Professional Windows 7 Ultimate Windows 7 Home Premium Windows 7 Home Basic Windows Server 2008 R2 Service Pack 1, when used with: Windows Server 2008 R2 Standard Windows Server 2008 R2 Enterprise Windows Server 2008 R2 Datacenter Windows Server 2008 R2 Standard Windows Server 2008 R2 Enterprise Windows Server 2008 R2 Datacenter Windows Server 2008 Service Pack 2, when used with: Windows Server 2008 for Itanium-Based Systems Windows Server 2008 Datacenter Windows Server 2008 Enterprise Windows Server 2008 Standard Windows Web Server 2008 Windows Vista Service Pack 2, when used with: Windows Vista Business Windows Vista Enterprise Windows Vista Home Basic Windows Vista Home Premium Windows Vista Starter Windows Vista Ultimate Windows Vista Enterprise 64-bit Edition Windows Vista Home Basic 64-bit Edition Windows Vista Home Premium 64-bit Edition Windows Vista Ultimate 64-bit Edition Windows Vista Business 64-bit Edition Microsoft Windows Server 2003 Service Pack 2, when used with: Microsoft Windows Server 2003, Standard Edition (32-bit x86) Microsoft Windows Server 2003, Enterprise Edition (32-bit x86) Microsoft Windows Server 2003, Datacenter Edition (32-bit x86) Microsoft Windows Server 2003, Web Edition Microsoft Windows Server 2003, Datacenter x64 Edition Microsoft Windows Server 2003, Enterprise x64 Edition Microsoft Windows Server 2003, Standard x64 Edition Microsoft Windows XP Professional x64 Edition Microsoft Windows Server 2003, Datacenter Edition for Itanium-Based Systems Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems Microsoft Windows XP Service
RE: [libreoffice-users] The guts of ODF files
Short Answer: DOCX files are not in ODF format. Longer Answer: 1. There is such information in the ODF 1.2 Specification Parts 1 and 3. However, it will not help with correctly recognizing a DOCX file in LO or OOo. There is a separate International Standard on the OOXML format used by DOCX and how Zip is used as part of that. 2. (Note, some DOCX files are encrypted OOXML documents, and that is actually a different format described in a different specification, even though the file will still have the .docx extension ending its name.) 3. There is some indication that mobile applications are not necessarily producing the DOCX that LO/OOo is expecting. It may be non-standard. Whatever it is, MS Office is forgiving about it. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: ESChamp [mailto:esch...@gmail.com] Sent: Wednesday, November 02, 2011 09:45 To: Libre Office Subject: [libreoffice-users] The guts of ODF files Is there a reference somewhere that specifies what has to be in an ODF file to be recognized as one of the ODF types? I'm asking because I have a DOCX file created by an app on my phone that opens in MS Office, but is not recognized by LO. Thanks. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Document formating
Um, Tom, are you comparing with the LO Writer Save As ... list? And Office 2010 has a portable app. You can make one even with the Starter Edition. It is called Office Click-To-Run 2010. Fits on a Flash Drive. Takes a while to setup though, and it stays operational as long as the flash drive is kept in a USB port. Probably not as nifty as Portable LO in terms of ease of use. It's useful to know about though. Screen shots are a great idea. Many more are needed for all manner of scenarios. - Dennis PS: The Golden Orb is gone in Office 2010. There is a File menu item/tab. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Wednesday, November 02, 2011 10:47 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Document formating Hi :) Yes, but people that religiously stick to MS Office and have the most recent upgrade often have troubles doing File - Save As ... or Golden Orb - Save As ... It leads to t many choices even if they manage to find it. I had to send a screenshot once to help them find their way. Also people often feel you are deliberating being difficult = well worth avoiding if possible. On the other hand some really like it when people show a bit of initiative and love to see interesting alternative gizmos. LO as a portable app could raise an eyebrow. http://www.libreoffice.org/download/portable/ Regards from Tom :) [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Document formating
I have Microsoft Office 2010 on a new machine, so no characteristics were inherited from older versions. I have the Ribbon running, and I don't see the orb anywhere. I also use Quick Access thingies for what I regularly use and can never remember where to find. I can't find anything about the Orb or any way to turn it on. Everything seems to have a File tab to the far left now. Outlook, Excel, Word, PowerPoint, even OneNote. I don't know where you ever saw it in 2010. Sorry. - Dennis -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Wednesday, November 02, 2011 12:58 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Document formating Hi :) I think you can configure whether you have the orb or without the ribbon at all or a strange inbetween. I haven't really paid to much attention to 2010 tbh. I just found it easier to find things i was looking for and escape back to LO/OOo quickly. Regards from Tom :) --- On Wed, 2/11/11, Dennis E. Hamilton dennis.hamil...@acm.org wrote: From: Dennis E. Hamilton dennis.hamil...@acm.org Subject: RE: [libreoffice-users] Document formating To: users@global.libreoffice.org Date: Wednesday, 2 November, 2011, 19:01 Um, Tom, are you comparing with the LO Writer Save As ... list? And Office 2010 has a portable app. You can make one even with the Starter Edition. It is called Office Click-To-Run 2010. Fits on a Flash Drive. Takes a while to setup though, and it stays operational as long as the flash drive is kept in a USB port. Probably not as nifty as Portable LO in terms of ease of use. It's useful to know about though. Screen shots are a great idea. Many more are needed for all manner of scenarios. - Dennis PS: The Golden Orb is gone in Office 2010. There is a File menu item/tab. -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Wednesday, November 02, 2011 10:47 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Document formating Hi :) Yes, but people that religiously stick to MS Office and have the most recent upgrade often have troubles doing File - Save As ... or Golden Orb - Save As ... It leads to t many choices even if they manage to find it. I had to send a screenshot once to help them find their way. Also people often feel you are deliberating being difficult = well worth avoiding if possible. On the other hand some really like it when people show a bit of initiative and love to see interesting alternative gizmos. LO as a portable app could raise an eyebrow. http://www.libreoffice.org/download/portable/ Regards from Tom :) [ ... ] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] The guts of ODF files
Hi Pete, The Zip-related message may be a warning, not a fatality. It also may be related to up-/down-level compatibility among the PKWare Zip specifications. When I use WinZip 9.0 SR-1, there are no problems reported. I haven't checked the files against the PKWare APPNOTE 6.2.0 to see if there is an issue at that level. With regard to IS 29500-1:2008 section 15.2.12.1, I am looking at the specification and it definitely has opendocument/2006/relationships/... in the URL where the files that fail validation have package/2006/relationships/ I checked for recent corrections and amendments. Looking at IS 29500-1:2011 that (well, ECMA-376 ed.3, which is free and already available), there is no change from IS 29500-1:2008. I also went all the way back to ECMA-376 ed.1 of December 2006. There has never been any different definition than what the IS 29500 editions say. I also checked iS 29500-4:2011 on Transitional Migration Features to see if there is a different case for this relationship. What is strange is that 15.2.12.1 is listed as having a difference, but the Source Relationship value given is no different than the value in 29500-1:2011. (There may be a difference and I am blind to it somehow. Time to see the opthomalogist.) The validator message appears to be completely correct but LO does not fail when that is the only flaw. LO accepts the apparently-incorrect .docx from Word 2010. It apparently fails on the Zip itself, not the .rels file inside the Zip. It seems this defect was not noticed and the problem appears to be with Microsoft Office too. Everyone seems to tolerate it. Maybe because I have not found all of the right places, maybe because of a desire to be compatible with what Office actually does. I can't tell. It is clear that the problem for LO is the discrepancy in the Zip though. When that is removed, LO opens the file just fine. Yuck. Thanks for tracking down the apparent discrepancy. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: ESChamp [mailto:esch...@gmail.com] Sent: Wednesday, November 02, 2011 16:51 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] The guts of ODF files Dennis E. Hamilton has written on 11/2/2011 1:01 PM: Short Answer: DOCX files are not in ODF format. Longer Answer: 1. There is such information in the ODF 1.2 Specification Parts 1 and 3. However, it will not help with correctly recognizing a DOCX file in LO or OOo. There is a separate International Standard on the OOXML format used by DOCX and how Zip is used as part of that. Oops! 2. (Note, some DOCX files are encrypted OOXML documents, and that is actually a different format described in a different specification, even though the file will still have the .docx extension ending its name.) 3. There is some indication that mobile applications are not necessarily producing the DOCX that LO/OOo is expecting. It may be non-standard. Whatever it is, MS Office is forgiving about it. I found an on-line validator at http://www.document-interoperability.com/validator When I fed it the original OfficeSuite-created file, it said, Inspecting ZIP ... Mismatch between local header and central record (weakened ZIP resilience) Checking OPC Package ... Entry with MIME type application/vnd.openxmlformats-package.core-properties+xml has unrecognized relationship type http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties; (see ISO/IEC 29500-1:2008, Clause 15.2.12.1) 1 problem found with OPC package The one which resulted when I opened the original in 2010 Office and did a Save As gave this: Checking OPC Package ... Entry with MIME type application/vnd.openxmlformats-package.core-properties+xml has unrecognized relationship type http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties; (see ISO/IEC 29500-1:2008, Clause 15.2.12.1) 1 problem found with OPC package Hmmm...same as the original. The one that was created with Libre Office as a brand new file had the same message as the one created with the Android app -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list
RE: [libreoffice-users] Re: Cannot open DOCX file
I did not see anything that suggested the file from Mobi OfficeSuite was broken. Peter did, and I wonder if that may be related to differences in Zip implementations. I am waiting for more details. The Mobi OfficeSuite .docx file just might be different and still within the tolerances of the OOXML specification (and how Zip is used in that specification). So let us not assume that the root cause of the problem is known or that there is in fact only one defect in one place that contributes to the problem. It is still unknown how it is that LO versions do not recognize the document at all. - Dennis -Original Message- From: Tom [mailto:tomdavie...@yahoo.co.uk] Sent: Sunday, October 30, 2011 04:49 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Cannot open DOCX file Hi :) We seem to have 2 threads with the same issue going on at the moment. Dennis Hamilton's answer in the other thread gives a good idea of what is going on http://nabble.documentfoundation.org/DOCX-file-from-Android-Office-Suite-will-not-open-td3462159.html#a3464176 MobiSystems OfficeSuite Pro produces broken DocX files which MS Office is then able to read. So bug-reports need to be sent to Android or whoever is maintaining MobiSystems OfficeSuite Pro to let them know it's broken. It would be nice to post a bug-report in LO too to help LO open files that are broken in that particular way. Note that Google are one of our supporters so they might be quite keen to help with the issue and fix it quite quickly. All fungames right? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Cannot-open-DOCX-file-tp3461674p3465501.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] LO Conflicts with OOo
It makes perfect sense that OOo and LO could be installed side by side and also run at the same time. The problem is that they all lay claim to the same program names, library names, and probably registry settings. (The use of the same program names is why Windows, for example, can't have Open With ... for both LO, and OOo on the association of programs with file extensions, such as .odt and .ods. (But one can add Open With ... Microsoft Word, WinZip, etc. Different versions of the same product are harder for Windows to distinguish with Open With ..., absent some creative work on the part of the producers of those product versions.) Now that there are different lineages progressing from a common OO.o 3.2-or-so base, there needs to be a way to avoid collisions with parallel efforts and the common past versions. For users, all of their choices should work. Running a portable version should work. Having user accounts with different versions should work, etc. I suspect that these cases have simply not been dealt with systematically, although clearly there has been some attention to it. And if it is by design to not all concurrent operation, I would expect gentle handling when an user violates that constraint. (I have no recommendation on what installs are on top of what previous versions of the same product. It may be a little too course-grained that any LO 3.y will replace any LO 3.x where x y, although that is a second-order problem. It is good that LO 3.y does not replace OOo 3.x, and vice versa.) - Dennis -Original Message- From: Stephan Zietsman [mailto:szi...@gmail.com] Sent: Thursday, October 27, 2011 05:44 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] LO Conflicts with OOo Harold Fuchs wrote: [ ... ] I may be mistaken but as far as I know, LO and OOo are not expected to run at the same time (so I don't think it is a bug). But if they are both installed on the same computer, they should both work (though not at the same time). Same would apply to the portable version(s). Why should I not be able to run LO and OOo at the same time on the same machine? Anyone care to comment? Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] DOCX file from Android Office Suite will not open
Hi Pete, When LO/OOo pops up a text filter it is usually because the format of the incoming file is not recognizable, no matter how it happens to be named (.docx, etc.). This happens if an incoming .docx file is encrypted, for example. If you send the file to me, I can look at its innards to see why it isn't being recognized properly. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Pete Holsberg [mailto:pj...@pobox.com] Sent: Friday, October 28, 2011 09:53 To: users@global.libreoffice.org Subject: [libreoffice-users] DOCX file from Android Office Suite will not open Hi, I created a file with the Android app Office Suite Pro and I cannot open it with Libre Writer. It pops up a filter menu with types of files in randow order (can I file a bug report or a fix request on that?) and none of them are Windows Office 2010 docx file. FWIW, the first 10 bytes of the file are the same as other docx files that LO is able to open. Any ideas (other than asking on an Office Suite mailing list)? Thanks. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Calc: Converting Formula to Value
Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back. That will leave the values and strip the formulas from the cells [;). It might work to save as .xslx and then reopen it in LO too, but I haven't tried that case. -Original Message- From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org] Sent: Friday, October 28, 2011 16:26 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Calc: Converting Formula to Value Hi, Am 29.10.2011 01:14, schrieb Rich Shepard: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] DOCX file from Android Office Suite will not open
First, rough-screening test results: The newtext.docx file that was produced with the Mobi Office Suite works as follows: LO 3.3.2 fails to open it, reporting a general input-output error. Word 2010 opens it just fine. I modified the document in Word 2010 by adding a sentence to it and saving that as a new file. LO 3.3.2 opens the modified document just fine. Inspection of Zip structure of the two documents reveals that the version saved by Word 2010 has two more files, a docProps/app.xml file and a word/StylesWithEffects.xml file. There is no obvious difference at this high level to indicate how the document failed to be recognized as an OOXML WordDocumentML document by LO. It is also possible that the difference is in the Zip encoding in some way in which Word 2010 is forgiving and LO is not. The failure to recognize what the document is appears to happen at a very immediate level in LO access to the file. More detailed examination is required. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, October 29, 2011 10:18 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] DOCX file from Android Office Suite will not open Hi Pete, When LO/OOo pops up a text filter it is usually because the format of the incoming file is not recognizable, no matter how it happens to be named (.docx, etc.). This happens if an incoming .docx file is encrypted, for example. If you send the file to me, I can look at its innards to see why it isn't being recognized properly. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Pete Holsberg [mailto:pj...@pobox.com] Sent: Friday, October 28, 2011 09:53 To: users@global.libreoffice.org Subject: [libreoffice-users] DOCX file from Android Office Suite will not open Hi, I created a file with the Android app Office Suite Pro and I cannot open it with Libre Writer. It pops up a filter menu with types of files in randow order (can I file a bug report or a fix request on that?) and none of them are Windows Office 2010 docx file. FWIW, the first 10 bytes of the file are the same as other docx files that LO is able to open. Any ideas (other than asking on an Office Suite mailing list)? Thanks. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] I want to add formulas and functions to calc
There should be care in naming extensions and avoiding collisions with OpenFormula and other extensions (implementation- or user-defined). It might be good to review the specification of OpenFormula in ODF 1.2 for all of the functions defined there. There may be OpenFormula functions of interest that are not yet implemented in LibreOffice Calc and it would, in those cases, be useful to implement them as part of the full set. Also, there needs to be agreement on how extensions not provided for in ODF are identified. I recommend against using org.openoffice simply because there would need to be some sort of joint arrangement to manage that as a shared namespace. Not a bad idea, but absent that it might be useful that one use a unique name prefix for LO-defined extensions (as opposed to user-defined functions). This is all to avoid collision of names among implementations when LibreOffice Calc documents are interchanged with other ODF-supporting spreadsheet implementations. For user-defined extensions, one might want to have a naming policy so those extensions don't collide as well. - Dennis E. Hamilton tools for document interoperability, http://nfoWorks.org/ dennis.hamil...@acm.org gsm: +1-206-779-9430 @orcmid -Original Message- From: Stefan Weigel [mailto:stefan.wei...@bildungskreis.org] Sent: Saturday, October 22, 2011 23:10 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] I want to add formulas and functions to calc Hi, Am 23.10.2011 04:35, schrieb Alberto Sanchez: Is there a way that the community can benefit from this? so my question is, how can I add that function so that many others in my position can benefit from them? Make an Extension and put into the Extensions Repository. http://www.libreoffice.org/features/extensions/ http://extensions-test.libreoffice.org/ If you do not know how to create an extension and if you do not want to learn it (which isn´t difficult), you could post the Code and a description of your new function and hope that some other old man will pick it up and create and publish it as an extension. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
