RE: [libreoffice-users] Benford's Law

2013-07-14 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Benford's Law

2013-07-14 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] AOO for Android - not worth the download

2013-06-22 Thread Dennis E. Hamilton
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.

RE: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-12 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] ”Artifacts” in OpenOffice and LibreOffice

2013-05-11 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: File associations for MSO to LibreOffice -- Win8

2013-04-03 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] File associations for MSO to LibreOffice -- Win8

2013-04-01 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] calc problem

2013-03-25 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Put LibreOffice as unedited document viewer only

2013-03-13 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Exported XLS doesn't opens in Calc

2013-03-05 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year?

2013-02-19 Thread Dennis E. Hamilton
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

[libreoffice-users] RE: [tdf-discuss] How did AOO figure it was worth $21 Million dollars a day or $7 billion per year?

2013-02-19 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] MS Excel file macros cause infinite loop of errors

2013-02-11 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Re: LibreOffice 4.0

2013-02-05 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: LibreOffice 4.0

2013-02-05 Thread Dennis E. Hamilton
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;

[libreoffice-users] Navigation in Documents

2013-02-03 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Development of Extensions for LibreOffice

2013-02-03 Thread Dennis E. Hamilton
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:

RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-24 Thread Dennis E. Hamilton
-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

RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-23 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files

2012-12-29 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] RE: Libreoffice 3.5.1 corrupted eas256 password protected ODF ver 1.0/1.1 files

2012-12-29 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Libre Office listed in petition to promote the use of free software in our schools

2012-12-28 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] record changes weakness compared to m$

2012-12-19 Thread Dennis E. Hamilton
I trust there's no surprise that the OASIS Standard ODF documents are developed and maintained as ODF documents. Tracked changes are critical to the work of the ODF TC and the review processes that the work goes through. There is a subcommittee of the OASIS ODF TC working on

[libreoffice-users] RE: Windows 8 Compatibility - More Info

2012-12-17 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] RE: Windows 8 Compatibility - More Info

2012-12-17 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] RE: 0xc0000005 error in RPCRT4.dll from soffice.bin)

2012-12-16 Thread Dennis E. Hamilton
...@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

[libreoffice-users] RE: 0xc0000005 error in RPCRT4.dll from soffice.bin)

2012-12-15 Thread Dennis E. Hamilton
[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-

RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)

2012-12-14 Thread Dennis E. Hamilton
:) 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

RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)

2012-12-14 Thread Dennis E. Hamilton
-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

RE: Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 error in RPCRT4.dll from soffice.bin)

2012-12-14 Thread Dennis E. Hamilton
: [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

RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?

2012-12-11 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?

2012-12-10 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: [3.5.3.2/Writer] Split screen in half horizontally?

2012-12-10 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Calc formula for US Thanksgiving date

2012-12-03 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice

2012-11-28 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: [libreoffice-marketing] Good Article for LibreOffice

2012-11-28 Thread Dennis E. Hamilton
: [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

RE: [libreoffice-users] Can I lock a row so it doesn't move when scrolling?

2012-11-23 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-20 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-20 Thread Dennis E. Hamilton
- 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

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-16 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-16 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-16 Thread Dennis E. Hamilton
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.

RE: [libreoffice-users] Re: how to crack a PW in LO?

2012-10-16 Thread Dennis E. Hamilton
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.

RE: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-06 Thread Dennis E. Hamilton
[From the great minds think alike department] Microsoft SkyDrive accepts and presents, via the Office Web Applications, ODF documents. (These applications support a nice variety of features but not all features of the full Microsoft Office applications are supported, and there are warnings

RE: [libreoffice-users] compatibility / Symphony

2012-08-28 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

2012-07-24 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?

2012-07-24 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

2012-07-23 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: CALC - How to count blank cells?

2012-07-04 Thread Dennis E. Hamilton
@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

RE: [libreoffice-users] Re: stubborn macro security

2012-06-30 Thread Dennis E. Hamilton
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.

RE: [libreoffice-users] Signing Documents with a personal Certificate

2012-06-21 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software

2012-06-05 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Document 'corrupt' for LibreOffice, opens fine with other OOo-based software

2012-06-04 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-04 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?

2012-06-04 Thread Dennis E. Hamilton
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

Microsoft .TLA and .TLAx Extensions (was RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?)

2012-06-03 Thread Dennis E. Hamilton
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.

Microsoft .TLA and .TLAx Extensions (was RE: [libreoffice-users] Re: Is 3.5.4 ready for business users?)

2012-06-03 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] File associations - LibreOffice and OpenOffice on Windows 7

2012-05-21 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7

2012-05-21 Thread Dennis E. Hamilton
- 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

RE: [libreoffice-users] Re: File associations - LibreOffice and OpenOffice on Windows 7

2012-05-21 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: DocX

2012-05-13 Thread Dennis E. Hamilton
@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.

RE: [libreoffice-users] Re: rtf import broken in 3.5.1?

2012-04-27 Thread Dennis E. Hamilton
@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

RE: [libreoffice-users] Re: rtf import broken in 3.5.1?

2012-04-27 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-13 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-12 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Calc: cell protection + cut paste

2012-04-12 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] CVE-2012-0337

2012-03-23 Thread Dennis E. Hamilton
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

Re: CVE-2012-0037 (was RE: [libreoffice-users] CVE-2012-0337)

2012-03-23 Thread Dennis E. Hamilton
By the way, it is CVE-2012-0037, not -0337. Sorry I didn't detect the original subject-line gaff sooner. Note that the official CVE reports are seriously unenlightening: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0037. The LibreOffice advisory is likely to simply scare the pants

[libreoffice-users] Default Encryption Fails for Down-Level Implementations

2012-03-23 Thread Dennis E. Hamilton
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

The Wonderful Wizard of Oz (was RE: [libreoffice-users] Documentation URL)

2012-03-17 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file

2012-03-10 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Table Format

2012-03-04 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Embedded OLE Objects in Write

2012-02-24 Thread Dennis E. Hamilton
1. Are you making sure that the OLE object is embedded and not just linked? Are you also making sure that the option to show a thumbnail instead of the rendering of the OLE object is not selected? 2. Are you using more than one computer for this work?And is the original application

RE: [libreoffice-users] separate apps in Windows version

2012-02-19 Thread Dennis E. Hamilton
[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

RE: [libreoffice-users] Word incompatibilities with changes and comments

2012-02-19 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] No longer able to open a ODB file

2012-01-26 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] No longer able to open a ODB file

2012-01-26 Thread Dennis E. Hamilton
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:

RE: [libreoffice-users] hide and protect the cells

2012-01-15 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Encryption algorithms in Libre Office?

2012-01-14 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: Encryption algorithms in Libre Office?

2012-01-14 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Encryption algorithms in Libre Office?

2012-01-14 Thread Dennis E. Hamilton
@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

RE: [libreoffice-users] What about the standard state of the hybrid pdf format?

2012-01-11 Thread Dennis E. Hamilton
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-users] Stack Overflow Question: OOo Computer Terms Spell-Checker/Dictonary

2011-12-08 Thread Dennis E. Hamilton
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:

RE: [libreoffice-users] Re: Looking for Old Source for LibreOffice (OOo)

2011-12-06 Thread Dennis E. Hamilton
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:

RE: [libreoffice-users] Re: deleting hard returns

2011-11-28 Thread Dennis E. Hamilton
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)

RE: [libreoffice-users] RE: My Pilcrow is gone. (Non printing Characters)

2011-11-26 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: MS font exploit

2011-11-06 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Re: MS font exploit

2011-11-06 Thread Dennis E. Hamilton
:) --- 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

RE: [libreoffice-users] LO 3.4.3 Writer cannot handle RTF document

2011-11-06 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] MS font exploit

2011-11-05 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] The guts of ODF files

2011-11-02 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Document formating

2011-11-02 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] Document formating

2011-11-02 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] The guts of ODF files

2011-11-02 Thread Dennis E. Hamilton
. 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

RE: [libreoffice-users] Re: Cannot open DOCX file

2011-10-30 Thread Dennis E. Hamilton
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

RE: [libreoffice-users] LO Conflicts with OOo

2011-10-29 Thread Dennis E. Hamilton
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

  1   2   3   >