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 Ka

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

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

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 Barke

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 cel

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 m

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

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 pr

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

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

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: Apparently exporting a report from PPM often

RE: [libreoffice-users] oooforum.org

The Apache OpenOffice project is supporting . The volunteer administrators, moderators and other contributors to the AOO Community Forums have tended to also contribute to oooforum, but it was not affiliated with OpenOffice.org nor is it now affiliated with AOO and

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

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 ve

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 e

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

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 (

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

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

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

om: 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 wrote: > ODF 1.0/1.1 did not specify a

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

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

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 u

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

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

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 extension/replaceme

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

panies 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

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

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:

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

m: 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 resol

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

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

ty (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.

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

n. - 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, Den

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

let alone other useful ones such as Tab. Regards from Tom :) > > From: Dennis E. Hamilton >To: 'Tom Davies' ; 'ubuysa' >; users@global.libreoffice.org >Sent: Friday, 14 December 2012, 16:55 >Subject: Windows 8 Compatibility (was RE: [libreoffice-users] R

Windows 8 Compatibility (was RE: [libreoffice-users] Re: 0xc0000005 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

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

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 cha

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

: 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 wrote: Umm, if two Text (.odt) documents

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...@gmai

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 Thursda

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

e: [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 S

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

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 ch

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 betwe

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 OO

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

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

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 als

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

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.

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

t 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 :) >_______

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 po

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

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

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 ba

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 Prev

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

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 yo

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

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 w

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

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: This message is not about the provision for digit

RE: [libreoffice-users] IMPRODUCT() does not work in Calc

The problem was resolved by a sharp-eyed developer on the ooo-user list. The result of 4 is correct. 2+i2 is 2 (because cell i2 is either empty or 0) 2-i2 is 2 (same reason). (This is because Calc allows simplified direct references to cells.) The result is 4. Try =IMPRODUCT("2+2i";"2-2i");

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

ype file of the package. There should be no ",", ";" or whitespace characters in the content values. - [;<). -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Wednesday, June 06, 2012 08:50 To: users@global.libreoffice.org Subj

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

Hmm, The META-INF/manifest.xml file does require a element that has manifest:full-path="/". It also requires a manifest:media-type attribute whose value matches the string in the package's mimetype. E.g., manifest:media-type="application/vnd.oasis.opendocument.text". In addition, but only f

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

the most-recent version of LO that does *not* treat your document as corrupt. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Tuesday, June 05, 2012 09:47 To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Document 'corrupt

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 elements are deleted from META-INF/manifest.xml. You should probably *not* keep the settings.xml if you are creating a different content.xml f

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

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 star

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 p

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 a

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 '.xlsx' because the file format or file extension is not valid. Verify

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

ter. 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 Vis

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

e: 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 &

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 us

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

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

g 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 wrote: From: Dennis E. Hamilton Subject: RE: [libreoffice-users] Re: rtf import broken in 3.5.1? To: users@global.libreoffice.org Cc: "'

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 . 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: Calc: cell protection + cut & paste

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

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

ected 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

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 wi

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

l 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 [ ... ]

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

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: . The LibreOffice advisory is likely to simply scare the pants

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

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 Maste

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

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 dow

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

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 t

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 t

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

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

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

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)

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

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

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 startin

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

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 LibreOf

[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.documentfo

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

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

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 you

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 wit

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

-- On Sun, 6/11/11, Dennis E. Hamilton wrote: > From: Dennis E. Hamilton > 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 patc

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 t

RE: [libreoffice-users] MS font exploit

d 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

  1   2   3   >