Reputation
265
Top tag
Next privilege 300 Rep.
Create new tags
Badges
1 7
Newest
 Caucus
Impact
~15k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
May
2
awarded  Caucus
Jul
4
comment How does Open Office Calc make this conversion?
Well, Excel and OpenOffice being out-of-step in terms of day-numbers has to do with a deviation concerning whether or not 1900 is treated as a leap year. (Excel maintaining compatibility with Lotus 1-2-3 meant that it also had the leap-year bug.)
Jun
23
revised How compatible is LibreOffice with OpenOffice?
fix typo
Jun
23
comment How compatible is LibreOffice with OpenOffice?
Both Apache OpenOffice and LibreOffice are descendants of the OpenOffice.org and the code base maintained by Sun and Oracle up through OpenOffice.org 3.3 (and the non-released 3.4). There is common lineage and each can be considered a fork from that common root. In licensing to Apache, Oracle transferred the trademarks and web domains as well.
Jun
23
answered How compatible is LibreOffice with OpenOffice?
Jun
10
answered Office tool for editting XML files
Jun
10
answered Why is Openoffice Calc automatically rounding the sum of two sums?
Apr
16
comment Decrypt .docx file to view in OpenOffice.Org
I suspect the first case is more likely, because you don't even get to the point where the password for decryption is requested. Can you have someone encrypt a trivial document with a different password that also exhibits the problem? Then the AOO team can see what's failing.
Apr
16
comment Decrypt .docx file to view in OpenOffice.Org
There are two things to consider. First, the discrepancy may be between Linux and Windows install of Apache OpenOffice 3.4.1. Secondly, if the file was produced by Office 2013 (while unlikely at this point in time), it might not be something that Apache OpenOffice 3.4.1 can open even though Office 2010 can open it.
Apr
15
awarded  Commentator
Apr
15
comment Decrypt .docx file to view in OpenOffice.Org
In Apache OpenOffice 3.4.1, the format to select is "Microsoft Word 2007 XML (.docx, .docm)." That is called Microsoft Word 2007/2010 XML" in LibreOffice 4.0.1 which also supports "Office Open XML Text (*.docx, *.docm). That last is presumably the strict OOXML supported by Office 2013 (and also read by 2010 but not written by Office 2007/2010).
Apr
8
comment Why can I open .docx with OpenOffice but not .odt with Word?
Microsoft OFfice does support ODF. All this prognostication is ignoring that important fact.
Apr
8
answered Why can I open .docx with OpenOffice but not .odt with Word?
Apr
8
awarded  Critic
Apr
8
comment Why can I open .docx with OpenOffice but not .odt with Word?
I am certain there was EUC interest in Microsoft OFfice supporting ODF as well as OOXML. In fact, the SKUs for Microsoft Office in Europe allow setting ODF as the default format. There are no barriers to implementation of OOXML support by third parties, nor are there any limitation on the support of ODF. Microsoft, as a contributor to OASIS ODF 1.2 is also obligated under the OASIS requirements on ODF IP.
Apr
1
awarded  Yearling
Mar
29
comment Decrypt .docx file to view in OpenOffice.Org
Luke, .docx is neither of those. It is OOXML. You should just be able to select it for Opening without specifying its file type and Apache OpenOffice 3.4.1 will immediately ask you for the password. If that doesn't work, let me know. There may need to be a bug against the Linux release. Make sure you download from www.openoffice.org, too.
Mar
28
answered Decrypt .docx file to view in OpenOffice.Org
Feb
12
comment Multiple “If” answers in one cell
I don't understand the use of an IF. If the positions are in column C and you want to put the points in column D, for the fisherman whose information is in row j, the formula is simply =MAX(100-(Dj-1)*10;0). An OpenOffice error508 probably means Dj doesn't have a number in it.
Feb
12
comment Multiple “If” answers in one cell
If you have the ranking of each fisherman in a column through their entries, it is easy to compute the points in an adjacent column. It would also be good to sort them by whatever it is that determines those rankings though. Then you can deal with ties. Are ties not possible? Also, I assume if there are more than 9 rankings, all of the lower finishers after the 9th (without duplicates) get 0, yes? Or is the size of the tournament limited?