[sc-issues] [Issue 76623] Wrong formatting and displ aying for some dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76623 --- Additional comments from [EMAIL PROTECTED] Wed Jul 11 15:37:52 + 2007 --- Created an attachment (id=46696) Display showing different formatting - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76623] Wrong formatting and displ aying for some dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76623 --- Additional comments from [EMAIL PROTECTED] Wed Jul 11 15:36:35 + 2007 --- I can reproduce this in OOo Calc 2.2.1, though I belive it is a locale problem. W2k SP4 en US-locale OOo Calc 2.2.1 en US-locale After Copy/Paste of the dates mentioned above, the first 2 strings are imported as a(n) (invalid) number (=> therefore text display), while the rest is imported as a date. See attached image. This is probably due to my US-English locale, where 28/04/1948 is NOT a valid date. What locale is your OS? And what locale is your OOo? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 79419] cannot use mouse wheel to scroll
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79419 --- Additional comments from [EMAIL PROTECTED] Tue Jul 10 06:03:25 + 2007 --- There are a number of error reports lately with larger Writer documents. Please see also issues: http://www.openoffice.org/issues/show_bug.cgi?id=79346 and http://www.openoffice.org/issues/show_bug.cgi?id=79409 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 79409] Scrolling Problem
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79409 --- Additional comments from [EMAIL PROTECTED] Mon Jul 9 18:08:33 + 2007 --- This issue could be related to http://www.openoffice.org/issues/show_bug.cgi?id=79346 . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 79346] Writer repaginates Large D ocument every 20-30s
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79346 --- Additional comments from [EMAIL PROTECTED] Mon Jul 9 18:06:23 + 2007 --- This issue could be related to issue http://www.openoffice.org/issues/show_bug.cgi?id=79409 . Indeed, when I scroll (to the statistics functions in the said document), OOo Writer will continuously repaginate and therefore jump to a different page. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 79346] Writer repaginates Large D ocument every 20-30s
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79346 Issue #|79346 Summary|Writer repaginates Large Document every 20-30s Component|Word processor Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|mru Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Fri Jul 6 20:00:28 + 2007 --- I am trying to read and correct the OpenFormula document (see OASIS site, http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula). Unfortunately, Writer *repaginates* every 20-30s, and the number of pages fluctuates continuously between 300-500 pages, rendering any work impossible. Please note, that even after > 2 hours, Writer still repaginates (I think it repaginates, because the number of pages continues to change). So, after some 20-30 s, it jumps to a different page (total number of pages displayed changes, too). This makes working on larger documents impossible. My system: W2k SP4 with 1.2 GB RAM SCSI HDs OOo 2.2.1 There really shouldn't be any memory problems (more than 800 MB physical RAM is free). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] Numerically unstable RSQ, CORREL and STEYX
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Fri Jul 6 19:20:39 + 2007 --- Great! Everything feels correct and stable! My initial algorithm for RSQ() was unnecessary complex (as it was based on the official OASIS document specification). BUT RSQ() is really the square of the Pearson coefficient, so this approach is the correct one! discoleo -> regina Congratulations for the fine patch! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[ui-issues] [Issue 69885] Long Menu Items
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69885 --- Additional comments from [EMAIL PROTECTED] Thu Jul 5 16:22:27 + 2007 --- Well, this issue is really about mouse travel distance. Please also see issue http://www.openoffice.org/issues/show_bug.cgi?id=19557 for a similar feature request/problem. I strongly favour *very short* menu entries. IF such short menus cannot be made, then: - implement a method in which when clicking on the submenu-name, the submenu opens and the mouse is positioned on an item of the submenu (instead of displaying the submenu AND having to travel with the mouse inside the submenu) - draw the submenus (when they open) NOT close to the menu-bar. This minimizes the risk that the mouse inadvertently slips to the next menu group - maybe some other breakthrough GUI technology - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 59051] dimension arrows in a grou p from Oo.o draw pasted into Writer change siz e/position on save/reload
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59051 --- Additional comments from [EMAIL PROTECTED] Mon Jun 18 16:42:25 + 2007 --- The image shows the correct drawing after PASTE inside the writer document. When saving everything is still OK. The *preview* in Windows Explorer shows the correct drawing (see this on the TestCase attached). However, after reopening the writer document, the drawing is changed [simply open the .odt file and you will see the modified version; saving now the document will overwrite the original with the modified version]. So I presume that the open routine is broken. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 59051] dimension arrows in a grou p from Oo.o draw pasted into Writer change siz e/position on save/reload
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59051 --- Additional comments from [EMAIL PROTECTED] Mon Jun 18 16:38:56 + 2007 --- Created an attachment (id=46039) Simple Test Case - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 59051] dimension arrows in a grou p from Oo.o draw pasted into Writer change siz e/position on save/reload
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59051 --- Additional comments from [EMAIL PROTECTED] Mon Jun 18 16:38:02 + 2007 --- Created an attachment (id=46038) Simple Case Showing BUG - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 78596] Dimensions are not saved/l oaded correctly
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78596 User discoleo changed the following: What|Old value |New value CC|''|'od' --- Additional comments from [EMAIL PROTECTED] Mon Jun 18 16:15:58 + 2007 --- This seems a duplicate of issue 59051 (see http://www.openoffice.org/issues/show_bug.cgi?id=59051). Leo->OD Please have a look/close duplicate. As already posted for that issue, dimensions seem *to be saved correctly*. They are just NOT loaded correctly when opening the file again (input routine problem?). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78565] OOo unable to display spec ial character under Windows.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78565 --- Additional comments from [EMAIL PROTECTED] Sun Jun 17 10:09:19 + 2007 --- It is displayed correctly on my PC. I checked it with OOo 2.2.1 (en) on W2k SP4 (en-Version). Font is Wingdings. You should probably verify, that Wingdings is indeed installed on your machine. IF this is the case, probably verifying that the font is correct (i.e. it is NOT a bad font file), seems reasonable. What locales are your OOo and Windows installations? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 78524] Auto-capitalisation of let ter "i" hinders Automatic numbering
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78524 --- Additional comments from [EMAIL PROTECTED] Fri Jun 15 17:56:17 + 2007 --- > This side effects is not going to be fixed anytime soon. > My proposal is to remove issue 72912. Well, BUT "i" => "I" is needed in EVERY English document, while the usecase for "i.", "ii.", ... is much more rare. I definitely think that this issue MUST be fixed, but NOT by removing the previous issue. Maybe ADD on the menu-bar (of English OOo) a button to toggle this behaviour on/off? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Thu Jun 14 19:11:25 + 2007 --- Created an attachment (id=45943) Test Case with Comparative STABLE ALGORITHM - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Thu Jun 14 19:09:32 + 2007 --- The 2nd spreadsheet contains the calculations using a stable algorithm. You can test this algorithm for RSQ() and see how it behaves comparatively to the default implementation of RSQ(). Basically, the algorithm goes like this: 1.) N*sum(Xi^2) - (sum(Xi))^2 is replaced by: N * sum(Xi - Xm)^2, where Xm = the MEAN of X the N will cancel later, so I did NOT multiply with N 2.) N*sum(Xi*Yi) - (sum(Xi))*(sum(Yi)) is equivalent to: N*sum[(Xi-Xm)*(Yi-Ym)] 3.) dividing the previous 2 quantities and canceling N gives: b = sum[(Xi-Xm)*(Yi-Ym)]/sum(Xi-Xm)^2 4.) Ycalc-i = a + b * Xi adding every Ycalc gives: sum(Yc-i) = sum(a) + b*sum(Xi) however sum(Yc-i) = sum(Yi) = N*Ym, therefore N*Ym = N*a + N*b*Xm => canceling N Ym = a + b * Xm => a = Ym - b * Xm [I actually could mathematically show that *this is indeed TRUE*.] 5.) and final step, calculating R^2 first calculate: Yfirst = Yi - Ym Ysecond = Yi - Ycalc, then Yfirst - Ysecond, and Yfirst + Ysecond and finally: R^2 = (Yf - Ys)*(Yf + Ys)/((Yi - Ym)^2 As you can see, this algorithm works even for the very difficult test case I provided. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Fri Jun 8 23:27:02 + 2007 --- As these functions have been (obviously) fixed in recent versions of MS Office (I do NOT have access to those versions), I consider this: - a priority 2 issue - should be definitely fixed until OOo2.3 (preferably even faster, OOo2.2.1 ?) - at least a partial improvement Please note, with X = 90992, both RSQ() and CORREL() return 0!!! Actual values should be close to 1, respectively to -1. So, this value of '0' is plausible (aka possible), BUT definitely very wrong. There are many similar examples. Here another two obviously wrong examples, though the two x-values are almost identical, and yet the difference is extreme: XRSQ() CORREL() 91000.1149 196Err:503 91000.1150 -192Err:503 As pointed out, RSQ() can give only values between 0 AND +1. So, both values are wrong, and CORREL() fails altogether to compute. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Fri Jun 8 19:51:01 + 2007 --- You can change the values of 'X' in the Test-Case from 900,000,000 to other values to see how *erratically* the various functions change. Especially interesting values for 'X' are: 909,999,999.96 909,999,999.99 909,999,999.992 909,999,999.996 909,999,992 BUT you can indeed try every x.990 trough x.999. The results are really challenging. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 --- Additional comments from [EMAIL PROTECTED] Fri Jun 8 19:27:23 + 2007 --- Created an attachment (id=45768) Test Case for Unstable Algorithms - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78250] BROKEN Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250 Issue #|78250 Summary|BROKEN Functions Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Fri Jun 8 19:25:55 + 2007 --- UNSTABLE COMPUTER ALGORITHMS USED A. ERROR Various functions are affected, including: CORREL()-series RSQ(), and STEYX() As already pointed out on the dev-calc mailing list and the OASIS mailing list, various functions use an unstable algorithm: algorithms based on [n*sum(x[i]2) - sum(x[i])2] are inherently unstable I will attach a test-case, where: CORREL() computes an impossible value of -1.69 RSQ() computes an impossible value of 2.29, and STEYX() gives a '#VALUE!' ERROR Please note, that in these instances, through the mathematically impossible values, we are hinted that the calculation went very wrong. However, even *PLAUSIBLE* values can be completely erroneous!!! [And one has NOT the feedback that something went wrong!] Therefore I put a P2 priority. A. SOLUTION Use stable algorithms (as discussed on the lists). Classically, a two-pass algorithm will be stable, BUT there would be a time penalty (especially for RSQ(), where we need 3 passes!). Implement a fast version of the functions, like RSQFAST(), CORRELFAST(), ..., that use a fast and reliable (therefore more stable) *one-pass* algorithm. C. TEST CASE ATTACHED - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78181] Highlight Current Row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78181 --- Additional comments from [EMAIL PROTECTED] Thu Jun 7 19:29:02 + 2007 --- The Mozilla site seems to be non-responsive. But the OASIS site has an example, too (see http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula, though I like more the design from the Mozilla page). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78181] Highlight Current Row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78181 --- Additional comments from [EMAIL PROTECTED] Thu Jun 7 12:22:29 + 2007 --- Created an attachment (id=45729) Table Formatting in phpMyAdmin - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78181] Highlight Current Row
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78181 Issue #|78181 Summary|Highlight Current Row Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Thu Jun 7 12:21:27 + 2007 --- Various internet sites and web applications are using special highlighting for tables, making reading the information significantly more easier. Features: - alternating rows have slightly different backgrounds (2 types of gray) - row which has the focus is highlighted automatically using a 3rd color For some examples, see attached image (taken from phpMyAdmin, see on sourceforge.net), and various other sites, e.g. a very nice one on Mozilla (https://crash-reports.mozilla.com/reports/topcrasher/byversion/Firefox/3.0a5pre). This is something that really improves readability. Spreadsheet applications are really lagging behind with respect to user friendliness. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 78029] +glue +triangleDraw - glue points are incorrect for right triangle?
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78029 --- Additional comments from [EMAIL PROTECTED] Sat Jun 2 11:30:27 + 2007 --- Can confirm it on OOo 2.2 W2k SP4. Indeed, gluepoints are drawn incorrectly. (see previously attached picture) As a side note, searching for help on 'gluepoint' or 'gluepoints' in the OOo Draw help, does NOT retrieve any results. searching for 'glue point' retrieves an entry 'Gluepoints bar'. (Is this a windows issue?) Although the help does not state clearly how gluepoints are set, the way it is done is surely wrong. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 77973] A better way of treating n umbers/dates?!
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77973 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' --- Additional comments from [EMAIL PROTECTED] Fri Jun 1 05:38:45 + 2007 --- Well, I know from my own experience that date input is a pain in the ass. I therefore support any modifications that enhance this. > If date formatting was turned off by default, and you would have to choose > a date format for the cell/range of cells, before date information is inputed, > that would save some confusing I think. Indeed, I would like to have the option to turn automatic date recognition off. I often write both in Romanian, German and English, in various system locales, so the input gets almost always messed up. Even more troublesome is the date pattern, i.e. DD.MM.YY vs MM.DD.YY. I never use the MM.DD.YY, but OOo insists on this (because I have installed the English version, to avoid various other localisation problems). I would welcome a general setting, where one could opt for a standard date format, overriding system defaults and the like. Also, there should be an option to set the output format, IF COPY/PASTE or exporting to CVS files (or other formats). In summary, the 'date' needs some real cleanup. Building some sensible formatting options seems a good start. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 77963] Overlapping Histograms
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77963 Issue #|77963 Summary|Overlapping Histograms Component|Chart Version|OOo 2.2 Platform|All URL|http://rapid-i.com/images/stories/rapidi/yale/screensh |ots/screenshot14.gif OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|viewing Assigned to|kla Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Wed May 30 19:14:01 + 2007 --- One feature that I really miss are histograms (this is dealt in issue 49971, see http://www.openoffice.org/issues/show_bug.cgi?id=49971). An extension to the previous issue are overlapping histograms. These are especially helpful when studying multiple groups of data. One application field is in data mining. [Please note that data mining is extensively used by big corporations.] Overlapping histograms should allow *colour overlaying* to preserve visibility. This is best viewed in the following example: http://rapid-i.com/images/stories/rapidi/yale/screenshots/screenshot14.gif (see also the other examples on the site for various data-mining techniques). It would be surely useful to have the ability: - to plot multiple histograms (or other charts simultaneously) AND - have the ability to set various colour overlaying modes - add, XOR, ... - transparency, ... - IF ( overlap ) THEN slight shifting For other types of simultaneous plots, see also: http://addictedtor.free.fr/graphiques/RGraphGallery.php?graph=136 and various other examples on http://addictedtor.free.fr/graphiques/ . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 77481] Find and Search Function r eturn "#VALUE!" untestestable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77481 --- Additional comments from [EMAIL PROTECTED] Fri May 18 22:37:33 + 2007 --- This is a duplicate of issue 66590 (http://www.openoffice.org/issues/show_bug.cgi?id=66590). Please vote for that one, so that the proposed enhancement gets implemented. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 59453] warn before pasting into " too many" cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59453 --- Additional comments from [EMAIL PROTECTED] Tue May 15 20:51:16 + 2007 --- Crashing is definitely a BUG. However, what wonders me is that when I select everything (ctrl + A), Calc would select only the range A1:Y68 on an empty sheet, yet when I paste, it tries to paste well beyond this range. Actually, the range gets incremented over and over again. What is the limit? What should this "maximum range" be? I would opt for something like: 1.) either A1:Y68 as currently (or some other small value) 2.) in case of a non-empty cell: up to the last row/column that is non-empty 3.) open dialog box and ask user how many rows/columns should be filled I would strongly prefer options 2 and 3. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76575] Summary of Calc Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76575 --- Additional comments from [EMAIL PROTECTED] Sun May 6 20:47:31 + 2007 --- Created an attachment (id=44905) Updated List with OOo Calc Functions - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 4579] Special Character Shortcuts
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4579 --- Additional comments from [EMAIL PROTECTED] Sat May 5 19:59:12 + 2007 --- Nice thing to see at least a workaround. I append some language specific diacritics here, as I believe that it makes more sense to define them based on the language to use and the available keyboard to write (then have a big list with all the possibilities). See also http://www.umich.edu/~langres/diacritics/french.html for language-specific common diacritics. Characters suitable for replacement on an English keyboard: one keystroke (these are preferred): ` ' / \ two keystrokes (shift + ...): ~ : < > rather difficult to type: ^ German characters A Ää O Öö U Üü s ß Romanian characters A ĂăÂâ I Îî S Şş T Ţţ French characters A ÀàÂâÄä C Çç E ÈèÉéÊê I ÎîÏï O ÔôÖö U ÙùÛû ... By the way: # Is there any other word using 'ç', except for 'françai...'? # Is there any other word using 'ù' except for 'où'? ... Of course, most European languages use diacritics, so this list could be enhanced. (See also previous web-address for Italian, Portuguese, Spanish and Swedish.) Hungarian and Slavic languages are missing. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[ui-issues] [Issue 6847] provide a method to insert accented characters on English keybd
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=6847 --- Additional comments from [EMAIL PROTECTED] Thu May 3 20:16:05 + 2007 --- discoleo -> redi2go This issue is about extending *autocorrect*, so, my point is still valid. While autocorrect may have sometimes undesired efects, there are situations where I definitely prefer the autocorrect feature: e.g. when I am writing text in 2+ languages with different types of accents, where ANY logical key-combination is insufficient to write ALL special characters. [I do write such texts on a regular basis.] Indeed, IF I do NOT write in English (think of all Latin-languages, Slavik ones, and so on), you won't encounter the issue, so "a'" would be almost always a valid replacement (just NOT in English). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76874] Calc imports csv of +1MB o nly incomplete
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76874 --- Additional comments from [EMAIL PROTECTED] Thu May 3 18:38:43 + 2007 --- Created an attachment (id=44846) Simple GAWK-script to test CSV validity - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76874] Calc imports csv of +1MB o nly incomplete
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76874 --- Additional comments from [EMAIL PROTECTED] Thu May 3 18:35:25 + 2007 --- This is probably NOT valid CSV. The ERROR is probably invalid. For details about the CSV-format, see e.g. http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs (actually the wgole document is interesting). 1.) Fields that contain double quote characters must be surounded by double-quotes AND the embedded double-quotes MUST each be represented by a pair of consecutive double quotes - this csv-file contains lots of fields like the following one: ...;"some text"> more text"even more text";... those inner quotes are probably invalid 2.) Fields that contains embedded line-breaks must be surounded by double-quotes - this csv-file contains many lines that contain an ODD number of quotes, therefore, the filed DOES NOT end on that line, but would extend on the next line until an ending quote is reached!!! see e.g. line 184 in the original csv-file: - it contains 21 quotes I will append a simple gawk-script that can be used to detect lines with an ODD-number of quotes, therefore these are probably INVALID CSV-Files (IF one line is supposed to be equivalent to ONE record)! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[ui-issues] [Issue 6847] provide a method to insert accented characters on English keybd
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=6847 --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 14:26:26 + 2007 --- A more powerful approach to this issue is described in issue 67500. Indeed, such an *autoreplace* is a powerful way to automate various writing tasks. As described here (and in the issue 67500), the replacement list handles only full words, therefore this needs a workaround/ fix/ enhancement. A very useful consequence of this feature would be to solve (in one way) issue 4579. Suppose we add this to the replacement list: "a'" => "ä" Then "Gra'sser" becomes automatically "Grässer", NO need for special shortcuts. Of course, a complete solution would involve both this feature AND the shortcut version, BUT until shortcuts are implemented, this would be fine (and this would be useful even IF shortcuts were later implemented). How should this be implemented? 1. fast way: implement a second replacement list, where any occurrence of the specified combination would be replaced by the new string 2. more powerful: implement wildcards, as suggested for issue 67500 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 47681] same selection für output methods
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47681 --- Additional comments from [EMAIL PROTECTED] Thu Apr 26 18:15:25 + 2007 --- I discussed in issue 75493 (now closed) a method to enhance the printing / exporting to pdf of various spreadsheet documents. I will add those comments to this issue and also expand on some other related features. 1. SUPPRESS TRAILING EMPTY PAGES 2. TYPES OF EMPTY PAGES 3. IMPLEMENTATION 1. TRAILING EMPTY PAGES === When printing / exporting as pdf, I would like to suppress trailing empty pages. Trailing empty pages are empty pages at the *END of the document*, so they are almost always annoying. Please note, that this issue is *NOT trivial*. Unfortunately, when I export dozens of pages, I select to have the *page number* and the *total number of pages* in the footer. The total number of pages will count these empty pages, too. Therefore, even IF I manually select which pages to export to pdf, the *total number of pages* will include these empty pages. The workaround *define the print range* is really tedious for anything having more than just a few pages. IF this is an official document, then the total number of pages will point to non-existent pages, which will make Calc pretty useless in official settings. [Documents from governmental sources ALWAYS contain the total number of pages explicitly stated, so that, whatever page is available, the reader knows how many pages the document should have.] A checkbox with *Strip trailing empty pages* seems a really fine solution [this is NOT equivalent to 'Strip ALL empty pages']. 2. EMPTY PAGES == There are a number of types of empty pages: a.) There are pages that are completely empty, NO hidden cell content, NO EMPTY cells, NO formulas (evaluating to nothing), NO formatting, nothing. - e.g. when the text of row 1 extends beyond the width of one page, - YET rows 2- do NOT extend beyond the width of a page => row 1 will occupy page 1 and page n => rows 2-xxx pring on pages 1 through n-1 => pages n+1 to 2*(n-1) will be completely empty (just annoying footer and header) b.) Pages that contain formulas that evaluate to empty. - NO visible elements - yet cells are NOT empty (contain formulas OR references that evaluate to empty) c.) Pages that contain graphical formatting, yet contain NO other data. - e.g. contain various table borders set BUT NO elements [and neither images/charts] These are 3 common types of empty pages which should be possible to suppress *selectively*. [By combining the latter 2 varieties, a number of other possibilities arise.] 3. IMPLEMENTATION = This could be implemented in the following way: when Calc generates the page, it should set for every page the following properties: a.) does the page display any data (including charts)? b.) does the page display any graphical elements? [excluding proper/printable data] c.) does the page contain other elements (e.g. formulas)? SET GLOBALLY: d.) store last NON-EMPTY page IF a page contains (a.) then any previous EMPTY pages are NOT trailing pages; ANY page up to 'last NON-EMPTY page' is NOT a trailing empty page It would be really helpful to extend Calc to support all these features. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 72331] Wrong error indicator for standard deviation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72331 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44652) Confidence Interval | | vs Error Bars --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 19:42:09 + 2007 --- Created an attachment (id=44652) Confidence Interval vs Error Bars - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 72331] Wrong error indicator for standard deviation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72331 --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 19:41:02 + 2007 --- > In statistics, there is no use to display only one set of values. > The point is to compare several sets of data to visualize > the distribution graphically. Usually, we want to create some confidence interval (CI). The 95% CI is the most useful one. So creating 2 horizontal lines that delimit the 95% CI is the better approach. Of course, we could add a parameter to specify the size of the CI. Selecting 68% will generate the (-1 SD; +1 SD) interval that is so accustomed in the literature (the "error bars"), though dedicated statistician rarely use it. The http://addictedtor.free.fr/graphiques/RGraphGallery.php?graph=65 graphics display a very complex confidence interval. Of course, in our example, the lines delimiting the 95% CI would be horizontal (differing from the very complex lines in the previous graph). AND, because there are really lines drawn that look like grid lines, you could more easyly compare the distribution of the individual values. See my attached graphic. That's how I imagine it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 72331] Wrong error indicator for standard deviation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72331 --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 13:37:05 + 2007 --- In my opinion, both OOo and Excel perform a poor job here. Of course, in the given example, Excel is slightly better, BUT I would personally prefer the following method: - IF all the data points of ONLY one group of data are displayed (i.e. there is only one mean and one SD) - then allow user to select the confidence interval he wants e.g. CI95% (+/- 2 SD), (or 68% aka +/- 1 SD) - and draw the corresponding horizontal lines [Confidence intervals could be calculated using more robust methods, like bootstrapping sometime in the future.] This would look something like: http://addictedtor.free.fr/graphiques/RGraphGallery.php?graph=65 (well, NOT quite; it would look much more simple, with only 2 horizontal lines and a number of bars). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76577] Add SQL export
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76577
--- Additional comments from [EMAIL PROTECTED] Mon Apr 23 13:38:15 +
2007 ---
Well, I probably missed the point.
However, IF you only want to have a pseudo-csv output (with that additional
text), that is quite easy to obtain.
1. export everything you want as usual (as a csv text file with strings enclosed
by "'")
2. install awk/gawk (on Unix already available, on Windows, go to
http://www.sourceforge.net, search for the project Gnuwin32 -> it is free)
3. run the following gawk script
3.1. write this text into a new text file, e.g. "my.gawk.script.txt"
{
tmp = "insert into languages ('639-1','639-2T','639-2B','639-3','Name')"
tmp = tmp " values ("
tmp = tmp $0 ");"
print tmp > "my.new.modified.csv"
}
3.2. open the console window
3.3. type into the console: gawk -f"my.gawk.script.txt" "my.original.csv"
4. "my.new.modified.csv" will be the new, modified csv file
That's it.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 4921] Advanced statistics functio ns.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4921 --- Additional comments from [EMAIL PROTECTED] Sun Apr 22 20:28:43 + 2007 --- I have posted some sample C++ code above, implementing (partially) the one way ANOVA method. The Calc-ANOVA-No_ARRAY.cpp impelements the Calc functions that calculate the ANOVA. There are still some things to be done (like FDIST() to be called), but most of the code should be functional. The ANOVA.Test.Code.cpp contains the ANOVA code embedded in a testing framework, so that one can test code changes, without having to bother about OOo. It can be compiled with MS VC6.0, though I have NO idea, if other compilers (especially newer ones) would still compile it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 4921] Advanced statistics functio ns.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4921 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44596) Sample C++ Test Cod | |e for ANOVA function (comp | |iled with MS VC6) --- Additional comments from [EMAIL PROTECTED] Sun Apr 22 20:23:48 + 2007 --- Created an attachment (id=44596) Sample C++ Test Code for ANOVA function (compiled with MS VC6) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 4921] Advanced statistics functio ns.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4921 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44595) Partial Patch: ScAN | |OVA() C++ implementation --- Additional comments from [EMAIL PROTECTED] Sun Apr 22 20:17:32 + 2007 --- Created an attachment (id=44595) Partial Patch: ScANOVA() C++ implementation - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76577] Add SQL export
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76577 --- Additional comments from [EMAIL PROTECTED] Sun Apr 22 08:53:26 + 2007 --- I submitted an issue about SQL integration into the OOo Calc component. For a more extended discussion, see http://www.openoffice.org/issues/show_bug.cgi?id=66588. Although I do NOT know IF that one would help you, I nevertheless encourage you to take a look. Basically, that issue is about issuing SQL statements inside Calc on Calc Tables. I have NOT discussed the INSERT statement, because that gets slightly more complicated. Nevertheless, that could be extended sometime in the future (well, even the SELECT is NOT yet implemented in Calc). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76575] Summary of Calc Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76575 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44582) GAWK script to scan | | OOo code for Function Def | |initions --- Additional comments from [EMAIL PROTECTED] Sat Apr 21 16:28:19 + 2007 --- Created an attachment (id=44582) GAWK script to scan OOo code for Function Definitions - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76575] Summary of Calc Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76575 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44581) List describing the | | OOo Calc Functions --- Additional comments from [EMAIL PROTECTED] Sat Apr 21 16:27:17 + 2007 --- Created an attachment (id=44581) List describing the OOo Calc Functions - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76575] Summary of Calc Functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76575 Issue #|76575 Summary|Summary of Calc Functions Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P2 Subcomponent|programming Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Sat Apr 21 16:26:23 + 2007 --- This is a summary of Calc functions, including return value, parameters and source code module where they are defined. I decided to do this, because I did NOT find any useful information on many aspects of OOo code. Before the community can more effectively start working on the code, it is necessary to have a good documentation on this code, data types and functions. I miss this very much. As my time is very limited, I have NO time to struggle to find the information I am looking for. So this should be a central place where to find this information. Creating a new wiki page seems an alternative solution. The file "OOo.Calc.Fx.Names.ods" contains a table with all Calc functions defined in the files 'interpr1.cxx' through 'interpr6.cxx'. In the second table I have selected some of the functions that seem more relevant (this is NOT a full list). I have used a gawk script to scan the source files and retrieve this information (see attached OOo.Calc.Fx.Names.awk file for the script). Beyond this basic information, every function should be thoroughly documented. Some functions are self explanatory, but many are NOT. So, some help is needed to accomplish this task. Also, there are many *data types* that are used inside the code and which are not documented. Please consider contributing, IF you have some spare time and the necessary knowledge. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 76560] Numbered Lists: Numbering ERROR while COPYING
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76560 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44575) File showing BUG an | |d Description how to repro | |duce --- Additional comments from [EMAIL PROTECTED] Fri Apr 20 20:46:40 + 2007 --- Created an attachment (id=44575) File showing BUG and Description how to reproduce - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 76560] Numbered Lists: Numbering ERROR while COPYING
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76560 Issue #|76560 Summary|Numbered Lists: Numbering ERROR while COPYING Component|Word processor Version|OOo 2.2 Platform|All URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|mru Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Fri Apr 20 20:45:32 + 2007 --- Create a numbered list, e.g.: 'The LIST starts after this' <= COPY UP TO HERE 1. something 2. something: <= COPY FROM HERE UP TO (see above) 'Creating a new LIST through COPY/PASTE' <= PASTE HERE => RESULTS: 'Creating a new LIST through COPY/PASTE' 3. something second something <= ERROR: is NOT a list element See attached odt document for the example. NOW, delete both 'second something' and '3. something', and write instead: 1. here should start a new list <= PRESS ENTER AFTER THIS RESULTS: 'here should start a new list' 1. <= THIS IS EMPTY and the text is above, without NUMBERING - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 52077] Word count
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52077 --- Additional comments from [EMAIL PROTECTED] Fri Apr 6 18:20:05 + 2007 --- This issue depends on issue 76156 (Counting the number of substrings within a string). I have attached a C++ code for that issue, unfortunately that code does NOT cover regular expressions. For the full implementation of this issue, I will first need to add that functionality to the above mentioned issue, though I fear that I do NOT really understand how the REGEXP search is implemented and there is NO good documentation for it (see my comments to that issue). When that is done, I will return to this issue. Somebody please add that this issue depends on issue 76156. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76156] Counting number of substri ngs within a string
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76156
--- Additional comments from [EMAIL PROTECTED] Fri Apr 6 18:12:26 +
2007 ---
1. I just wanted to add a real life example.
My primary work involves auditing the whole medical activity taking place in a
big county. One frequent task is to count the number of different diagnoses for
individual patients.
The string looks like this: "B18.1; G20; I20.9; I12.9". These tokens represent
individual ICD10-coded diagnoses. So, I would like to count how many diagnoses
are there (i.e. FindCount(";",'the_string') + 1).
2. I found the code for *REGEXP* searches inside the ScInterpreter::ScSearch()
function. Unfortunately, I do NOT understand much of it and I fear that there is
NO good documentation on it.
I will try to implement a ScSearchCount() function later, just by cloning the
ScSearch() function.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76156] Counting number of substri ngs within a string
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76156 User discoleo changed the following: What|Old value |New value Issue type|DEFECT|FEATURE OS/Version|Windows 2000 |All - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76156] Counting number of substri ngs within a string
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76156 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44257) Proposed C++ implem | |entation --- Additional comments from [EMAIL PROTECTED] Fri Apr 6 16:58:00 + 2007 --- Created an attachment (id=44257) Proposed C++ implementation - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 76156] Counting number of substri ngs within a string
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76156 Issue #|76156 Summary|Counting number of substrings within a string Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Fri Apr 6 16:56:18 + 2007 --- Unfortunately, Calc lacks even basic support for string functions (see my other issues on strings, like issue 66590). This makes the program unsuitable for any work that relies heavily on strings. One of the functionalities that I am missing is a function that counts the number of occurrences of a substring within a given string. Lets say, we have the string: "ab cd ab de", and we want to count how often "ab" occurs inside this string. I have included in the attached file the C++ code for a new function, ScInterpreter::ScFindCount(), that performs this task. This function counts the number of occurences of a given string within another string // - IF string is NOT found, it returns 0 // - otherwise it returns the number of occurences of the substring // - parameters: // 1. string: this is the search item // 2. string: this will be searched for the first string // 3. is overalpping of search results allowed: //- default: FALSE (NO) // 4. START position: default = begining of string (=1) // 5. END position: default = LEN(string) I noticed now, that the function will probably NOT recognise wildcards, so I will look forward to correct that. I hope that such a function will make it in the OpenFormula specification, too. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 66590] OOo-Calc String Function: Find
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 --- Additional comments from [EMAIL PROTECTED] Thu Apr 5 20:58:09 + 2007 --- The patch implements a more advanced FIND() function with the following characteristics: DESCRIPTION - string starts at position 1 - ends at =LEN(string) 1. IF string is NOT found, it returns 0 instead of an ERROR, therefore greatly simplifying complex operations with strings! 2. one can explicitly specify the START position within the string - IF START < 1, it automatically sets the START = 1 3. one can explicitly specify the END position within the string - IF END > LEN(string), it automatically sets END = LEN(string) 4. IF( START > END), it returns 0 By defining a START and END position, searching inside strings is greatly simplified. There is NO need to first compute a substring; rather it is possible to specify the substring directly inside the FindEx() function. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 66590] OOo-Calc String Function: Find
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44238) Patch Implementing | |an ScFindEx() function --- Additional comments from [EMAIL PROTECTED] Thu Apr 5 20:47:42 + 2007 --- Created an attachment (id=44238) Patch Implementing an ScFindEx() function - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75987] regular expression in calc formula
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75987
--- Additional comments from [EMAIL PROTECTED] Tue Apr 3 21:26:41 +
2007 ---
I believe that {=SUM(A1:A200="S")*1} or =ISNUMBER(FIND("S";A1) are NOT a real
solution. They will hardly allow a more complex search.
That said, in what module is COUNTIF() defined?
It would be easy to implement a case-sensitive COUNTIFC(), so NO
Excel-compatibility problem.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 1034] Selecting the language for spell check should be more intuitive
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1034 --- Additional comments from [EMAIL PROTECTED] Tue Apr 3 20:50:03 + 2007 --- There is another important fact to consider when dealing with languages. Although I speak fluently 4 languages (and some others less fluently), when I write a document, I use at most 3 different languages. I believe, that users that will use more than 4 languages simultaneously are the absolute exception. Therefore, I propose to add an option to define "Used Languages" in a document. This will facilitate: - automatic language detection (see also my comments for issue 1035) - possibility to easily and rapidly switch between a very limited number of languages, instead of having to choose between a list of hundred languages ( - also, less crowded menu/status bar, IF only 2-3 languages will be displayed/listed) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[www-issues] [Issue 1034] Selecting the language for spell check should be more intuitive
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1034 --- Additional comments from [EMAIL PROTECTED] Tue Apr 3 20:50:03 + 2007 --- There is another important fact to consider when dealing with languages. Although I speak fluently 4 languages (and some others less fluently), when I write a document, I use at most 3 different languages. I believe, that users that will use more than 4 languages simultaneously are the absolute exception. Therefore, I propose to add an option to define "Used Languages" in a document. This will facilitate: - automatic language detection (see also my comments for issue 1035) - possibility to easily and rapidly switch between a very limited number of languages, instead of having to choose between a list of hundred languages ( - also, less crowded menu/status bar, IF only 2-3 languages will be displayed/listed) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75493] Suppress Printing/Exportin g of TRAILING Empty Pages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75493 --- Additional comments from [EMAIL PROTECTED] Tue Mar 27 20:04:23 + 2007 --- > Just define the print range. Thanks for the hint. Indeed, it is possible to solve the problem, though I needed some 3-4 minutes to select the relevant pages for the test document (only 3 pages from 4). Working with bigger documents will be surely more difficult. An option like *Strip Trailing Pages* comes really handy. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 75725] Chart2: Dot Plots
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75725 Issue #|75725 Summary|Chart2: Dot Plots Component|Chart Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|code Assigned to|kla Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Sun Mar 25 16:51:53 + 2007 --- OOo lacks currently the ability to draw *Dot Plots*, which makes professionally looking graphs more difficult to create. A *Dot Plot* is a superior alternative to the *Bar Plot*. For an extended discussion see http://www.b-eye-network.com/newsletters/ben/2468. ADVANTAGES: - less cluttered - better view of the data - great advantages when depicting *multiple groups of data* - better view for *Non-zero baseline* - *labeling* advantage when compared to the classic vertical bars of bar-charts See the pictures on the site and judge yourself (especially figures 4, and 5 and 6 are interesting). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75493] Suppress Printing/Exportin g of TRAILING Empty Pages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75493 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43782) Original Calc Sheet | | used to export to pdf --- Additional comments from [EMAIL PROTECTED] Sat Mar 17 22:34:04 + 2007 --- Created an attachment (id=43782) Original Calc Sheet used to export to pdf - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75493] Suppress Printing/Exportin g of TRAILING Empty Pages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75493 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43781) Actual Result of Ex | |porting to PDF --- Additional comments from [EMAIL PROTECTED] Sat Mar 17 22:32:56 + 2007 --- Created an attachment (id=43781) Actual Result of Exporting to PDF - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75493] Suppress Printing/Exportin g of TRAILING Empty Pages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75493 Issue #|75493 Summary|Suppress Printing/Exporting of TRAILING Empty Pages Component|Spreadsheet Version|OOo 2.1 Platform|All URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|printing Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Sat Mar 17 22:30:15 + 2007 --- This is an extension / customization of issue 36096 (http://www.openoffice.org/issues/show_bug.cgi?id=36096). APPLIES TO: - Printing a Worksheet - Exporting as PDF When printing / exporting as pdf, I would like to suppress trailing empty pages. Trailing empty pages are empty pages at the *END of the document*, so they are almost always annoying. Please note, that this issue is NOT trivial. Unfortunately, when I export dozens of pages, I select to have the *page number* and the *total number of pages* in the footer. Unfortunately, the total number of pages will count these empty pages, too. Therefore, even IF I manually select which pages to export to pdf, the *total number of pages* will include these empty pages. IF this is an official document, then the total number of pages will point to non-existent pages, which will make Calc pretty useless in official settings. [Documents from governmental sources ALWAYS contain the total number of pages explicitly stated, so that, whatever page is available, the reader knows how many pages the document should have.] I will attach such a PDF-document and the corresponding Calc document from which the document was created. The last page is empty (excluding the header and footer), therefore I would have welcomed a way to: - suppress the printing / exporting of this last page - calculate the total number of pages without these empty page Tested with OOo 2.1, W2k SP4. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 75468] PDf Printing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75468 --- Additional comments from [EMAIL PROTECTED] Sat Mar 17 14:22:06 + 2007 --- In the PDF-Dialog Box, you can select in the tab 'General'->'Range': = 'Selection', and only the current worksheet is exported. Though I agree, the name is NOT very informative. Maybe the following label would be better: "Current Worksheet / Selection", or add a separate option "Current Worksheet". - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 7019] more pretty default colors
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=7019 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43519) EXAMPLES of Colour | |Schemes --- Additional comments from [EMAIL PROTECTED] Sun Mar 4 22:01:59 + 2007 --- Created an attachment (id=43519) EXAMPLES of Colour Schemes - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 7019] more pretty default colors
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=7019 User discoleo changed the following: What|Old value |New value CC|'bm,gleppert,joergwartenbe|'bm,discoleo,gleppert,joer |rg,mox,nmailhot,pagalmes,p|gwartenberg,mox,nmailhot,p |mike,tonygalmiche'|agalmes,pmike,tonygalmiche | |' --- Additional comments from [EMAIL PROTECTED] Sun Mar 4 21:29:47 + 2007 --- *CHART2: Default Colours* "Color used well can enhance and clarify a presentation. Color used poorly will obscure, muddle and confuse.* -- Maureen Stone Unfortunately, people have difficulty learning this simple fact. I just voted for the new default pallet to be used in Chart2, yet I was NOT very impressed by the various pallets. The last colour scheme (number 12, blue - yellow) is probably the better one, but even this one lacks professionalism. *What is the problem*? As the first quote from Maureen Stone says, *too many colors* will obscure and confuse. Therefore I will try to expand this concept further and add some real-life examples from professional presentations. A few remarks are needed before expanding this issue: 1.) EXAMPLES I will add some examples as jpg-images to better show the reasoning for the colours. I attach some professional charts taken from the WHO 2005 and 2006 reports. The full reports (some 5 - 7 MB) can be downloaded from http://www.who.int/entity/whr/2005/whr2005_en.pdf and http://www.who.int/whr/2006/whr06_en.pdf (while for older reports see http://www.who.int/whr/previous/en/index.html). Please take a look at these charts, they look really good. 2.) BLACK-WHITE === Sometimes, charts get printed on black-white printers, or colour presentations are copied on a black-white photocopying machine (quite often). Many colour-schemes fail poorly in this instance due to poor contrast/luminosity difference between 2 neighboring fields. 3.) PREVIOUSLY e-MAILED === 2.) I e-mailed a similar post to the chart mailing list. However, presumably because I appended some jpg-images, the post never showed up. 2'.) I sent a similar e-mail (with jpg-attachements) directly to people working for Sun (e.g. to Ingrid Halama), but got NO response either, so it was presumably deleted as well. 2''.) this is my third attempt and I will post it as a comment to issue 7019 (http://www.openoffice.org/issues/show_bug.cgi?id=7019). I will attach the beforementioned jpg-images to that issue, too. This is a greatly expanded review. 3.) TOC === This document will be organised as follows: a. INTRODUCTION b. BAR CHARTS b'. 2-3 Colours b''. MONOCHROME MODEL c. PIE CHARTS and other Chart Types d. DEFAULT EXAMPLES a. INTRODUCTION === Colours used in a chart should clarify the chart and NOT confuse the viewer. Unfortunately, this is difficult when choosing many colours as they 1.) tend to distract the viewer from the relevant information and 2.) obscure some of the colours used. This is the reason why professional presentations never use more than 5 different colour groups (hue-groups). Actually, IF more groups seem to be needed, there are 2 ways to resolve this issue: - either the user does NOT recognise the essentials in the chart (to *highlight only the essential information*), or - (IF – rarely – the previous statement does NOT apply) use basically a *single hue-group* This will be further expanded for BAR-Charts and separately for the OTHER-Chart types. b. BAR CHARTS = Bar charts are likely to contain many groups of data. A common mistake is to draw every BAR a different colour. This is both unnecessary and obstructs the meaning of the bar chart. A good colour-scheme will have to distinguish between: B1. are there only 2 groups of data: then use of 2 oppsoing colours (significantly different hues) is OK. Also, make the luminosity different, so that black-white printing looks good, too. B2. are there 3-5 groups of data: selecting 3 to 5 different colours is feasible, BUT alternatives using only 1-2 colours are equally effective. B3. more than 5 bars: NEVER use more than 5 colour-groups!!! To quote Maureen Stone again: "In most design situations, the best results are achieved by limiting hue to a palette of two or three colors, and using hue and chroma variations within these hues to create distinguishably different colors. Such a palette is both aesthetically pleasing and functional. It minimizes an over-dependence on hue variation (which can cause visual clutter), and replaces it with care
[sw-issues] [Issue 56449] Find&Replace in selection replaces whole selection with replacement stri ng
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56449 User discoleo changed the following: What|Old value |New value CC|''|'discoleo' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74782] Cannot calculate a negativ e cube root
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74782 --- Additional comments from [EMAIL PROTECTED] Thu Feb 22 18:27:16 + 2007 --- Can confirm it on OOo 2.1 W2k SP4: =POWER(-27, 1/3) returns #VALUE! in OOo 2.1 #NUM! in gnumeric 1.7.6 "-3" in MS Excel XP => TRUE Seems, a lot of software gets it wrong, though Excel manages to calculate it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 74707] Replace inside Selection B roken
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74707 --- Additional comments from [EMAIL PROTECTED] Tue Feb 20 21:03:53 + 2007 --- This is actually an extension to bug http://www.openoffice.org/issues/show_bug.cgi?id=56449 Please note, that not only tables are affected, BUT rather everything inside a Writer document. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 74707] Replace inside Selection B roken
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74707 Issue #|74707 Summary|Replace inside Selection Broken Component|Word processor Version|OOo 2.1 Platform|All URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|mru Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Tue Feb 20 20:23:18 + 2007 --- Replace inside a Selection *deletes* the WHOLE selection. STEPS TO REPRODUCE == 1. create a new document (empty) 2. write something, e.g. "A long, long time ago, " 3. select this text 4. Menu -> Edit -> Find & Replace 5. Search For: "," 6. Replace by: "." 7. More Options -> Current Selection Only 8. Click Replace Voila, the whole selection is gone and the ERROR appears: "Search key not found." Expected Results "A long. long time ago. " Actual Results: "." The selection should NOT be deleted. This breaks the whole Replace method. Tested with OOo 2.1 on W2k SP4. Reproducible: always (and any char, NOT just "," and ".") Broken in Tables, too! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74625 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43170) Test Case for 2nd E | |rror and LOOKUP errors --- Additional comments from [EMAIL PROTECTED] Mon Feb 19 18:20:39 + 2007 --- Created an attachment (id=43170) Test Case for 2nd Error and LOOKUP errors - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74625
--- Additional comments from [EMAIL PROTECTED] Mon Feb 19 18:19:27 +
2007 ---
1. Well, it is good to know that the work has started. Though, I cannot agree,
that when moving data around, there should be NO warning IF something messy will
happen.
Maybe ERROR is to much, BUT at least a warning message that some formulas could
get broken. Calc does NOT do really nasty things (as breaking the matrix into
non-contiguous matrices), BUT the formulas are still broken.
I will attach a *Test Sheet* demonstrating this behavior. Perform the steps as
described in the sheet 'Initial'. After Cut/Transpose/Paste, the formula inside
A19 is NOT updated. This is BETTER so, BUT the user has NO clue that this
*formula is probably wrong.*
2. LOOKUP
==
Well, this is another problem.
Lets say we have the following formula:
= VLOOKUP('a_cell_NOT_really_important'; A1:B10; 2)
and we cut/transpose/paste A1:B10 (pasting into A1 for convenience, BUT because
of previous error I used a different cell inside the test sheet);
The new range becomes A1:J2. The problem is, VLOOKUP() searched inside A1:A10
for first value, and NOW it searches inside A1:A2, because it is still
VLOOKUP(). Something very wrong has happened. It should search inside A1:J1, BUT
this is a horizontal search AND NOT a vertical one, so HLOOKUP() should be used.
So, while Calc updates the formula, this becomes a total MESS. LOOKUP()
functions won't be able to search anymore, BECAUSE the range was TRANSPOSED, BUT
the range is NOT suited for the corresponding LOOKUP. By virtue of the
*transposition*, what was vertical becomes horizontal AND what was horizontal
becomes vertical.
This error applies ALWAYS (always reproducible) when the transposed range is the
2nd argument of the LOOKUP function!
So, my belief is that a correct formula update should update the function, too.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 74512] Logarithmic Scale: Default Value vs Log
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74512 --- Additional comments from [EMAIL PROTECTED] Sun Feb 18 21:21:30 + 2007 --- I have added 2 picture from an article published in the journal "Nature" depicting this feature. As stated, this option is often used in academic publishing when dealing with: - large variations in the scale - need to point out the difference between two values When wanting to point out the difference between 2 values, the logarithm is much more useful, because we will have the difference expressed as 1 point, 2 points or the like (and NOT absolute differences of e.g. 560,000 vs 7,002,500; in this case the log difference is 1.09, i.e. 5.75 vs 6.85). One particular field where this is useful is in virology, where viral load is more accurately represented by the log value: e.g. when measuring the effectiveness of HIV treatment, we measure the viral load, BUT more important we need to know the variation in the viral load, and here the logarithm is more easy to interpret. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 74512] Logarithmic Scale: Default Value vs Log
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74512 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43137) Chart Example using | | this Feature (II) --- Additional comments from [EMAIL PROTECTED] Sun Feb 18 21:13:09 + 2007 --- Created an attachment (id=43137) Chart Example using this Feature (II) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 74512] Logarithmic Scale: Default Value vs Log
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74512 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43136) Chart Example using | | this Feature --- Additional comments from [EMAIL PROTECTED] Sun Feb 18 21:12:24 + 2007 --- Created an attachment (id=43136) Chart Example using this Feature - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74625
--- Additional comments from [EMAIL PROTECTED] Sun Feb 18 20:57:06 +
2007 ---
I have attached a sample Test-Sheet that demonstrates the ERROR.
The first sheet called "Description" has the data before the copy/transpose/past
operation. Just select the "A2:B6" range as described on the sheet, CUT and
"Paste special" using transpose inside the cell A2. The results will look as in
the 2nd sheet ("Results"), where in the cell A3 (former B2) is an ERROR.
A3: (former B2):
instead of the formula "=A2 * 2", the updated formula looks like "=#REF!2 *
2"!!!
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74625 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |43134) Test Sheet Demonstr | |ating ERROR --- Additional comments from [EMAIL PROTECTED] Sun Feb 18 20:52:33 + 2007 --- Created an attachment (id=43134) Test Sheet Demonstrating ERROR - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74625 --- Additional comments from [EMAIL PROTECTED] Sat Feb 17 15:57:08 + 2007 --- I introduced an error in the *STEPS TO REPRODUCE* a. STEPS TO REPRODUCE: == 1. create a spreadsheet: A2: = 1 ; B2: = A2 * 2 A3: = 2 ; B3: = A3 * 2 ... A6: = 5 ; B6: = A6 * 2 write in B[i] = A[i] * 2 , NOT B[i] * 2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 74625] Calc: Transposition: Formu la Error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74625
Issue #|74625
Summary|Calc: Transposition: Formula Error
Component|Spreadsheet
Version|OOo 2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|discoleo
--- Additional comments from [EMAIL PROTECTED] Sat Feb 17 15:54:22 +
2007 ---
This deals with an ERROR in the *automatic Formula Update* when transposing a
selection in Calc.
1. ERROR in Referenced Cells: wrong formula update
2. VLOOKUP and HLOOKUP are NOT updated
1. Wrong Formula Update:
This happens when pasting a transposed selection containing formulas over the
same location.
a. STEPS TO REPRODUCE:
==
1. create a spreadsheet:
A2: = 1 ; B2: = B2 * 2
A3: = 2 ; B3: = B3 * 2
...
A6: = 5 ; B6: = B6 * 2
2. Select A2:B6
3. CUT the selection
NOTE: the selection is cut away,
so NOTHING is displayed in A2:B6,
giving the false impression that
PASTing here is unproblematic
4. CLICK on A2
5. PASTE special; check the 'TRANSPOSE' checkbox
6. new data is in A2:E3
7. the cell A3 displays an ERROR: '#REF!'
The content in this cell is "=#REF!2*2". It should have been "=A2 * 2". All
other formulas in the other cells are updated correctly.
I do NOT know how exactly the formula update mechanism operates, BUT this should
be pretty simple and could be viewed as an affine transform.
b. CORRECT FORMULA UPDATE
==
Lets say the initial data is in [CbRb; CeRe], where C stands for "Column" and R
for "Row". b = begin (first element); e = end (last element);
Transposing this selection and pasting it to C'[0]R'[0] will yield this:
the new data matrix will be:
" C'[0]R'[0]" - first cell
"(C'[0]+Ce-Cb)(R'[0]+Re-Rb)" - last cell,
where C'[0] is the number of the (first) column and
R'[0] is the number of the (first) row where the data is pasted;
For an arbitrary initial cell (Ci and Rj), the new values will be:
C'[i] = C'[0] + R[j] - Rb
R'[j] = R'[0] + C[i] - Cb
c. SPECIAL CONDITIONS
==
IF one cell contains a formula referencing a selection/ matrix that OVERLAPS the
transposed selection, BUT extends beyond its boundaries, then an ERROR should be
generated. The transposition would split the initial matrix into a number of
NON-contiguous matrices and the user probably did NOT want this.
In pseudocode, this would look like:
[CbRb, CeRe] - initial matrix before transposition
[CiRi, CjRj] - referenced matrix inside the formula
code to update formula and detect error:
IF((Ci <= Ce) && (Cj >= Cb) && (Ri <= Re) && (Rj >= Rb)) {
// THIS MATRIX CONTAINS ELEMENTS FROM THE MATRIX
// THAT WILL BE TRANSPOSED, SO IT MUST BE UPDATED
IF((Ci < Cb) || (Cj > Ce) || (Ri < Rb) || (Rj > Re)) {
// THE MATRIX EXTENDS BEYOND BOUNDARIES
// OF TRANSPOSED MATRIX => ERROR
// THE INITIAL MATRIX WOULD BE SPLIT INTO
// AT LEAST 2 NON-CONTIGUOUS MATRICES
SET_ERROR("MATRIX OVERLAP");
}
ELSE {
// UPDATE FORMULA
C'i = C'[0] + Ri - Rb // FIRST ELEMENT
R'i = R'[0] + Ci - Cb
C'j = C'[0] + Rj - Rb // LAST ELEMENT
R'j = R'[0] + Cj - Cb
_SPECIAL_UPDATE(); // SEE POINT 2: LOOKUP
}
}
2. UPDATING LOOKUP
===
When transposing a matrix, any LOOKUP function that references that matrix
should be updated.
VLOOKUP() should become HLOOKUP(), and
HLOOKUP() should become VLOOKUP()
[only IF 2nd argument references the transposed matrix]
In pseudocode, this would look like:
function _SPECIAL_UPDATE() {
IF(_IS_ARGUMENT_OF_FUNCTION) {
IF(_IS_FUNCTION(VLOOKUP) && _IS_2nd_ARG) {
function = HLOOKUP;
}
ELSE IF(_IS_FUNCTION(HLOOKUP) && _IS_2nd_ARG) {
function = VLOOKUP;
}
}
}
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 74512] Chart2: Logarithmic Scale: Default Value vs Log
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74512 Issue #|74512 Summary|Chart2: Logarithmic Scale: Default Value vs Log Component|Chart Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|code Assigned to|kla Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Tue Feb 13 22:08:35 + 2007 --- *Logarithmic Scale* - Display Original Values or the Logarithm Thereof TARGET == Chart2 Reimplementation This feature request should be integrated into the "Scales and Intervals Specification" (http://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt) DESCRIPTION === When using the logarithmic scale, most often one wishes to display the original values. However, there are situations when the logarithm is more useful. REASON == The logarithmic scale is sometimes used to display wide variations in the values to be displayed. Such variations may be wide enough to preclude efficient annotation of the graph. Therefore, the logarithm thereof may be more suitable. E.g., instead of 1 to 1,000,000,000 one may use 0 to 9. Sometimes, one wishes to highlight the change in the value, so the logarithm is more useful (a difference of 1 logarithm step means a change by a factor 10). This is especially useful in virology (viral load) and in serology (log2). Some adimensional data or data with non-relevant dimensions may be better represented by the logarithm, then by the original value. See also e.g. the following free articles where such graphs occur: http://www.nature.com/hdy/journal/v93/n6/pdf/6800559a.pdf and http://www.jneurosci.org/cgi/reprint/25/43/10049 . IMPELEMNTATION == 1. checkbox: display original value (checked by default) 2. checkbox: display the log - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[graphics-issues] [Issue 74509] Chart2: Logarithmic Scale, various bases for LOG
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74509 Issue #|74509 Summary|Chart2: Logarithmic Scale, various bases for LOG Component|Chart Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|code Assigned to|kla Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Tue Feb 13 20:59:33 + 2007 --- *Logarithmic Scale* - Different Bases TARGET == Chart2 Reimplementation This feature request should be integrated into the "Scales and Intervals Specification" (http://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt) When using a logarithmic scale, the logarithm base is usually 10. Most of the time this is indeed the way it should be, because at a log step of 1, the data changes by a factor of 10. (=> therefore easy visualisation) However, there are some situations where a different base for the logarithm is needed. EXAMPLE === When working with audio frequencies, the frequency often doubles. To accommodate this, the base of the logarithm must be 2. One common example is that of an audiogram. The frequencies recorded are usually: 125 Hz, 250 Hz, 500 Hz, 1000 Hz, 2000 Hz, 4000 Hz and 8000 Hz. For an example of an audiogram see http://www.sfu.ca/sonic-studio/handbook/Audiogram.html . Please note, that both the x-axis and the y-axis of the audiogram are logarithmic. Log2 is also often used in computer sciences, see e.g. http://logbase2.blogspot.com/2005/12/double-double-toil-and-trouble.html (the graphic on blogging) and in other branches, where doubling time is relevant (e.g. pharmacodynamics, epidemiology). Some other bases might also be useful, like e (=2.72...). REQUIREMENTS 1. ability to choose the base of the logarithmic scale 2. DEFAULT: checkbox with base 10 (this is the most useful, therefore checked by default) 3. base 2 (checkbox unchecked) 4. natural logarithm (base e, checkbox unchecked) 5. custom value: field to type a number ( greater then 1; I believe numbers between (0,1) are very rarely used, IF at all) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 66735] amend brackets for inputs starting with number with algebraic sign
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66735 --- Additional comments from [EMAIL PROTECTED] Thu Nov 9 03:20:06 -0800 2006 --- I was told the results for *Mathematica* (v5.(x)): It is as expected: -4^2 = -16 !!! Mathematica is a reference program in mathematics, so this should be viewed as written by the almighty. I do not have access to mathematica myself, but I am confident that the person I asked, actually tested this (and did NOT tell me what he thinks is correct). As noted in a previous post, other mathematical software (like Scilab, maxima, octave, R) interpret it the same way. As I mentioned, you do *NOT* have an "inverse sign" operator in mathematics. "-" is only the substraction. IF you want to specify the number "-4" you have to type "(-4)" BASTA. Why does gnumeric interpet it differently? Interesting question and I believe the answer is as follows: # -4^2 = -16 AND NOT +16, which is wrong # BUT many spreadsheet users were used to get +16 in Excel, # so gnumeric let those users calculate what they expected, # BUT changed the syntax to be correct, so people NOT accustomed to this BUG would know (and see) that it is NOT what they expect So, I can only recommend that Calc adopts this same strategy. This way, professionals can live with this bug, because Calc would tell them: > when people who use this spreadsheet write =-4^2 > they usually mean =(-4)^2; so does Calc. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 66344] Title Case and More Advanc ed Casing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66344 --- Additional comments from [EMAIL PROTECTED] Thu Nov 2 01:59:41 -0800 2006 --- discoleo->fl CUSTOM CASE: - a title taken from the net: "High Prevalence of Ceftazidime-Resistant Klebsiella pneumoniae and Increase of Imipenem-Resistant Pseudomonas aeruginosa and Acinetobacter spp. in Korea: a KONSAR Program in 2004" (see http://www.eymj.org/2006/pdf/10634.pdf, but actually many journal articles in English have their title formatted similarly) - lower case words: of, and, in - uppercase: most other words - special lower case: bacterial names - second word is lowercase -- Acinetobacter spp. (here "." does NOT start another sentence, too) -- Pseudomonas aeruginosa My casing functions do not handle this one, and I believe it is far to complex (and language dependent) to implement right now. BUT someone may write later a great plugin to just do that and it would be nice to already have the mechanisms in place to use with the general case formatter (and do NOT have to hack afterwards). While it is this feature I would like most (beyond the customizability of the Case Formatter as implemented in my proof of concept program), this is far too complex even for me, to devise a (simple) solution. Too many exceptions, too many special conditions make it a tuff algorithm. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 66344] Title Case and More Advanc ed Casing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66344 --- Additional comments from [EMAIL PROTECTED] Mon Oct 30 02:50:53 -0800 2006 --- discoleo->fme [QUOTE] > One question: I had a first glance at your spec draft > and saw that e.g., 'word start' and 'sentence start' > should be user-definable. Why don't we just use the > functionality provided by our i18n module, there are > already functions like 'isBeginWord' and 'startOfSentence'. > I guess this would work fine in most cases. While this is true in many cases, there are two (common) situation, where this will probably fail. 1. Some users may wish to case some text containing abbreviations, e.g.: - "This is e.g. an abbr. text" => we don't want the "an" and "text" to behave like starting a new sentence 2. In some languages, a new sentence may start with a more specialized syntax: - dialogues in Romanian: "- This is a dialogue." - questions in Spanish: "?Should that be an inverted questionmark?" There might be other situations where a user wishes that the sentence markers are interpreted differently in his text and this customizing ability gives the greatest flexibility. Everything is about having different choices for greatest flexibility. But again, if there is no time to implement this, than I can live with the provided functions (although with my solution, the code would be only minimally more complex). The second important point, I am NOT a programmer, it only happens that I know some C++. And my problem is, that I have absolute no idea of OOo internals and no time to learn it (by the way, I am also involved with 3 non-writer projects). BUT issue 1601 is 5 years old and I would be very grateful if a developer takes one or two afternoons and implements this. There were 15 votes for the issue (and a number of dupes). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 66344] Title Case and More Advanc ed Casing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66344 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |40147) An alpha version of | | the Custom Casing Specifi | |cation --- Additional comments from [EMAIL PROTECTED] Sun Oct 29 13:13:19 -0700 2006 --- Created an attachment (id=40147) An alpha version of the Custom Casing Specification - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 66344] Title Case and More Advanc ed Casing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66344 --- Additional comments from [EMAIL PROTECTED] Sun Oct 29 13:08:34 -0700 2006 --- [QUOTE] > SBA-> discoleo: About unwanted capitalisation, see > http://oooauthors.org/en/FAQs/Writer/Automatisms/025 This does NOT really apply here, because the end user is left to choose what gets capitalised and how precisely it gets capitalised. So it's up to the user to choose whatever suits him best. I begun writing a specification, though I do not know many things. Also, the code I posted is only a proof of concept. It should be adapted (and improved) accordingly. Summary of Specification: Abstract Users wish more advanced casing options beyond the ordinary upper case and lower case. This specification will present an advanced method of custom casing. Users will be allowed to select (1) separate and independent casing methods for (a) the letter starting a sentence, (b) starting a word and (c) all other letters. (2) Valid casing options for the previous 3 groups of letters include (a) leave case unchanged, (b) make upper case, (c) lower case, (d) toggle case and possibly (e) other custom casing functions. (3) Users are also allowed to customize (a) the detection of a new sentence, (b) of a word, (c) various special characters propagating or (d) blocking a new sentence/ word, and (e) special characters allowing propagation of a start new word when at the beginning of a word but not inducing a new word if positioned in the middle of a word. I also begun to draft the detailed specification and will append the alpha-version here. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 59051] dimension arrows in a grou p from Oo.o draw pasted into Writer change siz e/position on save/reload
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59051 --- Additional comments from [EMAIL PROTECTED] Sat Oct 28 17:47:47 -0700 2006 --- Just a small comment (I added it to the duplicate issue 70575): 1. Paste a selection from Draw to Writer 2. Save Writer document 3. Preview in Win Explorer is OK!!! (W2k SP4, OO.o 2.04) 4. Reopen the document => BROKEN 5. Resave => NOW the PREVIEW is BROKEN, too I conclude that the open is wrong and there MUST be an error affecting only the actual open AND NOT the preview. Which module/plugin lets one to preview a writer document in the Windows Explorer? That one seems OK. I have appended also a diff between the 2 content.xml files (original document and the reopened/resaved document). Maybe someone can detect the error. (see issue 70575) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 66735] amend brackets for inputs starting with number with algebraic sign
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66735 --- Additional comments from [EMAIL PROTECTED] Thu Oct 26 15:32:53 -0700 2006 --- Issue 24271 has been closed, but it is still a big BUG. -4^2 = -16 !!! ALWAYS Software, that does NOT conform to this is wrong. You do not have in mathematics an "inverse sign" operator, therefore "-" is really a minus before anything else. * IF you want to raise the number "-4" to sqare, THEN you have to type: (-4)^2 * -4^2 = -(4^2) = -16 * -3! = -(3!) * -x^2 = -(x^2) ** you never interpret -x^2 = (-x)*(-x) = x^2 FALSE # the operators '^' AND '!' have highest left-side precedence (BUT NOT right-sided, e.g. -2^3^4 = -2^(3^4)=-(2^(3^4)) ) R v2.4.0: -4^2 = -16 Octave v2.1.73: -4^2 = -16 (I will ask a collegue next week to test Mathematica, too) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70736] RTF: Romanian characters i n drawing textbox wrongly imported
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70736 --- Additional comments from [EMAIL PROTECTED] Mon Oct 23 10:54:20 -0700 2006 --- I wish to encourage the developers to correct all these RTF problems as fast as possible. This RTF defect is part of a larger defect (see issue 70537 for the full rtf document). REASON == This is an official document of the Romanian Ministry of Education and Research (the CNCSIS branch). The National University Research Council (CNCSIS) is the main Romanian funding organisation for university and postgraduate research programmes. (see http://www.cncsis.ro/English/home.php for a description in English) It is difficult for the academia to switch to OOo, if they would not be able to fill the appliance for grants. I still use OOo, but had to switch to MS Office to write that application. Therefore I sincerely hope that this gets corrected as fast as you can. Many thanks in advance, Leonard Mada - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70537] RTF: Objects positioned wr ongly when imported
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70537 --- Additional comments from [EMAIL PROTECTED] Mon Oct 23 10:03:52 -0700 2006 --- Although the target milestone is set to "OOo Later" I wish to encourage the developers to correct all these RTF problems as fast as possible. REASON == This is an official document of the Romanian Ministry of Education and Research. Actually it is the primary questionaire needed to apply for grants in Romania. CNCSIS is by far the most important institution that offers grants in Romania, and everybody from the academia is bounded to fill this form. (see http://www.cncsis.ro/tipa2007.php ; there is even an English version of the document, http://www.cncsis.ro/2007/inf_comp/A/Formular_A_2007_ENGLEZA.rtf , but this one does NOT contain the Romanian letters). It is difficult for the academia to switch to OOo, if they would not be able to fill the appliance for grants. I still use OOo, but had to switch to MS Office to write that application. So I would ask you sincerely to put every effort to correct the RTF filter as fast as possible. IF there are any inconsistencies in MS Office, please let me know. I would not loose the opportunity to bash at the Romanian Ministry, BUT I need HARD evidence, that the specific feature is not standards compliant. Kind regards, Leonard Mada - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20496
--- Additional comments from [EMAIL PROTECTED] Fri Oct 20 01:06:52 -0700
2006 ---
[QUOTE]
> +abcd=> if it generates an error then it is shown as an error (similar to
> what excel does) - probably the user made a typo! (consider this,
> =inf("system")
> generates an error then why shouldn't +inf("system") generate an error?)
This is exactly what I hate at Excel. I am working very much with strings and it
is annoying to generate formulas on the fly.
- '+abcd' is definetely NOT intended to be a formula
- it should be a string
- IF there is a mistyping, THEN
-- the user HAS to come back to correct the error
-- so having it as a string is the same as having it as a formula
-- because Calc would NOT have changed the string
-- (i.e. it is different from 36373+34737, where you wouldn't be able to
correct one of the numbers, because Calc would already added them up)
- WHEN correcting a 'should be formula', you are again in the particular cell
and the input routine would(/could) change it back to formula mode (there is
still the '+' in front of the string), so there is NO need to make an erroneous
formula
Just my thaughts.
There was another issue (applies even for the official OOo 2.04).
- '+4':
-- currently it is transformed to the plain number '4'
-- we do NOT need a formula for simple numbers
-- however, when working with categorical data, there might exist categories
of '+4', '+3', which are different from '4', '3'
-- I would have liked that this be converted to string
So, I think, this issue should be viewed as a more general approach to format
the input in Calc (and NOT just the simple formula enter mode)
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39892) Diff between the tw | |o Content.xml files --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 16:08:30 -0700 2006 --- Created an attachment (id=39892) Diff between the two Content.xml files - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 16:07:04 -0700 2006 --- The file content.xml seems to be different between the 2 files (my 2 files: the original and the reopened/resaved file). I will append a text file with the differences: Some lines are different. (I have added breaks to visualize better the differences. Also I have deleted a substantial part at the beginning that was identical.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39890) Simple Test File - | |Preview is OK, OPENING is | |broken --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 15:22:43 -0700 2006 --- Created an attachment (id=39890) Simple Test File - Preview is OK, OPENING is broken - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 User discoleo changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39891) Simple Test File - | |after Opening AND Saving i | |t --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 15:23:43 -0700 2006 --- Created an attachment (id=39891) Simple Test File - after Opening AND Saving it - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 15:21:25 -0700 2006 --- There is a more general problem: I will attach 2 simple files (I reduced the original drawing): - Preview first file: it is OK (in Win Explorer, W2k, SP4, OOo 2.04) - Open it in OOo 2.04 => it is wrong (the vertical line is bigger!!!) - SAVE it in OOo 2.04 => the Preview is now wrong, too; the saved file is different from the first one * file 1 is the original * file 2 is the original AFTER opening with OOo2.04 AND Saving it again (without actually modifying anything!!!) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 14:37:37 -0700 2006 --- *STARNGE, STRANGE* Opening attachment id=39867, displays the picture erroneosly. Previewing the file in Win Explorer seems to display the file correctly. NOW: - Open the file in OOo 2.04 - SAVE it again - BOOM: the preview is wrong, too So, I believe that OOo opens wrongly the file, while the preview plugin interprets it OK. Must be a bug in OOo open module (NOT SAVE module). What differences exist between PREVIEW and OPEN? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 70575] Mismash in object pastet f orm Draw after save
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70575 --- Additional comments from [EMAIL PROTECTED] Thu Oct 19 14:31:48 -0700 2006 --- OK, I can reproduce it. OOo 2.04 (en) W2k SP4 STRANGE: The preview in Windows Explorer (the small image) seems to be correct (as far as one can decipher the small image). Which plugin lets Win Explorer display the preview? That seems to be OK (even after saving the OOo writer document). So it seems that the opening is the problem (NOT the save). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20496
--- Additional comments from [EMAIL PROTECTED] Thu Oct 19 09:21:14 -0700
2006 ---
I had a new brainstorming session and would like to expand on some issues/
Specifications:
What__| How
is| should it be
entered___| interpreted
==|=
SIMPLE NUMBER:
* Number (e.g. 4) => as plain number
* negative number (-3) => as negative plain number
* '+' + 'Number' => as STRING !!!
-- this is currently interpreted as a number, too, but in categorical data you
may have often categories of, e.g. '+4' which is different from '4' (think of
grades in histology and so on);
NOTE: when we have only one number [regardless of the +/-/(or nothing) in front
of that number], the formula does *NOT bring* any *additional benefit*, so I do
NOT believe that a formula is needed in these situations!!!)
NUMBER FOLLOWED BY OPERATOR:
* 'plain number'+'any operator' => string
* '+' + 'plain number' + 'any operator' => formula
* '-' + 'plain number' + 'any operator' => string (formula?)
* ('+' or '-') + '-' + 'plain number' + 'any op' => formula; strip first +/-
-- advanced: IF "'any operator'..." does evaluate to *ERROR*, consider string
instead of formula
STRING:
* any string => string
* ('+' OR '-') + STRING
-- IF string evaluates to valid function => formula
-- IF NOT => just a string
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20496
--- Additional comments from [EMAIL PROTECTED] Thu Oct 19 08:54:01 -0700
2006 ---
I posted previosly:
- option to DISABLE this !!
However, the current comment is about something else (as I belive that some
people really need this feature).
I think that specifications of 'should +1 become a formula' miss totally the
point.
IF I have '+1' or '=+1' it is actually the same. Both cells are equivalent and
the difference is minimal. (It is only a diference IF I need the string '+1',
which is probably a rare event.)
THE PROBLEM
===
The problem arises for NON-NUMERIC entries, like +A1, +'NAME OF FUNCTION',
+'STRING'. Here the differences *ARE BIG*, if it is only string or formula.
Therefore, I believe THESE situations should be detailed and a SPECIFICATION
should be made available.
As I pointed in my previous post:
- IF +'string' evaluates to a cell or valid function, then this should be
formula
- ELSE, this should be text string
- I use often '--' to describe a result that is not-available (but e.g. the
test was performed, yet did not yielded something interpretable), therefore I
would like that '--' be entered as a string ('--' has indeed a different format
from the templates discussed in the first IF and would be string by default
using my recommendations)
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
