Question on Issue 116295
Hi, There is a known security issue affecting users who use the mail merge wizard in spammer's mode (serial letters as email attachments). The wizard stores the mail account confidentials as clear text in regmod.xcu. > https://bz.apache.org/ooo/show_bug.cgi?id=116295 Could it be that we already have a password protected and hopefully encrypted container for network related passwords? I mean Tools>Options...Security "Passwords for web connections" I have difficulties diffing registrymodifications.xcu so I can not find out by myself. Greetings, Andreas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Calc needs major overhaul
Am 14.02.2016 um 09:17 schrieb knsm...@yahoo.co.jp: > > Please share this email with Calc development team members. > There is an official support forum for this kind of problem: > https://forum.openoffice.org/en/forum/index.php > > Calc used to be a brilliant spreadsheet. > This suggests that anything in Calc that used to work stopped working. In fact, this was never supposed to work. OpenOffice comes with a database. Input forms work with database record sets. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Question
Am 18.01.2016 um 22:45 schrieb Mayela Muniz: > > Can openoffice most recent version save a word document in a .docx format? > Thanks > > - > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org > For additional commands, e-mail: dev-h...@openoffice.apache.org > > No, but the most recent version of MS Office can read Open Document Format (just like dozends of other applications). - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [REPORT] Issue Clearance Quality + Technical Debt
Technical Debt in AOO 4.1.2: 1. The entire Base component does not work on the Mac platform. Not a Java issue, not limited to any type of database. Serial letters and bibliographies are impossible to do on the Mac. On the user forum this issue comes up more than once a week. Going back to AOO 4.1.1 is one solution. Most users prefer LibreOffice in this situation. 2. Spreadsheet functions IFERR and IFNA are part of the ODF formula specification and not yet implemented. This comes up more than once a week because nobody uses IF(ISERROR(foo);bar;foo). Today's users of Excel, LibreOffice and Gnumeric use IFERROR(foo;bar). - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Re: Complaint Writer lost 36 pages of my document with no auto backup copy.
Am 01.01.2016 um 22:39 schrieb Dennis E. Hamilton: > > Meanwhile, I think it would be wonderful if on opening documents there were > *accurate* warnings that the document relies on format features that are not > supported and that will not be presented or preserved properly. (If we > preserved the original as a backup, that would be helpful though, so > something to think about.) I think it would be great if the same were true > on saving a document in a format for which features are not preserved by the > save operation. Not the scare warning, but accurate warnings. Not > necessarily detailed. Then the recommendation to save in ODF first to > ensure preservation would make sense and perhaps the save to the format for > which fidelity is not offered would be treated as an export in that case. > This is what I use to suggest on the user forum when users need to exchange mail attachments with MSO users. I got very positive feedback for this: 1) Open the incoming doc/xls attachment. It might be loaded as a read-only copy residing in a temporary directory. 2) Save as ODF in your home directory and work with that. 3) Finally, menu:File>Send>Document as doc/xls This way you keep the incoming doc/xls in your inbox, the outgoing doc/xls in your outbox and an ODF document to work with. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Re: Complaint Writer lost 36 pages of my document with no auto backup copy.
Am 02.01.2016 um 04:10 schrieb Patricia Shanahan: > > That is not quite the use-case I was thinking of. When collaborating, I > often need to edit a document I did not originate. Commonly, the > document will be in a Microsoft Word format, and has to be distributed > in that format. There is no "original ODT format" document. Since I > usually collaborate with computer people, revision control is important. > > One natural sequence is: > > - Check out DOC format document from revision control. > - Edit and save it. > - Check it in to revision control > - Edit it some more and save it again. > - Check it in to revision control > - Update because someone else has edited and checked it in. > - Edit it still more, and save it again. > - Check it in to revision control > I would either edit my own ODF copies or buy some capable doc(x) editor in the long run. The two ODF suites are not good enough. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Re: Complaint Writer lost 36 pages of my document with no auto backup copy.
Am 31.12.2015 um 19:53 schrieb Patricia Shanahan: > On 12/31/2015 10:30 AM, Max Merbald wrote: >> Hi, >> >> let me say a few words on this too: >> >> I have had the autosave option enabled for ages and I've never >> experienced a problem I'd relate to this. In the contrary, it has helped >> me a few times to retrieve a document I've had a problem with (such as >> losing it for some reason or other. I think users will benefit from the >> autosave being enabled by default. > > I also have autosave enabled, and have not experienced any problems with > it personally. > Both of you work with ODF and export to foreign formats when necessary. Bill M wrote: > The only change I made was to > turn off the question about save in ODF format as I send it to other people > in RTF or Microsoft DOC format. Bill M uses OpenOffice as an editor for foreign file formats which is the anti-feature that deserves to be disabled completely. All documents should be edited in ODF. Always. When you save another version in foreign file format, the current document should remain the ODF source. Foreign files should be loaded read-only and saved as ODF before editing. Another misconception is that too many users believe that the "backup" feature of their office suite ensures a reasonable level of data safety. In fact they never run any backup utility at all. The term "backup" should be avoided alltogether in favour of "crash recovery". Can we really assure that our crash recovery tool works with all supported file formats including the foreign ones? - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [Forum] Vietnamese forum to be closed?
+1 Am 31.12.2015 um 21:23 schrieb Dennis E. Hamilton: > +1 > >> -Original Message- >> From: Marcus [mailto:marcus.m...@wtnet.de] >> Sent: Thursday, December 31, 2015 11:09 >> To: dev@openoffice.apache.org >> Subject: Re: [Forum] Vietnamese forum to be closed? >> - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Calc Selections of Entire Rows and Columns
Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton: > The TL;DR: For full row and column selections in formulas, the trick is to > arrange to accept something like A:A and to recognize the explicit OO.o idiom > (i.e., A$1:A$1048576) and show it as A:A. The trick is to always write, in > the OpenFormula, A$1:A$1048576, regardless of the form it was read/input, and > always display as A:A in the presented formula. That is, always write the > idiom but recognize both it and the general form (and all variations of > course) as the general form. > There is a difference between A:A and A$1:A$1048576 in Excel and Gnumeric: When you delete rows, A:A remains A:A whereas A$1:A$1048576 shrinks. Any reference to the last cell A$1048576 moves up but any A:A reference remains the same regardless how many and how often you delete cells. In the age of spreadsheet databases this may be a problem when you count on this behaviour. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Possible Mac problem 4.1.2
Am 06.11.2015 um 10:19 schrieb Jürgen Schmidt: > No further tests ... I normally don't use the db in OpenOffice > > Juergen Millions of users use it for mail merge, label print etc. from connected spreadsheets. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Apache Open Office
Am 04.11.2015 um 22:28 schrieb dzymum .: > Does Apache Open Office work with a MAC? I am trying to help my > granddaughter with her Chemistry and need an office doc program that will > work with her pc and my MAC. > Thanks > Dee > > http://www.openoffice.org/download/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [QUESTION] Usability of Non-Optional Java Dependencies
Am 03.11.2015 um 01:23 schrieb Patricia Shanahan: > I have no idea of the frequency of that situation. > Hi, On the user forum it occurs several times per month. The list box of availlable JREs should not include 64-bit JREs. It should have a label such as "Suitable 32-bit Java Runtimes on this system:" plus an additional [Help] button, tool-tip and everything that helps to resolve the situation without asking someone else for help. As far as I know, help contents are partially platform specific anyway. I don't know if possible, but there should be a one-click hyperlink to a 32-bit JRE. The official Oracle link to a manual download goes as far as > http://www.java.com/de/download/manual.jsp Oh, and I suppose it should (and could) be an ordinary list box without any radio buttons. This is a localized version (/de/ German) of the manual download page where the user needs to know that the second link [Windows Offline] http://javadl.sun.com/webapps/download/AutoDL?BundleId=111687 is the one to download but NOT [Windows Online] and NOT [Windows Offline 64-bit]. Of course, the BundleID changes with every Java update. And yes, this is Java8 and it works well although AOO specifies Java7. IMHO, a hyperlink on a help page leading to the English http://www.java.com/en/download/manual.jsp together with a localized hint to download and install the 32-bit JRE labeled "Windows Offline" could improve the situtation. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Java 32
Am 11.12.2014 um 09:49 schrieb Andrea Pescetti: Marcus wrote: Of course I can change it in the code with a commit. However, I'm not able to create a build to check myself to see if my fix is good or produces an ugly build breaker. I'm not yet so far to build AOO from scratch myself. I wanted to try this for the quite days at this years end. Any tips? My suggestion (can be executed as a team, not necessarily by one person): 1. Find a proper wording for http://www.openoffice.org/download/common/java.html More detailed info is needed to overthrow the common prejudice that OpenOffice relies heavily on Java which is not even true for the Base component. A Java runtime environment (JRE) is required to use the following functionality: *Wizards*, namely: menu:FileWizardLetter... menu:FileWizardFax... menu:FileWizardAgenda... menu:FileWizardWeb Page... *Macros* JavaScript and BeanShell macros require Java The dialog menu:ToolsMacrosRun... can't be used. Without Java you can still use menu:ToolsMacrosOrganize... to run Python and Basic macros. https://issues.apache.org/ooo/show_bug.cgi?id=86541 *Extensions* Extensions coded in Java Finding keywords in the F1 help depends on Java. *Database access* All Base wizards are coded in Java. The embedded HSQLDB and any other JDBC connetion requires Java. Contrary to the current text stating that Base depends entirely on Java, most of the Base component is functional without Java. You can query and mail merge any kind of non-Java database and you can create fully functional input forms manually without the questionable help of the form wizard. You can even create a new database without Java. This results in a (less functionable) dBase directory. *Required JRE* when needing any of the above features: Any recent version of Java 7 or 8 Windwos: 32 bit JRE in any case since OpenOffice for Windows is a 32 bit application Mac: 64 bit JRE for all recent versions of OpenOffice since all recent versions for the Mac are 64 bit versions. Linux: 32 or 64 bit JRE according to the bitness of OpenOffice which should be the same as the system bitness. 2. Create a link www.openoffice.org/java pointing at it 3. Find a short (short!) text for the dialog box, sending the people to www.openoffice.org/java for any details (including 32 and 64-bit systems); I don't know if links are supported, but the short URL at 2 should take care of it This would be very easy if the dialog box would not show inadequate JREs. If it would list only the JREs with correct bitness, the list of JREs could have a slightly modified label with a 32 or 64 bit prefix like this: 32|64 bit Java runtime environments (JRE) already installed: I strongly suggest to fix the list content first. Showing the right label text with wrong options does not help much. 4. Place #3 in form of a patch in Bugzilla and send the number here (and if the patch comes from someone who is not one of the usual code committers, even better) 5. At that point it will be easy for people who have their own build tree to check the patch before we get it in, so don't worry about this. Regards, Andrea. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: oooforum
Am 05.12.2014 um 01:15 schrieb Andrew Douglas Pitonyak: I did a scrape of the pages, and it is about 8GB last time I did it. Off hand, I expect that a huge chunk of that is SPAM, especially since most of the SPAMS have large graphics included. I considered writing a PERL script to clean that based on certain search criteria, but, it just feels like a huge annoyance to spend hours removing posts and then trolling the rest of the files to rearrange all of the links so that things continue to function. So, I did not start the clean-up process from my scrape. Hi, Last time when I was browsing oooforum.org, there was a distinct day when the moderators gave up. Every posting since that day is spam or an unanswered question. Everything before that day was more or less well moderated. Sorry, I don't recall which day it was but it is easy to find when you search postings of active members. Hope this helps. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Fwd: Can open Open office add?
Am 29.10.2014 um 03:36 schrieb F C. Costero: Forwarding in case Darren isn't subscribed. And I see now that my reference below to 30 years should have been somewhat less, but still many years. That's what I get for reading only the title of a message. Francis Hi, It's 35 years since the first release of Visicalc which followed the same calculation rules as todays spreadsheet application. http://www.danbricklin.com/history/refcard1.htm Text values are documented as Labels and were not subject to arithmetic operations. You could enter numeric labels with a preceeding double-quote. Today this is a single quote. According to http://www.excelfunctions.net/Excel-Sum-Function.html text representations of numbers within ranges are ignored by Excel's SUM function. As Rob already pointed out, Excel does some fatal mistakes when it comes to implicit string to number conversions in other contexts. The same Excel document loaded into the same version of MS Excel may yields different results on both sides of the Atlantic Ocean because different language versions of Excel convert the same text values differently. If you enter/paste/import numeric text values into your Calc document, Calc behaves correctly and consistently. You may convert these values if they are wrong (no, formatting doesn't change any values) and you can explicitly convert these values by means of the VALUE function. But you can not SUM up any text. Cheers to all the pesky trolls kidding the dev mailing list with childish rants about non-issues, Andreas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)
Am 24.10.2014 um 09:59 schrieb Jürgen Schmidt: On 24/10/14 07:54, Jörg Schmidt wrote: Hello, For example: http://www.heise.de/newsticker/meldung/Berliner-Finanzaemter-wechseln-zurueck-auf-Microsoft-Office-2430961.html I believe a decision like the one in Berlin is always political motivated. See for example the upcoming discussion about the same topic in Munich after changes in the administration. Juergen Hi, The article on heise.de says it all. They exchange data through office documents; and they don't want to fall behind ... whatever bleeding edge [contradiction in itself]. Oh, of course they need MS Office for security reasons ... WTF? A full featured OOXML suite exists. It costs some money and it should always be used when OOXML is required. Your business opportunities are the same as with ODF. Today virtually everybody writes filters and parsers for OOXML but not for ODF. If ODF were a lost case, both ODF suites would be lost anyway. Writing another full featured OOXML suite would be a hopeless undertaking because it is too much to implement differently in no time. Anything less than full featured would not be accepted, OOXML Strict neiter. Everything needs to be fully compatible and interoperable with MS products which implies tight integration into MS operation system and separation from other OSes. Even if such a product existed, Berlin authorities would still insist in MS products because Berlin is one of the most sleazy places in Germany. They don't care about money because political life in Berlin is a pony farm indeed. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Access to the list of Autofilter
Am 25.10.2014 um 01:06 schrieb Vladislav Stevanovic: Hello, Is it possible with code in Basic to access to the list of Autofilter data in Calc? Reason: filtering with basic is limited maximum with 3 criteria... Because I need more then 3 criteria I want with basic code to use filtering capability of Autofilter. Thanks in advance, Wlada This is the mailing list of the developers (not macro coders). Register on the support forum: https://forum.openoffice.org/en/forum/ucp.php?mode=register Filter criteria are limited to 8 criteria. No macros can not access the auto-filter list. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Improved OOXML support?
Am 23.10.2014 um 06:47 schrieb Jörg Schmidt: I think it's good that we live in a free society and customers have the right to see things differently. Being a customer, I do see things differently. Every OOXML file is a vote against ODF. One day in future LO will save ODF as a secondary option. Finally MS wins because LO can not support the same feature set as MSO does or because MS comes up with the next shit. Jörg - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Improved OOXML support?
Am 22.10.2014 um 07:03 schrieb Jörg Schmidt: I find it really strange that it seems impossible to find companies that are willing to integrate corresponding filter in AOO, as a normal commercial support. If I were in need of an OOXML suite, I would pay for the real one. The other one is LibreOffice. Nobody needs a third one. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: .mdb file
Am 10.06.2014 18:20, Kenneth Scotland wrote: I have one .mdb file, created some years ago using M/S Access. It is a personal file concerning my collections. However, with acquiring new a computer, I somehow lost access to Access. I still have the file, and can read it.but cannot add items. Do you have a program which would help me? [Tutorial] MS Access and OOo Base https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=25300 Hope this helps. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [DISCUSS] possible blog topic -- AOO and Linux: a marriage made in heaven! :)
Am 19.04.2014 01:53, Kay Schenk wrote: Ok, maybe the subject is bit melodramatic but after some of the twisted things we read about, basically how non-supportive either AOO is of Linux, or Linux is non-supportive of AOO, here's what I'm thinking. Hi, 2 reasons why someone like me may want stick with LibreOffice on Linux: Show stopper since OOo 3.2, fixed in LO 3.4: https://issues.apache.org/ooo/show_bug.cgi?id=121312 (Linux/JDBC/Base Extension destroying all Calc charts on Linux: https://issues.apache.org/ooo/show_bug.cgi?id=124470 (Report Builder Greetings, Andreas Säger - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org