Re: Writer suggestion
On 3/31/2013 19:47, Donald Mayse wrote: I recently started a document with 4 columns. I then tried to have no columns on subsequent pages. As far as I can tell, it can't be done without removing the columns from the first page. Can you incorporate some method of easily discontinuing columns in a document? Hi, Donald, Columns are a property of page styles and sections. For what you want, simply assign a different page style to your second page: one with only one column. The Default style will probably suffice. The new style will propagate to the following pages. Questions like yours are better directed to our users' mailing list: us...@openoffice.apache.org or to the forum. HTH, /tj/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: A question about existing practices
On 3/18/2013 11:12, Dennis E. Hamilton wrote: ... - Dennis PS: My all-time favorite unreconcilable voted-for issue is the request for Reveal Codes in the manner of WordPerfect. Hi, Dennis, This is one of my favorites, too, and you might be of great help to my work. I read somewhere that Symphony has an inspection tool which might serve the purpose of Reveal Codes. Can you (or others) confirm or deny such a thing? (I don't want to write a bunch of code that nobody will use.) TIA, /tj/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: A question about existing practices
On 3/21/2013 12:57, Dennis E. Hamilton wrote: I just fired up Lotus Symphony 3.0.1 fixpack2 on an ODT document that I had handy and I could not find anything like an inspection tool. I couldn't find anything beyond a nice navigation tool in the sidebar and the usual show-non-printing/show-fields features. Perhaps I didn't know where to look. Do you know if it is a plug-in or widget? - Dennis PS: Did you get your hands on the plug-in that was an attempt to do something like Reveal Codes? It was done in Australia and not further developed. My research and plans are documented on the wiki[1]. Ian's work went in a slightly different direction than what I contemplate, but it is a very valuable resource. Thanks to your helpful reply, I will proceed (at my glacially slow pace) to do something with Reveal Partitions. [1] http://wiki.openoffice.org/wiki/User:TJFrazier/Reveal_Codes /tj/ -Original Message- From: TJ Frazier [mailto:tjfraz...@cfl.rr.com] Sent: Thursday, March 21, 2013 02:10 To: dev@openoffice.apache.org Subject: Re: A question about existing practices On 3/18/2013 11:12, Dennis E. Hamilton wrote: ... - Dennis PS: My all-time favorite unreconcilable voted-for issue is the request for Reveal Codes in the manner of WordPerfect. Hi, Dennis, This is one of my favorites, too, and you might be of great help to my work. I read somewhere that Symphony has an inspection tool which might serve the purpose of Reveal Codes. Can you (or others) confirm or deny such a thing? (I don't want to write a bunch of code that nobody will use.) TIA, /tj/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [Call-for-Review] code changes for more powerful smarttag extensions
https://issues.apache.org/ooo/show_bug.cgi?id=121911 Feel free to cross-link or add comments. /tj/ On 3/18/2013 03:45, Jürgen Schmidt wrote: On 3/17/13 11:27 PM, TJ Frazier wrote: ... I also noticed that when you zoom a text document the lines for redlining as well as for smarttags, etc. are not zoomed in the same way and makes it less visible. But this seems to be a general issue. Juergen Hi, Jürgen, This is one of my pet peeves. The major problem seems to be the line thickness, which corresponds to the glyph property stroke weight. The un-zoomed skinny line just disappears at high zoom factors. Do you want me to file an issue in BZ on this? Having an issue for this is definitely a good idea. Thanks Juergen /tj/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [Problem with Mwiki] Link to list catagories not working
On 3/6/2013 16:38, Keith N. McKenna wrote: At the bottom of all Create and Edit pages in mwii there is a note to categorize all pages with a link that calls a special page that lists the category tree. It is preset to look at: Category:Manindex Mode: Categories only Namespace: all When called instead of returning the category tree it returns the message Mainindex not found. The page notes that it requires AJAX functionality to work and will not work in old browsers or with JavaScript disabled. I am currently running Firefox 19.0 with JavaScript enabled. This did work before the upgrade and is a good feature to allow people a quick check of Categories available. Regards Keith I can confirm (a) Keith's results, and (b) that Category:MainIndex is alive and well. Something may be wrong with or around the extension that provides the category tree feature. /tj/ - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [blog]: request for review of a draft for a short blog post
On 2/19/2013 08:35, janI wrote: On Feb 19, 2013 2:10 PM, Jürgen Schmidt jogischm...@gmail.com wrote: Hi, many of you have potentially seen that news of MS that a license Office 2013 is bound to one computer. O惰 it is already reverted in Germany and you can get a free activation code after you have called MS. But I think we can post a short note that AOO can used and shared as often people want or as often they need once they have downloaded it. https://blogs.apache.org/preview/OOo/?previewEntry=openoffice_downloaded_once_used_and I also add a not that we are interested in any success stories of bigger deployments and shared experiences. Well it's just an idea and the wording and the image has to be improved, I can need help. Feedback is welcome. +1 Juergen Light copy-editing: -as many other people you like or you install it on as many computer you need. eas many other people _as_ you like or /// install it on as many computer_s as_ you need. +as many other people as you like or install it on as many computers as you need. /tj/
Releasing incompatible changes
Prior to working with AOO, I thought that there was a widely-known and generally accepted methodology for releasing incompatible changes. However, the problem has surfaced here three times: once last spring (encryption default), and twice currently (0⁰, and extensions with toolbars). I want to try to separate the how we release it from the should we do it and the technical details. The two key points of the method I'm used to are (1) long lead time, and (2) parallel operation. Introducing a new way and deprecating an old one are not really disruptive. The disruption comes when support for the old way is dropped, and something doesn't work any more. Hence, new ways and deprecations can be issued at any minor release, and the sooner the better. However, for an organization with so large a following as ours, we need to allow a lead time of an entire major release (though circumstances may vary) before dropping support. As an example, for the extensions change, we should say something like, A new method of handling toolbars [link] is provided in AOO 4.0. The old method is deprecated, and support may be dropped as soon as AOO 5.0. Extension developers should provide two versions, using MAX_VER and MIN_VER ... [Please excuse my ignorance, here.] Ariel is quite correct to point out that this parallelism doesn't come for free: it can involve a messy piece of code to be maintained. However, two points: (a) maintenance in the area should be near zero for the life of the lead time (unless the area is a target for new features), and (b) shouldn't we (developers) be doing the hard work, so our downstream folks have it easier? Providing parallelism for the Calc 0⁰ problem should be easy enough, while deferring our proposed change to 5.0. (I favor the change, but not so suddenly!) HTH, /tj/
Re: Calc behavior: result of 0 ^ 0
On 2/9/2013 18:11, Andrea Pescetti wrote: A good practical example of backwards-incompatible changes in version 4.0 is the behavior of Calc while computing 0 ^ 0. You can find a long issue, with different points of view, about this at: https://issues.apache.org/ooo/show_bug.cgi?id=114430 but in short: - Obviously, 0 ^ 0 is an illegal operation in mathematics and the result is undefined/invalid - In 3.4.1, =0 ^ 0 returns 1 - In 4.0, as patched by Pedro (see issue), =0 ^ 0 would return an error - According to ODF, valid results are 0, 1, error - We gain interoperability since Excel returns an error too - We lose backwards compatibility if someone was relying on the fact that OpenOffice returns 1 as the result of =0 ^ 0 I'm OK with the proposed change, provided we advertise it in the release notes. I'm not aware of any cases where someone is actively using the fact that in Calc 0 ^ 0 evaluates to 1, and even if someone did, I would say that his spreadsheets should not compute 0 ^ 0 at all. A side benefit would be that school students quickly wanting to find out what is the result of 0 ^ 0 would be told the truth (it's an error) instead of being presented with a numeric result and no warnings. (Then the student would go on and write = - 2 ^ 2 and have a lot of fun, but this is out of scope here). Is there consensus that this is a reasonable backwards-incompatible change, or compelling reasons to revert it? Regards, Andrea. If we keep the change (+1 from me), someone more adept than I should write something like a POWER0(a,b) function. This can be substituted easily for POWER, or a ^ b, and returns 0^0=0. If we're sure to break some spreadsheets, let's make a quick fix easy. (I'd bet that in half of the broken cases, someone will say, Aha! That value should never be 0! We've finally found that old bug! In short, we'll be helping some folks.) /tj/
Re: Apache OpenOffice in Fedora 19?
On 1/30/2013 16:54, RGB ES wrote: 2013/1/30 Andrea Pescetti pesce...@apache.org Right on the deadline to propose new features for Fedora 19 (it wasn't planned) I submitted Apache OpenOffice as a proposed new feature: https://fedoraproject.org/**wiki/Features/ApacheOpenOfficehttps://fedoraproject.org/wiki/Features/ApacheOpenOffice You can see this as a first step in getting back into the major Linux distributions. Timing aside, Fedora is a very good choice for a number of reasons. Let's wait and see; Fedora 19 is nicknamed Schroedinger's cat after all. The Fedora 19 release schedule, as an exception to the common Fedora conventions, will not be time-based but feature-based: features accepted by the Fedora Board will be considered before drafting the schedule. Anyway, optimally it would allow to package OpenOffice 4.0 (and there would be work to do on the OpenOffice and the Fedora side to get OpenOffice properly packaged). Regards, Andrea. Good! The proposal was noticed by Phoronix too :) http://www.phoronix.com/scan.php?page=news_itempx=MTI4ODI Regards Ricardo Note that the article says that AOO 4.0 is scheduled for April, 2012. Oops. /tj/
Re: Open Office CD
On 1/21/2013 14:27, jfdi...@wmconnect.com wrote: Hello I live in a area where the only internet I can get is dial up and everytime I try to download Open Office i get kicked offline and have to start all over again so I was wondering if you have Open Office in CD form. Thank you for your time. Joe Dills/HTML Let me heartily recommend what worked for me, when I used to have this problem: Firefox browser, plus the DownThemAll (DTA!) add-on, both free. When my download was interrupted (always at least once), DTA popped up a notification. One click on the stream name activates the DTA controls. A second click on Resume, and away it goes, picking up right where it left off. On a bad day, this might happen several times, but it worked so well that I don't recall ever having to repeat a download. (With a 10 Mb broadband, the time went from 8 hours to 4 /minutes/. Dial-up is a PITA.) HTH, /tj/
Re: [MWIKI]Is wiki bug?
On 1/7/2013 11:18, janI wrote: that sund like the CR/LF problem (unix/windows), the new editor might be more sensitive. I do not think there are anything I can tune on that part, but maybe TJ knows more (I am not the best mwiki user, I just do the server maintenance). Rgds jan I. The wiki software does not always recognize ends of lines where we users might expect it to. If you run into problems, the safe and certain thing to do is to add the HTML command, br /, which AFAIK always works. Otherwise, a blank line (two CRs in a row) usually works, but inserts a blank line, which may be OK. /tj/ On 7 January 2013 16:44, Ji Yan yanji...@gmail.com wrote: My last report is ok[1] wrote at 12/23 but when I update new report today, I found this problem. My question is how to make editor recognize the Enter. If I press Enter in editor, it is OK, but if I copy text from other editor(e.g. notepad), it become one line finally. [1]http://wiki.openoffice.org/wiki/QA/Report/DefectStatus/20121224 On Mon, Jan 7, 2013 at 11:19 PM, janI j...@apache.org wrote: we changed editor with the upgrade, so depending on when you did it last, that could be the explanation. rgds Jan I. On 7 January 2013 15:09, Ji Yan yanji...@gmail.com wrote: Hi all, Did anybody encounter same problem as I did? Copy following lines to a wiki page, but when previewing the change, it only shows one line. =outline1= ==outline2== I remember there is no such problem in last month. -- Thanks Best Regards, Yan Ji -- Thanks Best Regards, Yan Ji
Re: Color coding for Basic snippents on Mwiki?
On 1/5/2013 16:57, janI wrote: There are no conversions in place, so we use the standard as provided. Have you looked at mwiki home page, I am pretty sure they have some explanation. Please also be aware that all our pages are loaded with a standard aoo style sheet, which might further limit the possibilities. I had a quick look, and there are no code conversions though. Rgds Jan I. On 5 January 2013 22:44, Alexandro Colorado j...@oooes.org wrote: Anyone know the attribute for color code Baisc code on the MWiki? example code lang=java will color code for java, but I have tried baisc oobasic and no luck. -- Alexandro Colorado PPMC Apache OpenOffice http://es.openoffice.org source lang=oobas works for me. See links on my user page for examples. /tj/
Re: typing formulae in writer
On 1/4/2013 16:37, Regina Henschel wrote: Hi Theoderik, Theoderik Orbus schrieb: I am visually disable. I just spent about 3/4 of an our on the web site attempting to find an answer to what I think is a simple question. I have not been able to find instructions in OO or on the web site (or anywhere else) on how to write subscripts and superscripts for chemical and mathematical formulae in OO Writer. I have to say the search was exceedingly painful, physically, and accomplished nothing. The only reason I have this e-mail address is it was given to me off line. What I have tried is going to the Insert then Special Characters then Subscripts and superscripts and finding none of the numbers i need to use. I have seen formulae that were imported from other word processors displayed correctly, but i have been unable to compose them correctly in OO Writer. if there is an instruction on how to do this, could you please place it somewhere where it can be found? thank you for your time. Good guides are produced by ODFAuthors. They are currently producing documentation for LibreOffice. But you can use it as well, the differences to Apache OpenOffice are small. You find the free pdf- and odt-versions on http://www.libreoffice.org/get-help/documentation/ Older versions are available from http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_Chapters_ODT You get nice formulas using the formula editor. So in your case the Math Guide 3.5 from libreoffice.org will be appropriate. If you like it shorter, the older chapter Ch9 - Getting Started with Math from openoffice.org might work as well. Adding filetype:odt to your search criteria helps to get more relevant search results. If you have special questions, please ask on us...@openoffice.apache.org or on one of our forums in http://forum.openoffice.org/ Kind regards Regina The OO.o Math Guide for v3.3 is available on the wiki[1]. This is the .odt reference (also available in .pdf) which has the advantage that you read it in Writer, so you can look and see how they did that. A quick guide to the syntax (actually, the appendix to the Math Guide) is also available in wiki format[2]. [1] http://wiki.openoffice.org/w/images/c/c8/0800MG33-MathGuide3.3.odt [2] http://wiki.openoffice.org/wiki/Documentation/Reference/Math_commands /tj/
Re: MWIKI down?
On 1/2/2013 21:07, Andrew Douglas Pitonyak wrote: Trying to create an account for Alexander (as requested) using the user name he sent to me, but mwiki appears to be down... Hi, Andrew, According to http://monitoring.apache.org/status/, the wiki has been down for an hour. (This is a /very/ useful link.) The devices are listed in alphabetical order, by the name at the left; ours is ooo-wiki. According to the Infra page, if something shows red here (as ooo-wiki does), then Infra has already been notified and should be working on the problem, so no further user action is necessary. According to Jan, the system is suffering from kernel panic bouts (???). He plans to upgrade the VM, which may cure the problem. /tj/
Re: Calc user guide Chapter 6 - German translation READY NOW
On 1/1/2013 10:11, Raphael Bircher wrote: Hi It would be interesting to write this also to the German Mailing List users...@openoffice.apache.org Nice to see more german Native language speachers. Greetings Raphael Am 01.01.2013 13:54, schrieb 口 海: Hi Andrea and OOo-Team, happy New Year for the OOo - Project and best wishes ! As I had announced some months ago, I have translated several chapters of the Calc 3.2 - user guide into German. This chapter of the user guide is (to my knowledge) not yet translated into German. PLEASE help me to get it published on the OOo-website - as it would reward the work that went into it !! I am working on several other chapters of the user guide which have so far not yet been translated into German and I would like to receive help these upcoming weeks / months to get them published on the OOo-website etc etc , too. I am available in case further corrections etc etc are necessary. Best wishes Heiko Strauss Hi, Heiko, Raphael, Can we get some feedback from German-speakers that this is a good-quality translation? The mechanics of publication are simple: upload to a file (use the same name as the document), and add a link on the DE version of the wiki Documentation page. I am prepared to do these steps, if nobody objects. AOO policy is that new material shall be under ALv2, but this translation is presumably under some CC license. It seems reasonable to me to make an exception for new material about old software. I will wait at least 72 hours for feedback on either or both points. /tj/
Re: mwiki: HELP DynamicPageList.
A couple of the templates are giving user-error messages. (Are you seeing those in the error logs?) I was going to try to fix or disable those, but the wiki went down ... :/ /tj/ On 1/1/2013 14:37, janI wrote: So if I understand you correctly we need it and cannot just remove it. Then I hope the author will come with a fix, and the moment we get 10-15 error messages pr minute. Jan I. On 1 January 2013 20:29, tj t...@apache.org wrote: On 1/1/2013 12:37, janI wrote: Hi Can anyone tell where DynamicPageList (DPL2) is used in our wiki ? It is flooding our error log, and slowly becomming a security problem. I would like to disable it, but before doing so I would like to know what depends on that extension. thx. in advance. Rgds jan I. The major use of DPL at the moment is in generating ToCs for things like FAQs and HowTos [1]. It saves a lot of work, and errors, compared to manual linking. DPL was used to give most edited or most popular lists on the main page, but those are now on the statistics page[2]. Edit this page to see (at the bottom) some templates that use DPL. For a list of all the uses, see [3]. [1] http://wiki.openoffice.org/**wiki/Documentation/How_Toshttp://wiki.openoffice.org/wiki/Documentation/How_Tos [2] http://wiki.openoffice.org/**wiki/Wiki/statisticshttp://wiki.openoffice.org/wiki/Wiki/statistics [3] http://wiki.openoffice.org/**wiki/Special:WhatLinksHere/** Template:Extension_DPLhttp://wiki.openoffice.org/wiki/Special:WhatLinksHere/Template:Extension_DPL HTH, /tj/
Re: Calc user guide Chapter 6 - German translation READY NOW
On 1/1/2013 16:20, Regina Henschel wrote: Hi Heiko, 口 海 schrieb: Hi Andrea and OOo-Team, happy New Year for the OOo - Project and best wishes ! As I had announced some months ago, I have translated several chapters of the Calc 3.2 - user guide into German. This chapter of the user guide is (to my knowledge) not yet translated into German. PLEASE help me to get it published on the OOo-website - as it would reward the work that went into it !! Yes, we should make your translation available. I think, that the Wiki, where the English versions are already available, will be a proper place. I am working on several other chapters of the user guide which have so far not yet been translated into German and I would like to receive help these upcoming weeks / months to get them published on the OOo-website etc etc , too. I am available in case further corrections etc etc are necessary. The document uses the wrong template. That has the effect, that it has the wrong language and wrong font size. The correct template is in http://www.odfauthors.org/openoffice.org/deutsch/Vorlagen/vorlage-fuer-uebersetzer-und-korrekturleser/view How to handle copyright and license is described in the mentioned template. We should avoid the impression that this translation is authorized by ODFAuthors (former OOoAuthors). If such authorization is wished-for, the document would have to go through their revision cycles. Therefore I think, that at least the OOoAuthors logo and text in the footer on page 2 has to be removed. The document would need a proof reading to look for typos and wrong links. But because it is for the outdated OOo3.2, I think we can take it as it is. For AOO4.x the printing part has to be rewritten, because the printer dialog has changed after OOo3.2. Currently the Wiki does not react, so I cannot look for a proper place. But I know, there exists a page for the English version. If no DE-section exists, I suggest to add a line to that page, saying Translations and in next line Heiko Strauss hat diese Anleitung nach Deutsch übersetzt. with Deutsch as direct link to the document. Perhaps add the full German title. This way it can be found by search in Internet and by search inside the Wiki. Kind regards Regina Hi, Regina, I have found a good place, by following the Deutsch link on the Documentation page. On the English version, the links are a couple of pages away, but the German page is mostly redlinks. An indented link under the Calc 3.2 redlink should work. I expect to use the name of the document (as attached by Heiko) as the link text; this is how the English chapters are listed. Thank you for the reviewing. My German is totally inadequate for that. Do you have any suggestions for how Heiko should handle the next review cycle? Send straight to me (no review)? Send to you? Post it on the wiki, and ask the DE list for review? Generally speaking, docs like this shouldn't be sent to a mailing list. /tj/
Re: mwiki: HELP DynamicPageList.
Hi, Jan, Researching the DPL extensions, I think that all our usage could be done with the old, stable DPL extension, rather than DPL2. AFAIK, the only sizable problem is the DPL tag itself, which would need to be DynamicPageList instead. Isn't that something a bot could do, working off of that 'What links here' list? s/DPL/DynamicPageList/ (case insensitive!) There may be other parameter incompatibilities, but they should be few enough to fix by hand. Worth trying? (If so, please let me know ahead of time, so I can be ready to jump on problems.) /tj/ On 1/1/2013 15:44, janI wrote: Hi. no I see a php error in the DPL2 php files. Yes wiki is down, with kernel panic (I assume) and we (infra) are trying to get hold of someone with the needed karma to physically reboot it. jan. On 1 January 2013 21:26, TJ Frazier tjfraz...@cfl.rr.com wrote: A couple of the templates are giving user-error messages. (Are you seeing those in the error logs?) I was going to try to fix or disable those, but the wiki went down ... :/ /tj/ On 1/1/2013 14:37, janI wrote: So if I understand you correctly we need it and cannot just remove it. Then I hope the author will come with a fix, and the moment we get 10-15 error messages pr minute. Jan I. On 1 January 2013 20:29, tj t...@apache.org wrote: On 1/1/2013 12:37, janI wrote: Hi Can anyone tell where DynamicPageList (DPL2) is used in our wiki ? It is flooding our error log, and slowly becomming a security problem. I would like to disable it, but before doing so I would like to know what depends on that extension. thx. in advance. Rgds jan I. The major use of DPL at the moment is in generating ToCs for things like FAQs and HowTos [1]. It saves a lot of work, and errors, compared to manual linking. DPL was used to give most edited or most popular lists on the main page, but those are now on the statistics page[2]. Edit this page to see (at the bottom) some templates that use DPL. For a list of all the uses, see [3]. [1] http://wiki.openoffice.org/wiki/Documentation/How_Toshttp://wiki.openoffice.org/**wiki/Documentation/How_Tos htt**p://wiki.openoffice.org/wiki/**Documentation/How_Toshttp://wiki.openoffice.org/wiki/Documentation/How_Tos [2] http://wiki.openoffice.org/wiki/Wiki/statisticshttp://wiki.openoffice.org/**wiki/Wiki/statistics http://**wiki.openoffice.org/wiki/Wiki/**statisticshttp://wiki.openoffice.org/wiki/Wiki/statistics [3] http://wiki.openoffice.org/wiki/Special:WhatLinksHere/**http://wiki.openoffice.org/**wiki/Special:WhatLinksHere/** Template:Extension_DPLhttp://**wiki.openoffice.org/wiki/** Special:WhatLinksHere/**Template:Extension_DPLhttp://wiki.openoffice.org/wiki/Special:WhatLinksHere/Template:Extension_DPL HTH, /tj/
Re: Draft: Guidelines for redistributing (an original) Apache OpenOffice with 3rd party bundles (e.g. books or template packages)
On 12/30/2012 06:32, janI wrote: +1, I would add a line saying something: In no case are such distributions allowed without the written consensus of Apache OpenOffice. That will make it easier to pursue a case, if someone just distributes. I would also suggest, we add a link to the distribution guideline, so one can claim I did not know. Jan I On 30 December 2012 12:14, Peter Junge peter.ju...@gmx.org wrote: Hi, from time to time there are requests to bundle OpenOffice with 3rd party products. A typical case is that a publishing house wants to release a commercial box in which they bundle an original version of Apache OpenOffice with a handbook (either printed or electronic) and some goodies like a pack of templates. As I'm expecting such cases will pop-up frequently (mostly at private@, hence they're not too visible here), it would be good to have some guidelines in place. I have drafted some, please review and comment. The result is intended to be submitted as a proposal here and should go on our website later. Happy New Year Peter - === Guidelines for redistributing (an original) Apache OpenOffice with 3rd party bundles === 1) You must solely use an unmodified binary version of Apache OpenOffice that can be downloaded by anyone from http://www.openoffice.org/** download/index.html http://www.openoffice.org/download/index.html. If you build your own product from the Apache OpenOffice sources, then you must give your product a different name that must not be confused with Apache OpenOffice. Under certain circumstances, you may then use 'Powered by Apache OpenOffice'. For details, please refer: http://www.apache.org/**foundation/marks/faq/#**poweredbyhttp://www.apache.org/foundation/marks/faq/#poweredby 2) You must always use the proper name 'Apache OpenOffice x[.y[.z]]' (e.g. 3.4.1) for our product. IMPORTANT: Do NOT use 'Apache Open Office' or 'Apache OpenOffice.org' or 'OpenOffice' or 'Open Office' or 'OpenOffice.org' etc. 3) Do not use any additions to 'Apache OpenOffice x.y.z' with the title of your bundle that imply that you are shipping a product which is superior to Apache OpenOffice, e.g. you must not use a title like 'Apache OpenOffice 3.4.1 Professional'. You may rather use the title 'Apache OpenOffice 3.4.1' with a subtitle like '{YOUR_BRAND} Professional Pack' because you have added value to an original Apache OpenOffice. 4) If you want to use the Apache OpenOffice logo on your bundle, you must solely use the original, unmodified Apache OpenOffice logo: https://svn.apache.org/repos/**asf/openoffice/ooo-site/trunk/** content/images/AOO_logos/svg/**OOo_Website_v2_copy.svghttps://svn.apache.org/repos/asf/openoffice/ooo-site/trunk/content/images/AOO_logos/svg/OOo_Website_v2_copy.svg 5) You must attribute the Apache Software Foundation and it's trademarks with all components of your bundle (e.g. Cover, Box, printed Book, electronic book, CD/DVD etc.). A proper attribution is: --- Apache,[ the “Apache logo”,] Apache OpenOffice, OpenOffice and the “Apache OpenOffice logo” are trademarks of the Apache Software Foundation ( http://www.apache.org) --- For the detailed Apache Trademark Policy, please refer: http://www.apache.org/**foundation/marks/http://www.apache.org/foundation/marks/ 6) You must make clear with all components of your bundle (e.g. Cover, Box, printed Book, electronic book, CD/DVD etc.) that you are providing an unmodified version of Apache OpenOffice with your bundle. A proper way to do that it adding an informative statement like: --- Includes the original Apache OpenOffice 3.4.1 as provided by the Apache Software Foundation under Apache License Version 2 at http://www.openoffice.org/**download/http://www.openoffice.org/download/ . --- 7) Your setup routine must clearly distinguish between installing Apache OpenOffice and the additional products of your bundle. 8) There may be exceptions to the guidelines as above, but they must be explicitly permitted by the Apache Software Foundation. 9) You must contact the Apache OpenOffice Project Management Committee at priv...@openoffice.apache.org before releasing your bundle so our community is able to review it. Please keep in mind that these are just guidelines and granting you the privilege to use 'Apache OpenOffice' with your bundle is at the sole discretion of the Apache Software Foundation on a case by case basis. It wasn't altogether clear to me that the reference here was to the trademark, rather than to the code. Incorporating Jan's suggestion and mine: ... granting you the privilege to use 'Apache OpenOffice™' or other ASF trademarks and logos with your bundle ... a case by case basis. In no case is such labeling of distributions allowed without the written consent of the ASF. /tj/
Re: Endnote/Index in Writer
On 12/30/2012 07:11, Rory O'Farrell wrote: On the en-Forum it has just been pointed out to me that Endnotes place themselves at the End of a document; this prevents an alphabetical Index being placed there, which is the usual location for it. Perhaps this should be considered for alteration in a forthcoming revision of Writer. Hi, Rory, Would a fake master doc (only one sub-document) be a quick way around this problem? The endnotes should stay with the chapter, and the index, specified in the master, should come last. (I don't use these features, so I can't say for sure.) HTH, /tj/
Re: [mwiki] Spammers are baaack ...
On 12/25/2012 23:18, Louis Suárez-Potts wrote: On 12-12-25, at 21:51 , RGB ES rgb.m...@gmail.com wrote: 2012/12/26 TJ Frazier tjfraz...@cfl.rr.com @jan, Can you process the user creation log for today, and send me (off-list) the user names and email addresses? I've already blocked two new spammers, and I'm deeply suspicious of the other new accounts. Any ISP involved will be hearing from me. Do I assume correctly, that something (Apache server?) can be configured to reject IP addresses or ranges? If so, do you do that, or do we need to go through Infra? As a general rule I don't think that banning IP's is a good idea: most people on the Internet have dynamic IP connections. I remember some years ago that I was blocked from entering a comment on the extension site: the IP I had at that time was banned because used by spammers... some days later when my IP changed again I was able to log-in and post comments without problems... Regards Ricardo I asked Florian of the Doc.Foundation what strategies they use to combat spam. No magic ballistic object. Just vigilantes. -louis Hi, Louis, Thanks for the comparative info. We have a fine crew of volunteer vigilantes, but I want to try playing offense instead of defense. /tj/
Re: [mwiki] IS DOWN FOR DB MAINTENANCE for the next couple of hours !!!!
On 12/25/2012 08:05, janI wrote: On 25 December 2012 13:22, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/25/2012 04:03, janI wrote: HI Tj and Helen. First please bear over with me, it is x-mas morning, and my head is not fully operational :-) Let me explain: we are actually running on the test system, I have a link for production that I can switch to different directories, and I simply pointed it at test (which makes it easy to switch back). Of course I also updated the DB. @Tj: I see your problem, that is a security issue I did not see comming :-( You tested the editor in test, can you confirm that it had no problems ? @Helen: This has to do with the UTF8 conversion, I understood from the previous mails that it worked on wikitest...and I just tested a couple of pages (in russian), which to be honest I did not understand, but the looked like the old wiki :-) I can do the UTF8 conversion, pn text and pages in the live system, but I have my children visiting, so it will take a couple of days. If any of you (on anybody else with a serious reason) request that I roll back I wil do it by restoring the db backup from yesterday and activating the old code...please advice quickly in order not to loose too many changes. Have a nice day, and thanks for advicing me. Jan I. Hi, Jan, Helen, *UTF8*: It seems we have some scattered conversion problems in this area. The big question is, how many? The Unused files special page is showing strange entries for the first few items, too; the names look like what I'd expect from double conversion. @Helen: can you give us a better idea of how big the problem is? Cyrillic is Greek to me (=unknown), too. I am assuming that this would be important, for going back or going forward. Helen told me off list, that we should go ahead and fix iit in the live version, but your comments make me a bit nervous, so yes I also would like a damage estimate. I have not run the UTF8 conversion script we got, so that might solve the whole problem. I see in a later note that you are doing this. Good; I think we need it. *Editor*: Loading the toolbar has always been a two-step process: the first part is initially visible, then the rest of the icons load quickly but visibly later. (I'd love to know more about what's going on here, because I'd love to add an icon to the list: ttTEXT HERE/tt, something I use frequently.) I think (but cannot confirm) that it was working on testwiki. I did do a little editing on testwiki, so I should have noticed the glitch, but maybe I didn't. Please have a look now, I added WikiEditor instead of the default, because it has some issues with the seconds part icons and are not easy extendable. Look in mediawiki, there are examples on how to extend the icons, you can do it for your user, and once it works I can include them. WikiEdditor looks good to me, and seems to work fine. I will investigate extending the icons. *Category for Speedy Deletion*: Jan, you deleted this category. Granted, it was empty at the time, but we sysops chase and delete pages that show up here. This is how non-sysops request page deletion, by adding the template, {{delete|explanation}} to the page. Then a sysop looks at the page and the reason, and acts accordingly: deletes the page or removes the template, and explains why in the summary. Sorry, there was not comment like in the russian pages. Can you please make it again, and put a comment in there. Done. Most of the users who would request such a thing are now sysops, and can do their own deletions, but even there, they might want a second opinion. I suggest that this method is worth keeping. Therefore, I have re-created the category. Agree, but please put a note like to not delete even if empty for future admins :-) Done. Concentrating on the glitches, I have failed to mention that most of the new setup looks wonderful. It was a lot of work, and we are most grateful for your attention. /tj/ /tj/ On 25 December 2012 04:54, Helen russian helenruss...@gmail.com wrote: Hello all. Jan, Russian characters are damaged in the page names and in the category names. Please look at http://wiki.openoffice.org/**wiki/Category:RUhttp://wiki.openoffice.org/wiki/Category:RU Look also at other names: httphttp://wiki.openoffice.** org/wiki/Category:AR http://wiki.openoffice.org/wiki/Category:AR ://wiki.openoffice.org/wiki/**Category:ARhttp://wiki.openoffice.org/wiki/Category:AR http://wiki.**openoffice.org/wiki/Category:**ARhttp://wiki.openoffice.org/wiki/Category:AR -- Regards, Helen 2012/12/25 janI j...@apache.org: Hi Tj. I have no problem with the editor tool bar ? or did I misunderstand you ? (see attachment) Wikitest is not active at the moment, because I have switches 1.20.2 to production. Rgds Jan I. On 24 December 2012 20:47, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/24/2012 06:50, janI wrote: Hi. I have taken wiki.openoffice.org, down for a db maintenance
[mwiki] Spammers are baaack ...
@jan, Can you process the user creation log for today, and send me (off-list) the user names and email addresses? I've already blocked two new spammers, and I'm deeply suspicious of the other new accounts. Any ISP involved will be hearing from me. Do I assume correctly, that something (Apache server?) can be configured to reject IP addresses or ranges? If so, do you do that, or do we need to go through Infra? /tj/ P.S.: Something is really slowing down any save (or delete) operations. I had one time out. I think the same was true of testwiki. Unless you're running a lot of background scripts, something is wrong.
Re: [mwiki] IS DOWN FOR DB MAINTENANCE for the next couple of hours !!!!
On 12/24/2012 06:50, janI wrote: Hi. I have taken wiki.openoffice.org, down for a db maintenance. Jan I. Jan, I'm seeing a problem with the editor tool bar. Tried to check it out on testwiki, but got a 403. /tj/
Re: Request Mwiki account
On 12/22/2012 06:57, Bycadi Rao wrote: Dear Sir, Myself Kiran and writing from India. I am a Vb.Net programmer and i would like to merge OpenOffice to my vb application forms. i saw some of the web site and try to learn the same but when ever i clicked on something to download (ODF Toolkit) it's leading me to http://wiki.openoffice.org/wiki/New_accounts page for further procedures. My request is to kindly provide me the uesr crendentilas to download the OCX controls of OpenOffice and use the same in vb.net... Hope you will help me in this regard. Hi, Kiran, We're sorry that you're having a problem. A wiki account is necessary to /upload/ files to the wiki, but /not/ necessary (or even helpful) for downloading. The ODF Toolkit is not hosted on the wiki. What you are seeing is an error in the links. Please write to the list again (not to me), and give the page URL where you found the link, and the link itself. Then I or someone will try to straighten this out. /tj/ (wiki Bureaucrat)
Re: [wiki help] sysop help needed !!
On 12/22/2012 11:17, janI wrote: On 22 December 2012 17:10, RGB ES rgb.m...@gmail.com wrote: 2012/12/22 janI j...@apache.org Before I upgrade our database (and system) to 1.20.2 I would like to clean some of the dead stuff. I would apriciate if some of the sysop could help me with - looking at special page/unused files and delete them (during upload people are warned this will happen) I started to delete some unused files. There are an awful lot of them... That is why I need some help :-) but it does not matter if it takes a bit of time..I will not do the upgrade until end of year. Regards Ricardo - looking at special page/unsed categories and delete them (WATCH out, at least one russian template has a remark please do not delete) there are too much for me alone. Once it has been done, I will clean it from the database, so we have a slimmer system, without loosing any information. Jan. Hi, Jan, Cleaning out some files, I found a lot of students doing their homework on the wiki :/ so I hope you will run your delete stale unused accounts script again, and with the date updated to the next month. We should get rid of a lot of stale accounts. BTW, I am adding a request to the Wiki Maintenance page, to install the CheckUser extension. I want to use that to fight the spammers. /tj/
Re: [Release candicate] mwiki, test
On 12/22/2012 16:33, janI wrote: We have had a problem with math rendering, this has now been resolved and verified. That is the last open bugzilla issue, in parallel infra have helped me secure all changes in the infra svn, so basically we are ready to upgrade the production system. In order to upgrade production I need a window of approx. 12 hours, where the wiki is down. Are there anybody who have opinions on when it should be done (or when not) ? Looking at the time I have available, it can be done before 31/12/2012 or beginning january 2013. jan I. I would suggest a Sunday, or a Saturday, as fairly low-usage days. Any time of day will be inconvenient for some people, so pick a convenient time for you! :-) /tj/ On 21 December 2012 00:42, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/20/2012 16:44, janI wrote: Can anybody give me a link to a couple of pages with intensive math ?? I have math running in my local version, when I search for math I get 1 hit, and that page displays ok. thx in advance jan http://wikitest.openoffice.**org/wiki/Documentation/** Reference/Math_commandshttp://wikitest.openoffice.org/wiki/Documentation/Reference/Math_commands has many but very simple math commands. All seem to be working fine. My user page has one example. It's working fine. With the removal of the F*CK editor, the preview before first edit preference now works fine. Very glad to have that back. /tj/
Re: [wiki help] sysop help needed !!
On 12/22/2012 16:40, janI wrote: On 22 December 2012 22:32, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/22/2012 11:17, janI wrote: On 22 December 2012 17:10, RGB ES rgb.m...@gmail.com wrote: 2012/12/22 janI j...@apache.org Before I upgrade our database (and system) to 1.20.2 I would like to clean some of the dead stuff. I would apriciate if some of the sysop could help me with - looking at special page/unused files and delete them (during upload people are warned this will happen) I started to delete some unused files. There are an awful lot of them... That is why I need some help :-) but it does not matter if it takes a bit of time..I will not do the upgrade until end of year. Regards Ricardo - looking at special page/unsed categories and delete them (WATCH out, at least one russian template has a remark please do not delete) there are too much for me alone. Once it has been done, I will clean it from the database, so we have a slimmer system, without loosing any information. Jan. Hi, Jan, Cleaning out some files, I found a lot of students doing their homework on the wiki :/ so I hope you will run your delete stale unused accounts script again, and with the date updated to the next month. We should get rid of a lot of stale accounts. Thanks for helping, the list seems endless :-( I will run the script again, but not until the upgrade is done, and if the students have uploaded images they will not be deleted, my script searches for users with no contributions of any kind, however I can modify it (if the community agrees) to search for users with my PAGE contributions. The users in question no longer have files uploaded; they've been deleted. If your script counts deleted contributions as active, then yes, please change it. Otherwise, the accounts will disappear properly. BTW, I am adding a request to the Wiki Maintenance page, to install the CheckUser extension. I want to use that to fight the spammers. I looked at the extension, I can load that, no problem...but if I understand it correctly it does not help identifying already created users. The extension is no help in identifying new spammers, but it's a great help in chasing them, by complaining to the ISP. I have all the bookmarks for that, from my time as a ML moderator. It's also helpful in identifying multiple accounts for the same user (which is okay, unless they're all spammers!). Did you have a look at the new create account page, on wikitest, that is not easy for the average spammer to bypass. It certainly looks ferocious! I hope it works. /tj/ jan I. /tj/
Re: [Release candicate] mwiki, test
On 12/22/2012 17:04, janI wrote: I will pick a time after breakfast on a sunday :-) I have installed checkUser. In order to activate it for you, you need to go to Special:UserRights and add the CheckUser group to your account, then you can see it in the normal specialPages. HOWEVER, it reports 127.0.0.2 for all users, because of ATS. Please have a look at it, and if I am right and it is not efficient I would like to deinstall it. have a nice day. Jan I. Yes, you are right; the IP address of 127:0:0:2 is not helpful; you can deinstall CheckUser. I checked my own user name, and got an earlier (from 12-01), real IP address. I assume that you hadn't installed ATS yet. What I really want is email addresses. I was sure there was supposed to be a new way to retrieve those, but maybe I was wrong. I'll do some more searching on WikiMedia. /tj/ On 22 December 2012 22:55, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/22/2012 16:33, janI wrote: We have had a problem with math rendering, this has now been resolved and verified. That is the last open bugzilla issue, in parallel infra have helped me secure all changes in the infra svn, so basically we are ready to upgrade the production system. In order to upgrade production I need a window of approx. 12 hours, where the wiki is down. Are there anybody who have opinions on when it should be done (or when not) ? Looking at the time I have available, it can be done before 31/12/2012 or beginning january 2013. jan I. I would suggest a Sunday, or a Saturday, as fairly low-usage days. Any time of day will be inconvenient for some people, so pick a convenient time for you! :-) /tj/ On 21 December 2012 00:42, TJ Frazier tjfraz...@cfl.rr.com wrote: On 12/20/2012 16:44, janI wrote: Can anybody give me a link to a couple of pages with intensive math ?? I have math running in my local version, when I search for math I get 1 hit, and that page displays ok. thx in advance jan http://wikitest.openoffice.org/wiki/Documentation/** Reference/Math_commandshttp:/**/wikitest.openoffice.org/wiki/** Documentation/Reference/Math_**commandshttp://wikitest.openoffice.org/wiki/Documentation/Reference/Math_commands has many but very simple math commands. All seem to be working fine. My user page has one example. It's working fine. With the removal of the F*CK editor, the preview before first edit preference now works fine. Very glad to have that back. /tj/
Re: [Release candicate] mwiki, test
On 12/20/2012 16:44, janI wrote: Can anybody give me a link to a couple of pages with intensive math ?? I have math running in my local version, when I search for math I get 1 hit, and that page displays ok. thx in advance jan http://wikitest.openoffice.org/wiki/Documentation/Reference/Math_commands has many but very simple math commands. All seem to be working fine. My user page has one example. It's working fine. With the removal of the F*CK editor, the preview before first edit preference now works fine. Very glad to have that back. /tj/
Re: Is mwiki down?
On 12/17/2012 06:22, Shenfeng Liu wrote: I can not access mwiki now... Any one can help to check? Thanks! - Shenfeng (Simon) Hi, Simon, Yes, it's down. The link below[1] is very handy for checking on things like this. [1] http://monitoring.apache.org/status/ The mwiki is currently marked in red, which should mean that someone in Infra is already hustling to fix it. /tj/
Re: [UX]Comments visibility
On 12/16/2012 01:41, Kevin Grignon wrote: KG01 - see comments inline On Dec 15, 2012, at 11:31 PM, Andrea Pescetti pesce...@apache.org wrote: On 08/12/2012 RGB ES wrote: Some users, mostly when reading an existing document, tend do disable the view of comments with View → Comments. The problem with this option is that comments disappear *completely*, which increase the risk of deleting a note by accident. KG01 - The system should avoid deleting hidden elements. Should the system try to delete content which includes a hidden comment, we should inform the user of the consequence of the action, and provide a way to quickly review the comment, in context, and give them options on how to proceed. Options could include 1) delete content and comment, 2) delete content and push comment to cursor location 3) or cancel action. I agree this can be a usability problem. So I think there are two point that can be considered: 1- Set by default the option of viewing note anchors even when view comments is disabled. KG01 - View option for common objects could be simplified. With some task pane toolbar view options (clipart gallery, navigator, etc) moving to sidebar task pane, we could push a high frequency view options command (dropdown) to the main toolbar. Where one click on/off could control view options, such as comments. This makes sense, but then we would have to add an option at least in Tools - Options - Writer - View to hide comment anchors too (and it would have to be active only if Comments in unset... not very friendly). 2- Make note anchor show a tooltip with the note content, the same way footnote anchors show footnote content when hover over it, but of course only when view comment is disable. KG01 - we could explore user friendly action tool bars as a way to reveal comments. This would work, but the user wouldn't get rid of comments completely. He would still see the anchor and I don't know how annoying this would be. KG01 - I'll add this to the ux backlog. This is an area where we should sketch out some concepts, then socialize for feedback. Definitely a good question for UX! KG - Yup. Keep 'em coming :) Regards, Andrea. While you're thinking about visibility, please think about bookmarks. Totally invisible, very deletable, combination undesirable. /tj/
Re: [question] draw...
On 12/16/2012 14:08, janI wrote: [snip] Working with updating the wiki, I tried to use it :-) but the page: http://wiki.openoffice.org/wiki/Draw_Guide is very empty ?? so where is the guide ? The v2 guide on the wiki is out of date, but it's there. All the wikified guides work the same way: use the purple TOC box at the right. A v3.3 guide is available in ODT[1] and PDF. The links are described on the wiki documentation page. [1] http://wiki.openoffice.org/w/images/5/50/0400DG33-OOoDraw3.odt /tj/
Re: Request mwike account or something to that effect
On 12/12/2012 20:14, Ed Bradford wrote: I would like to ask a question about how to write a macro that can dynamically discover a table to sort. Having to define each range and each macro to sort each range doesn't work for me. I might be missing something, but I simply wanted to ask my question: How can a Macro dynamically discover the range of data to apply its logic to? Ed Bradford Pflugerville,TX egbe...@gmail.com Hi, Ed, You get a reward for spelling out your problem: a direct answer, instead of an unfortunate runaround. Your question belongs on the User Forum[1], but you will probably find the answers already there, with useful code examples and in much greater detail than the brief explanation below. If you still need to ask something, sign up for a forum account (that's DIY). Writer keeps its tables in a collection, available from the document object. You can iterate through the collection, looking for tables that meet your criteria for needs sorting. Each table has a collection of rows. That collection has a useful property, .getCount(), which returns the number of rows. Happy sorting! HTH, /tj/ [1] http://forum.openoffice.org/en/forum/ (If you distrust emailed links, follow the link in the navigation box, on the left of every page in the wiki.)
Re: Admin mailing list?
On 12/13/2012 09:14, janI wrote: I give +1 for the list and the WIKI account part, then we can see over time, if web discussions naturally move to that list. Jan. By request account creation on the wiki is a fine short-term solution for the spammer problem (until the upgrade). In the long run (after the upgrade), IMHO it is unnecessary and unacceptable. AOO doesn't need this anywhere else, Wp doesn't need it, and our wiki shouldn't, either. Running on an up-to-date platform, we should be able to find some technology which suits our users' needs, and keeps the spam down (not completely, but nothing will). A little forensic research on those thousands of spam accounts might show us what we do need. What kind of email addresses did they use? We used to have some local code to prohibit the public drop box email sites, as well as a RECAPCHA for account creation and for external-link saves. Did any of that make it through the move to Apache? Checking links might be expensive, since it would have to be done on every save, but account-creation checks should only be invoked on account creation. If the account requests go away, so does the admin ML. Probably a good thing. /tj/
Re: can I get permission to upload file to mwiki ?
On 12/12/2012 17:39, Andrew Douglas Pitonyak wrote: On 12/11/2012 12:25 AM, Shenfeng Liu wrote: I'd like to continue the working on the fidelity improvement wikihttp://wiki.openoffice.org/wiki/Documentation/Fidelity_Improvement_Since_AOO341, and need to upload screenshots. My wiki account is liushenf . Thanks very much! - Shenfeng (Simon) Was this taken care of? I do not think that I have the ability to grant this access, only to create accounts that I saw Am I mistaken on this? Sorry to be slow on this. @Simon: try it now. You are now a sysop. @Andrew: thanks for reminding me. This needs a bureaucrat, to make a new sysop. /tj/
Re: NewWikiMainPage
On 12/10/2012 02:39, Andrea Pescetti wrote: tj wrote: 2) Please use a suitable subject, like Labels. Your query has nothing to do with the wiki main page. Note that this is due to the fact that http://wiki.openoffice.org/wiki/Main_Page contains a notice saying You're looking for the old wiki main page and miss items not transferred to this one? Send us your feedback or transfer missing items to this page, where Send us you feedback is a mailto link to this list with subject NewWikiMainPage. Since that notice is probably outdated now, I would replace it with a line saying For user support, please use the User Forum, linked to http://forum.openoffice.org . Regards, Andrea. Andrea, Oh, nice catch! Done. /tj/
Re: Request Mwiki account
On 12/9/2012 13:33, marc payen wrote: USER NAME : marcooo93 Best regards Done. You should have the email with your random password. Please change that when you first log in. Welcome to the wiki! Write here again if you have any problems. /tj/ (User:TJFrazier on the wiki)
Re: [RELEASE] Update 4.0 planning items
On 12/6/2012 23:11, Shenfeng Liu wrote: Hi, all, I suggest we update the planning items in 4.0 wiki: https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.0+Release+Planning I just updated the status of each items and added some more according to my reading of the mails. I hope every one can help to review the list and: (1) input your name if you volunteer to any of the items (especially those without owner now); (2) for those in Proposed status, update the wiki or reply to this mail, confirming if you still think you can/will deliver it in 4.0, or if you prefer to move it to future releases, or think it is no longer important or valid. (3) add new items that you are working on or you plan to deliver in 4.0. Then by the end of next week, I propose to move out those with no volunteer (I intent to move most of those items to 4.1 planning wiki temporary), then update the rest according to the response from volunteers. Please tell me if any comments/suggestion. And very appreciate for the update! Thanks! - Shenfeng (Simon) The Encryption GUI item has not attracted a sponsor. I added this per the resolution of a very long discussion in BZ [1]. Subsequently, Jürgen wrote an extension to set SHA256 mode, and I wrote a macro[2] to toggle the settings; both are still available. (I have no idea whether any or many users have used them.) [1] https://issues.apache.org/ooo/show_bug.cgi?id=119090#c31 [2] http://wiki.openoffice.org/wiki/User:TJFrazier/Encryption (this page includes text suitable for release notes) If somebody wants to pick up on this, and implement a GUI (probably in Tools Options, possibly on the Save and Save As dialogs), that's wonderful. Lacking all fu for SVN and C++, I can't volunteer for this. If we let the GUI slide, and keep the status quo, then I have a couple of suggestions: 1) I will try to enhance the macro to change the active settings. Currently, it changes the values in rm.xcu, which do not take effect until the suite is restarted (not very convenient, but much better than having to edit the parameter file by hand). I have failed at this before (the documentation has problems), but I will try again. 2) Add the macro to the Basic Tools library, possibly in its own module. I can supply a .txt or .bas file, or it can simply be scraped off the wiki page. This is the easiest way I know to distribute a macro whose lifetime should be that of the version; easy to add, easy to refer to in the notes, and easy for users to get at. If I can't update the macro by code-cutoff time, we can go with what we have. /tj/
Re: new user
On 11/30/2012 08:01, Agustín Godino wrote: I would like to be an user in the openoffice wiki. The user name I wolud like is: agusk75 Thanks. Agustín Godino. Done. You should have the generated email. Write again if you have problems. You may not be able to create new pages just yet, so I have created your user page for you. (This is another temporary problem associated with the spammers; it will be back to normal soon.) /tj/ (User:TJFrazier on the wiki.)
Re: New page in media wiki
On 11/29/2012 04:22, Andre Fischer wrote: Hi, I would like to create a new (Media)Wiki page but can't. Editing is still possible. Maybe one of the wiki admins could create the page Sidebar ? My user name is Andre. Thanks, Andre Hi, Andre, This is fallout from the spam problem. I have appointed you a sysop. Please use your new karma cautiously. /tj/ (TJFrazier on the wiki)
Re: [call for review] wiki maintenance
On 11/28/2012 16:48, janI wrote: This is my final sql script for location old users without contributions, can someone please verify the script ? The script only collect user_id, user_name, user_registration in the table xmaint_uids. It is running right now, and once finished (in the morning if no errors) I will publish the names that will be removed, wait 72 hours and then remove them, unless objections. The delete statements that comes afterwards are quite simple: delete from user where user_id in (select user_id from xmaint_uids); delete from logging where log_user in (select user_id from xmaint_uids); Jan. Jan, You have locked down the wiki so tightly that even sysops can't create new pages. If this is necessary, we'll have to live with it, but please let us know for how long. If this is not necessary, please fix it. /tj/
Re: [call for review] wiki maintenance
On 11/29/2012 13:19, janI wrote: Thanks I did not know that LEFT JOIN and JOIN has different speeds on inodb tables. I made the fast fix, and split xmaint_uids into smaller tables, and is running now. BUT I am dead nervous of deleting wrong data !! so the review in general would be nice. I have also decided to post the user list here, to give people a chance to shout and get removed from the list. There are very little margin for errors on our database, and I would not like to cause problems (I think I already have used this years allowance). Thanks for your suggestions, I will implement a couple of your ideas before I release the final script. Jan. Quick question: How do you expect anyone to review 30K account names? I suggest to go ahead and delete them. --/tj/ On 29 November 2012 19:09, Andrea Pescetti pesce...@apache.org wrote: On 29/11/2012 janI wrote: ooo-wiki VM is so weak (compared to my notebook) that a lot of my special select/join statements timed out...and the just because I have a simple where clause where user_id in (select user_id from wiki_maint_uids) I only had a quick look yesterday and I cannot check now, but there were several possible speed improvements, including using a simple JOIN instead if a LEFT JOIN and then discarding NULL matches, introducing a primary key or an index in the wiki_maint_uids table and using update on joins instead of subqueries. I didn't test any of these, and I didn't see the database, so don't trust the lines above too much! They are just semi-random thoughts based on the code I saw yesterday, and it could turn out that these changes slow down the queries instead of improving them. Regards, Andrea.
Re: IAccessible2 integration for AOO 4.0
On 11/26/2012 13:40, Rob Weir wrote: On Mon, Nov 26, 2012 at 1:16 PM, Dennis E. Hamilton orc...@apache.org wrote: Is this to be based on the Symphony code? Dennis, we have Symphony code within IBM. Remember, we wrote it. Whatever code we check in is covered by signed ICLA's and CCLA's. That should address all reasonable concerns with regards to the provenance of the code. -Rob Rob, Cover concerns in the larger sense, yes: nobody should be worried that we or our downline customers will be jumping on anyone's copyright, by using the material in accordance with ALv2. But, in the smaller sense, maybe no. If the themes contain license information (presumably IBM's), then IIUC this /SHALL/ be changed by a duly authorized IBM employee before the code is added to AOO. (This is the same dull, demanding, and absolutely necessary job that Andrew Rist did for us, as authorized by Oracle.) A simple statement by Armand that no such license data exists, or by an IBM'er that the data will be changed, should allay any concerns; and we should feel confident of passing the RAT scan. /tj/ - Dennis -Original Message- From: Steve Yin [mailto:steve.yin@gmail.com] Sent: Monday, November 26, 2012 01:07 To: dev@openoffice.apache.org Subject: Re: IAccessible2 integration for AOO 4.0 Thanks for both of your suggestions. The time table will be provided later. On Mon, Nov 26, 2012 at 4:12 PM, Jürgen Schmidt jogischm...@gmail.comwrote: On 11/26/12 6:59 AM, Steve Yin wrote: Hi, I propose to integrate IAccessible2 as an accessibility feature for AOO 4.0. A wiki for the effort estimation can be found here: https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+4.0+IAccessible2 Here is my question. Should I create a feature in AOO Bugzilla and a branch for development? Hi Steve, this is good news. I would suggest that you give some details what do you expect to implement when. The integration of IAccessible2 is a bigger task and I don't see it all integrated in the next 4 month or so. Creating a new feature task in bugzilla would be the normal procedure and a new branch is a must from my perspective for this huge piece of work. Good to see progress on this important integration. Juergen -- Best Regards, Steve Yin
Re: Request Mwiki account
On 11/26/2012 13:06, Thiago Ramos wrote: My username can be thiago_addlabs and e-mail this same. Thanks. Att, Thiago Giannini Ramos --- Analista de Sistemas - ADDLabs - IC/UFF http://www.addlabs.uff.br/ Av. Gal. Milton Tavares de Souza, s/nº - Niterói - RJ Done. Your confirmation email should be there by now. Please write again if you have problems. /tj/ (User:TJFrazier on Mwiki)
Re: New wiki acount
On 11/26/2012 16:24, Vincent Thiry wrote: User name : balak064 Mail : balak...@gmail.com Thank you Done. You will want to change your password after you first log in. If you have any problems, please write again. /tj/ (User:TJFrazier on Mwiki)
Re: Wiki maintenance.
Hi, Jan, TJ comments inline. On 11/25/2012 06:50, jan iversen wrote: I am starting this thread so we have a place, to keep our decisions. I will also a bit later make a new wiki page, wiki planned maintenance where I (and hopefully also the other administrators) will keep track of the work done, as well as the work ahead of us. For now, the sql scripts to: a) remove accounts older than a year WITHOUT any contributions b) remove all accounts from the time of the spam period are being prepared, and will be executed when I get a little opie challenge solved. I would like to seek lazy consensus on the following items: a) In order to keep track of all php/apache/mysql changes to wiki, I will make a directory wiki-maintenance in SVN on level with trunk. Currently we do not really know what has been changed, and with the upgrade we have a nice opportunity of documenting all changes, so it is easier for future administrators. I know there is a very good page in Wiki (wiki maintenance) but I would like to have the original files, with all changes in SVN. +1. We might ask the forum people how they do it (it's a parallel problem to the wiki); they may want to do the same as you are suggesting. b) open for create page again, now that all spam users have been blocked. Create user will have to wait at least a week and if we do not get flooded with request, I would keep invite only for a longer period. I believe the spammers still have a backlog of unused (hence, unblocked) accounts, but your script to remove all spam period accounts should get rid of those. After that runs, yes, please re-enable create page. The problem with both invite only and write delay is with a valuable class of new users. Ignoring the large number of new accounts that are never used, the fixers are the most common new users (one per month or less): they create an account, and immediately fix something, or ask a good question on the Talk page. I would like to cater to them, by making life easy. c) When reactivation create user add a cooling period, like page http://wiki.openoffice.org/wiki/Documentation/Dashboard/Wiki_Editing_Policysays we already have. d) Clean database, for deleted pages, unused files. e) repair broken redirect, double redirect, non categorized pages. Remark no information will be deleted/changed. Broken and double redirects are normally handled by sysops, from inside the wiki. At the moment, there are no double redirects (I just fixed two). The broken redirects seem to be related to recent work in the Spanish (ES) pages; I left RGB (sysop, Spanish speaker) a note to take a look. non categorized pages is a much bigger question. It doesn't take a sysop to add a [[Category:whatever]] line to a page, but what line should be added? Currently there are a couple of hundred such pages. Anybody can do the research (how are the pages that link to it categorized? Or, what top-level category is its home; is there a lower-level category that fits?) and is welcome to help fix these. It's a one-at-a-time job, mostly. f) Convert all pages to UTF8 (mysql), most pages are defined as latin1, but some have UTF8 content, this will not work after an update. g) Make a test.wiki.openoffice.org. This can be done with a simple alias in apache conf, but should be done with a JIRA ticket. Of course, before any changes to the production mysql a backup will be made. Jan Many thanks for your work. /tj/
Re: Wiki spamming is going to get worse if something isn't done soon...
On 11/23/2012 04:20, jan iversen wrote: I am happy for the help, Clayton has already giving me lot of information, instead of me having to dig it out. It is also securing to have a helping hand in the background who know our wiki very well. Is there a gentle way, to make Infra do the last bit, so I can get access, as far as I can see it is 2 simple things: - Copy my ssh public key to the wiki server - Provide the mysql root password I am a bit afraid of this long US weekend, and hope we do not have to wait until next week. Jan. Report from the trenches: the spam is getting no worse, but no better either. The wonderful crew of volunteers (I play only a small part) is getting it all. Max spam page lifetime is about an hour; typical is only a few minutes. We may be humans fighting bots, but we're winning — or at least not losing. (John Henry said to the captain ...) I also fear the long weekend. The urgent items I see, first = most important: 1) invitation only fix to LocalSettings.php. This turns off the faucet. 2) SQL delete of all unused accounts (no contributions in any space). This eliminates the spammers' backlog of new accounts, so we sysops don't have to block them one at a time. This will hit a lot of old accounts, too. Good; that's overdue. It is possible that a few legitimate accounts could be hit, but contributors normally go right in and fix something, and/or create their user pages, so those accounts should be exempt. Other items can be dealt with at leisure: 3) Deleting all blocked accounts, the blocks themselves, and any associated deleted pages. This is a trash clean-up. It removes any backscatter left over from the anti-spam effort, and recovers a minor amount of space. 4) Upgrades, extensions, better spam prevention, c. /tj/ On 23 November 2012 09:00, C smau...@gmail.com wrote: On Fri, Nov 23, 2012 at 1:16 AM, Andrea Pescetti pesce...@apache.org wrote: Thanks Clayton, you probably know the inner details of our Mediawiki configuration better than most people here, so it is great that you are going to coordinate with Jan to neutralize this attack. Jan will be leading the defense. I'll be hanging around more in the background trying to explain why things are wonky with historical configuration :-) The Spam problem can definitely be delt with... just takes a bit of time to sort things out, do a few upgrades and a few configuration tweaks. Meanwhile anyone with current Wiki Admin rights is welcome to scan the Recent changes on the Wiki once in a while and: - Delete Spam pages (created 1 page every 2 minutes on average) - Block the spam accounts (I would suggest that you do not block IP address, a check box on the block page, because you risk blocking legit users on dynamic IPs) Clayton
Re: [Mwiki] New accounts by invitation only?
On 11/22/2012 03:27, Herbert Duerr wrote: Hi Jan, On 21.11.2012 20:24, jan iversen wrote: having looked at the mediawiki pages, especially the amount of updates, and make a trial installation my my private server, I know I can cope with the maintenance problems (but NOT with spam attacks, that requires more than just one person). If the community agrees to it, using the lazy consensus, I volunteer to make maintenance of the mwiki (wiki.openoffice.org). Thank you very much! +1 from me If nobody object I will very fast do the proposed mysql changes: - remove accounts with no contributions during the last year. - removing all new users within the last 2 weeks. and prepare an update to the newest version, (and as Alexandro suggest have a test server) which first run it on my own ubuntu, before going live. I agree, except that I suggest to remove only accounts that never contributed anything. There are many pages from the pre-AOO times with very interesting content that were created or updated by people lost AOO out of their focus in the meantime. Their contributions are valuable though and should not be forgotten. Maybe the page histories would suffer by removing such accounts completely. [...] I have one question though, why do we have cwiki and wikiI might be the only one, but I get confused where to find which information, so maybe we should decide to have all information in just one wiki ?? If I remember correctly there was an issue with the license of our mediawiki, such that the existing content could not simply be relicensed to ALv2 Herbert Hi, all, There may be a little confusion on the current state of the wiki. It is very good: thanks to the really super work by a really super crew of volunteers, the spam is all deleted; the average life-span of new spam is about half an hour. But we can't keep that up forever. What needs SQL-level deleting is: * empty new accounts (never any activity) * blocked accounts with only deleted contributions (the deleted contribs, spam, should go, too) The removal of this trash shouldn't cause problems (fingers crossed). With the wiki set to invitation only new accounts, we should have time for some longer-range planning. /tj/
Re: Fidelity Improvement sample wiki
On 11/21/2012 09:25, Shenfeng Liu wrote: Hi, all, I created a wiki to show some fidelity improvement samples since AOO 3.4.1 in our current build: http://wiki.openoffice.org/wiki/Documentation/Fidelity_Improvement_Since_AOO341#OOXML_Support The purpose of this wiki is to promote our significant fidelity enhancements with shining samples. Of course not all the enhancements/defect fixes can be included in this wiki. Thanks to Jian Yuan Li, Lei Wang, Jian Hong, Zhe Wang and Ying Zhang and other people who send me a lot of good samples. I didn't finish the wiki yet. While any comments are welcome. For now I have 2 questions: 1. I think the contents in this wiki should be in the release notes of our coming 4.0. Maybe a link to this wiki page from release notes? Any suggestion? 2. Currently I can not upload the file of docx, pptx or xlsx. I wonder if any one can help to add them to the permission list? Thanks! - Shenfeng (Simon) Hi, Simon, For (2), this is one of many, many things controlled by parameter file LocalSettings.php. It can only be changed by a site maintainer with root access. That may take a while. /tj/
[Mwiki] New accounts by invitation only?
Can I get lazy consensus on requiring users to request Mwiki accounts on a ML? Temporarily or permanently, I don't know. Any Administrator (sysop) can create a new user account. I will research what change is required to block other sign-up methods. Currently, Mwiki is under massive attack by spammers. Thanks to the valiant efforts of volunteers Adailton, Helen russian, Pitonyak, and Yak, we are staying even: the lifetime of spam may be a few hours, but is usually only a few minutes. However, the spammers are creating new spam accounts (the pattern in the names is quite apparent) at a rate of one every minute or two, and 24/7. We cannot survive that kind of onslaught indefinitely. To be continued. /tj/
Re: [Mwiki] Spam Attack in progress!
On 11/17/2012 08:28, Regina Henschel wrote: Hi, TJ Frazier schrieb: Since 05:00 (UTC+5) this morning, I have blocked over 150 spammers; the deleted-pages count is higher. Normal would be about half a dozen. And still they come. In the short run, I can probably handle it, though help from any committer sysops would be useful. In the long run, some site-maintainer work is needed. The additional powers available in later Mwiki versions might be enough to control this sort of thing. Clayton has advised that upgrading is a non-trivial problem, due to a possible encoding foul-up. Whatever we do, we need to do it sometime soon. Is it possible for you, to disable any new registrations? Then you should do it. We can then discuss long run solutions. Kind regards Regina Hi, Regina, Thanks for the idea, but most of the spammers are already registered (not brand-new). A site maintainer (not me) could disable new registrations easily, but that would not be much help. We need to know how these spammers are registering (their email addresses) and how they are accessing the wiki (their IP addresses). The information is in the MySQL database, but it is only accessible from root-level MySQL commands; Wp is paranoid about user secrecy. For instance, are they using those open reply email addresses, where the email waits to be picked up by anybody? Clayton had a code snippet to block their use, but it may not have survived. I have promoted one dedicated and careful user to sysop; between us, we are keeping up with the flood. But they are still coming. /tj/
[Mwiki] Spam Attack in progress!
Since 05:00 (UTC+5) this morning, I have blocked over 150 spammers; the deleted-pages count is higher. Normal would be about half a dozen. And still they come. In the short run, I can probably handle it, though help from any committer sysops would be useful. In the long run, some site-maintainer work is needed. The additional powers available in later Mwiki versions might be enough to control this sort of thing. Clayton has advised that upgrading is a non-trivial problem, due to a possible encoding foul-up. Whatever we do, we need to do it sometime soon. /tj/
Re: Editing needed on BZ footer -- remove podling reference
On 11/16/2012 22:04, Dave Fisher wrote: On Nov 16, 2012, at 5:40 PM, Kay Schenk wrote: On Thu, Nov 15, 2012 at 4:47 PM, Dave Fisher dave2w...@comcast.net wrote: On Nov 15, 2012, at 3:08 PM, Kay Schenk wrote: On 11/14/2012 05:06 PM, TJ Frazier wrote: On 11/14/2012 18:47, Kay Schenk wrote: HI -- Could one of our BZ admins please remove the podling reference in the footer area for Apache OOo Bugzilla? Thanks. Hi, Kay, A little research in the BZ Help [1] reveals in Section 6.3.5 that the global footer is in a template, global/footer.html.tmpl. AFAIK it will take root access to the system to change, i.e., we need a site maintainer to do it. HTH, /tj/ Thanks again...Ok, I set up a task for infra -- https://issues.apache.org/jira/browse/INFRA-5529 And it is already done! BTW - There is no Apache OOo or Apache OpenOffice.org project. Shouldn't we rename this the Apache OpenOffice Bugzilla instead of Apache OOo Bugzilla? Regards, Dave We probably should. I saw this also, but didn't take the time to bring this up. :/ We should probably do as you suggest Apache OOo - Apache OpenOffice. You'e only talking about the footer contents, right? More than the footers for this one the name is in many places on the front. TJ might know how big this lift is. Regards, Dave AFAIK, it's all in the templates. /tj/ [1] https://issues.apache.org/ooo/docs/en/html/cust-templates.html
Re: bugzilla.
On 11/15/2012 17:28, Jan iversen wrote: Hi. I have a new mail account, which I have created in bugzilla. Is there a way to move the bugs I have reported with my old e-mail to the new e-mail (in bugzilla) ? Jan. Hi, Jan, If you changed your email address in an existing BZ account (preferences at top of page, Account information tab), it should change on all bugs reported by that account. If you added a new BZ account (giving you two accounts), please consider merely changing the old one. I should be able to delete the extra account, if you want. /tj/ BZ admin
Re: Editing needed on BZ footer -- remove podling reference
On 11/14/2012 18:47, Kay Schenk wrote: HI -- Could one of our BZ admins please remove the podling reference in the footer area for Apache OOo Bugzilla? Thanks. Hi, Kay, A little research in the BZ Help [1] reveals in Section 6.3.5 that the global footer is in a template, global/footer.html.tmpl. AFAIK it will take root access to the system to change, i.e., we need a site maintainer to do it. HTH, /tj/ [1] https://issues.apache.org/ooo/docs/en/html/cust-templates.html