[sc-issues] [Issue 115229] Match function error when looking for a string ending with parenthesis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115229 --- Additional comments from eduardojrobl...@openoffice.org Sun Oct 24 16:37:24 + 2010 --- Created an attachment (id=72726) file with example of 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 115229] Match function error when looking for a string ending with parenthesis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115229 Issue #|115229 Summary|Match function error when looking for a string ending |with parenthesis Component|Spreadsheet Version|OOo 3.2.1 Platform|PC URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from eduardojrobl...@openoffice.org Sun Oct 24 16:35:25 + 2010 --- If the search criteria string ends with parenthesis, the match function return is wrong: a. if in the lookup array there are an exact match of the search criteria and a similar string (the search criteria without the parenthesis), the match function will return the position of the similar string b. if in the lookup array there is an exact match of the search criteria and no similar string, the match function will return #N/A - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from eduardojrobl...@openoffice.org Sun Apr 19 12:50:08 + 2009 --- There are two different bugs although related: FIRS BUG: Absolute reference to a cell turning into a reference to a range. Try this: B1 = $A$1 + A2, then, if to copy B1 to B2, B2 = $A$1 + A3, the correct beheavior. If you want B2 = $A$2 + A3 you can either edit the formula by typing or while editing it, drag the colored A1 cell to A2. But, and this is the bug, OOo changes it to the range $A$2:A2, then B2 = $A$2:A2 + A3. There is noting wrong with the result of B2 as the range starts and ends in the same cell, but if it gets copied, say to B3, the formula will no be as intended (B3 = $A$2 + A4) but B3 = $A$2:A3 + A4, which by way of how OOo handles ranges in a formula is equivalent to B3 = A3 + A4. SECOND BUG: Absolute reference to a cell turning into a reference to an absolute range. The process is the same as the first bug, but in some cases that I can't replicate every time, the range reference is absolute in the starting and ending cells. I am using OOo 3.0.1 in windows. Will it ever get solved? It is the 4th most voted defect in the spreadsheet component and 37th overall. I am tired of this and this is my last comment on this bug. We users keep talking about it. Every one can replicate de basic form of the bug. It gives WRONG results. It is almost impossible to verify in a large and complex spreadsheet. IT WAS NOT PRESENT in older versions of OOo. The OOo team keeps changing the target milestone and now it is not even a specific one. It is not assigned to anyone. Developers DO NOT pay attention to users no matter the 17 votes it has. It seems to me that OpenOffice will never be a trusty application. It is more of a showcase for opensource advocates (SUN and IBM included) that need to prove that a good and large application can be developed? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[graphics-issues] [Issue 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:51:00 + 2008 --- Sorry for the last report. I have found that i can insert a secondary axes title under the insert title menu. It is obious... :( - 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 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:51:00 + 2008 --- Sorry for the last report. I have found that i can insert a secondary axes title under the insert title menu. It is obious... :( - 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 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 User eduardojrobledo changed the following: What|Old value |New value CC|'billjoie,iha,kamataki,mmp|'billjoie,eduardojrobledo, |,pagalmes,tonygalmiche,vio|iha,kamataki,mmp,pagalmes, |n,weiz' |tonygalmiche,vion,weiz' - 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 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 User eduardojrobledo changed the following: What|Old value |New value CC|'billjoie,iha,kamataki,mmp|'billjoie,eduardojrobledo, |,pagalmes,tonygalmiche,vio|iha,kamataki,mmp,pagalmes, |n,weiz' |tonygalmiche,vion,weiz' - 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 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:45:39 + 2008 --- Although there is a menu item for the editing of the secondary axes title, there is no way to have a secondary axes title to edit, so the menu item is not available. There are two ways to create a secondary axis: - edit a data series and in "options" align it to the secondary axis, or, - insert a secondary axis Neither way a title for the secondary axis is created. Ooo 3.0 Windows Vista. - 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 1163] title for secondary y axis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=1163 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 19:45:39 + 2008 --- Although there is a menu item for the editing of the secondary axes title, there is no way to have a secondary axes title to edit, so the menu item is not available. There are two ways to create a secondary axis: - edit a data series and in "options" align it to the secondary axis, or, - insert a secondary axis Neither way a title for the secondary axis is created. Ooo 3.0 Windows Vista. - 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]
[lingucomponent-issues] [Issue 73007] User interfase language ca nnot be changed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73007 --- Additional comments from [EMAIL PROTECTED] Thu Oct 16 18:16:22 + 2008 --- Sorry, I no longer have windows xp nor use the spanish localization, so I can't verify if the problem still exists. - 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 94966] Some functions are not tra nslated when spreadsheet is opened in other la nguage
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94966 --- Additional comments from [EMAIL PROTECTED] Thu Oct 16 17:45:39 + 2008 --- FIRST PROBLEM: If the file attached is opened with OOo2.4.1 (es) cell a14 (among others), =IF(A13http://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 94966] Some functions are not tra nslated when spreadsheet is opened in other la nguage
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94966 --- Additional comments from [EMAIL PROTECTED] Thu Oct 16 17:13:58 + 2008 --- Created an attachment (id=57180) File created with OOo3.0 (en) that opens with problems in OOo2.4.1 (es) - 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 94966] Some functions are not tra nslated when spreadsheet is opened in other la nguage
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94966 Issue #|94966 Summary|Some functions are not translated when spreadsheet is |opened in other language Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Thu Oct 16 04:50:32 + 2008 --- If a spreadsheet created in OOo3.0 (en) is opened in OOo2.4.1 (es) or viceversa, some functions, such as eomonth() do not translate, so they are not recognized. The spreadsheet is rendered useless if created on one version and then saved in the other, and would need editing each cell with the untranslated function for it to work again. - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from [EMAIL PROTECTED] Mon Jun 9 20:52:39 + 2008 --- The problem is still present in Ooo 3.0 beta - 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 53801] Saved file loses the forma ts for some objects
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53801 --- Additional comments from [EMAIL PROTECTED] Sat May 17 19:13:10 + 2008 --- Checked with both OOo 2.4 and 3.0 beta and there is no problem. I think the issue should be marked as solved. - 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 89319] Cell merge erases formulas
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89319 Issue #|89319 Summary|Cell merge erases formulas Component|Spreadsheet Version|OOo 3.0 Beta Platform|All URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sun May 11 22:02:44 + 2008 --- If a cell with a formula is merged with a blank cell on its right, the formula is lost if the contents of the "hidden" cell are moved to the first cell. - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from [EMAIL PROTECTED] Sat Mar 29 14:06:14 + 2008 --- The problem is still present in OOo2.4 (at least on windows XP, Vista and Vista 64) Will it ever get fixed? Now is targeted for OOo 3.x (not even 3.0). It seems that votes are worth nothing. I wonder, if OOo2.2 was fine, would it be too difficult to fix? I am willing to contribute, is there anything I can do about it (I am not a programmer)? Can (and should) I pay for the fix? - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from [EMAIL PROTECTED] Thu Dec 6 16:12:07 + 2007 --- It does not work with Ooo 2.3.1 It seems to me that not everyone understands what the problem is, so try this: If a1 = $b$1 + b2 Double click on it to edit formula Drag the b1 reference (drag the colored cell) to c1 and confirm edit You should have a1 = $c$1 + b2, but have a1 = $c$1:c1 + b2 Although the answer is still correct, if the cell gets copied, say to a2, it will become a2 = $c$1:c2 + b3 which is equal to c2 + b3, instead of the correct a2 = $c$1 + b3 What happens is that the absolute reference becomes a range when dragged in "editing mode". If it was not an absolute reference, there is no problem. BTY, it did work on Ooo 2.2, and it is a very useful feature. Hopefully it the OOO team would reconsider the target milestone. If Ooo is slow, we can do with it, but what is not reasonable is to have wrong results. - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from [EMAIL PROTECTED] Tue Dec 4 23:30:31 + 2007 --- As it happens so often with OOO, it seems the users will not be heard... IT IS A BASIC FUNCTIONALITY THAT DOES NOT WORK!!! I don't know how many worksheets are giving wrong results, but i bet that whoever takes a bad decision based on a formula wrecked by this problem, will never, ever, use OpenOffice again (nor will she/he speak for it). Why not be fixing the basic functionalities before of introducing new "fancy" ones??? - 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 44828] tools-detective-trace for cross-sheet formulae
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44828 User eduardojrobledo changed the following: What|Old value |New value CC|'haxwell' |'eduardojrobledo,haxwell' - 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 44828] tools-detective-trace for cross-sheet formulae
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44828 --- Additional comments from [EMAIL PROTECTED] Sun Oct 21 15:36:51 + 2007 --- Trace dependents or trace precedents does a trace (with good funicionality), but if the traced cell is in another sheet the funcionality is gone. It becomes almost imposible to check a medium sized spreadsheet without the trace being fully functional. This is not an enhancement but a defect. Classifying this as an enhancement (which "depends on the eye of the beholder") is no only misleading but will delay indefinitely its fixing. Sometimes i wonder if developers look at users reports from a user point of view. - 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 44828] tools-detective-trace for cross-sheet formulae
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44828 --- Additional comments from [EMAIL PROTECTED] Sun Oct 21 15:35:29 + 2007 --- Trace dependents or trace precedents does a trace (with good funicionality), but if the traced cell is in another sheet the funcionality is gone. It becomes almost imposible to check a medium sized spreadsheet without the trace being fully functional. This is not an enhancement but a defect. Classifying this as an enhancement (which "depends on the eye of the beholder") is no only misleading but will delay indefinitely its fixing. Sometimes i wonder if developers look at users reports from a user point of view. - 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 23893] formula highlightng doesn' t work when sheet name contains a blank
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23893 User eduardojrobledo changed the following: What|Old value |New value CC|''|'eduardojrobledo' - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 User eduardojrobledo changed the following: What|Old value |New value CC|'gercokees,jolatt,pjanik,s|'eduardojrobledo,gercokees |andreas41,sparcmoz' |,jolatt,pjanik,sandreas41, | |sparcmoz' - 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 79035] Absolute cell reference be comes a range when draged
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79035 --- Additional comments from [EMAIL PROTECTED] Sat Jul 7 17:43:21 + 2007 --- This is really annoying. Working with large spreadsheets without using the dragging feature is taking too long (and using it is too risky!) Is there any thing I can help with in order to solve the issue? - 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 79220] mishandling of sheets name d with spaces
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79220 Issue #|79220 Summary|mishandling of sheets named with spaces Component|Spreadsheet Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Wed Jul 4 13:47:35 + 2007 --- There is a problem with sheets whose name have spaces on them: Say you have an spreadsheet with three sheets named: 'a a'; 'b' and 'c' Say you have c.a1 = 'a a'.a1 + b.a1 If you double click on c.a1 to edit, two behaviors are observed: 1. Behavior 1 (typical with spreadsheets created with Ooo 2.2.1): No highligthing of 'a a'.a1, so it cannot be dragged 2. Behavior 2 (typical with spreadsheets created with Ooo 2.0): If 'a a'.a1 is highligthed, dragging it to 'a a'.a2 changes the formula for c.a1 to 'a'a a'.a2 + b.a1 and becomes an 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 79219] mishandling of sheets name d with spaces
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79219 Issue #|79219 Summary|mishandling of sheets named with spaces Component|Spreadsheet Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Wed Jul 4 13:47:15 + 2007 --- There is a problem with sheets whose name have spaces on them: Say you have an spreadsheet with three sheets named: 'a a'; 'b' and 'c' Say you have c.a1 = 'a a'.a1 + b.a1 If you double click on c.a1 to edit, two behaviors are observed: 1. Behavior 1 (typical with spreadsheets created with Ooo 2.2.1): No highligthing of 'a a'.a1, so it cannot be dragged 2. Behavior 2 (typical with spreadsheets created with Ooo 2.0): If 'a a'.a1 is highligthed, dragging it to 'a a'.a2 changes the formula for c.a1 to 'a'a a'.a2 + b.a1 and becomes an 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 79035] Absolute cell reference be comes a range when draged
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79035 Issue #|79035 Summary|Absolute cell reference becomes a range when draged Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sat Jun 30 05:43:57 + 2007 --- When a cell is edited, if an absolute referenced cell is draged, it becomes a range reference. Say you have: a1 = $b$1 + b2 Double click on it to edit formula Drag the b1 reference to c1 and confirm edit You should have a1 = $c$1 + b2, but have a1 = $c$1:c1 + b2 Although the answer is still correct, if the cell gets copied, say to a2, it will become a2 = $c$1:c2 + b3 which is equal to c2 + b3, instead of the correct a2 = $c$1 + b3 Since dragging to edit part of formulas is a very important feature, this should be a show stopper - 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]
[lingucomponent-issues] [Issue 73007] User interfase language ca nnot be changed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73007 --- Additional comments from [EMAIL PROTECTED] Wed Jan 3 06:00:53 -0800 2007 --- I cannot replicate the problem in another computer, so it would seem that it has something to do with the configuration of windows. - 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]
[lingucomponent-issues] [Issue 73007] User interfase language ca nnot be changed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73007 Issue #|73007 Summary|User interfase language cannot be changed Component|lingucomponent Version|OOo 2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|other Assigned to|[EMAIL PROTECTED] Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sat Dec 30 10:10:53 -0800 2006 --- When the spanish dictionary is installed the user interfase defaults to english, and cannot be changed back to spanish. Used the following procedure: Downloaded 2.1 Downloaded Spanish language pack for ooo 2.1 Exit ooo and closed quickstart Installed 2.1 (had 2.0.4 installed) Installed spanish language pack Started ooo Set userinterfase language to spanish exit ooo and closed quickstart Started ooo Used wizard (1.6.2) to install spanish (spain) dictionaries (spellcheck, thesaurus, hyphenation) closed ooo and quickstart Started ooo The user language interfase was set to default, and stays that way. Have checked several alternatives. See http://www.oooforum.org/forum/viewtopic.phtml?t=50929&highlight= - 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 70751] Sum.if() function doesn't work if criteria is on a diferent sheet than a rea to apply it to
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70751 User eduardojrobledo changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Mon Oct 23 10:41:22 -0700 2006 --- I have found the problem: The criteria has to be writen as follows: c1=sumif(a1:a10;"<"&b5) since the criteria is a regular expression - 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 70751] Sum.if() function doesn't work if criteria is on a diferent sheet than a rea to apply it to
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70751 --- Additional comments from [EMAIL PROTECTED] Mon Oct 23 10:07:23 -0700 2006 --- What really happens is not related to where the criteria and areas to be applied to reside, but to the fact that de filtering criteria cannot reference a cell. - 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 70751] Sum.if() function doesn't work if criteria is on a diferent sheet than a rea to apply it to
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=70751 Issue #|70751 Summary|Sum.if() function doesn't work if criteria is on a dif |erent sheet than area to apply it to Component|Spreadsheet Version|OOo 2.0.4 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Mon Oct 23 09:25:21 -0700 2006 --- When using sum.if()function it seems that all parameters have to be in the same sheet. c1=sum.if(a1:a10;"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 65133] New - Add math symbols to formula bar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65133 Issue #:|65133 Summary:|Add math symbols to formula bar Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P1 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sat May 6 10:58:35 -0700 2006 --- Users would save a great deal of time if there were basic math symbols (plus, minus, multiply, divide, left and right parenthesis) in the formula bar, so in writing formulas, the mouse could be used for most of the operation. The actual way is specially cumbersome in notebook computers, because you need both hands for some keys (shift + ) - 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 64166] New - Recalculation can no t be disabled in macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64166 Issue #:|64166 Summary:|Recalculation can not be disabled in macros Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sun Apr 9 06:51:38 -0700 2006 --- In a macro, disabling the recalculation does not work, so the spreadsheet recalculates every time a new entry is posted to a cell, taking a lot of time in large spreadsheets. - 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 61321] New - Customize the formul a bar
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61321 Issue #:|61321 Summary:|Customize the formula bar Component:|Spreadsheet Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sun Jan 29 13:32:19 -0800 2006 --- Users would save a great deal of time if there were basic math symbols (plus, minus, multiply, divide, left and right parenthesis) in the formula bar, so in writing formulas, the mouse could be used for most of the operation. The actual way is specially cumbersome in notebook computers, because you need both hands for some keys (shift + ) - 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 53801] Saved file loses the form ats for some objects
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53801 --- Additional comments from [EMAIL PROTECTED] Wed Aug 31 05:50:34 -0700 2005 --- This is wath i have found: 1. Select the left most text of the diagram by left clicking on it 2. From the lines and filling toolbar choose "color" and apply any color 3. From the same toolbar choose "line style" continuous 4. Save the file 5. Close the file 6. Reopen the file The reopened file keeps the format Now try this: 1. Select the left most text of the diagram by left clicking on it 2. From the main tool bar choose the "format brush", pick the format from the left most text (the one you apply formats to in the previos example) and apply it to the next unformated text 4. Save the file 5. Close the file 6. Reopen the file The reopened file do not keep the format applied with the brush, but does keep the one applied with the line and fill toolbar, or by that matter by changing linetypes and filling colors in the propierties window. - 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 53801] Saved file loses the form ats for some objects
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53801 --- Additional comments from [EMAIL PROTECTED] Sat Aug 27 05:50:30 -0700 2005 --- Rigth, the file i sent already has lost some of its characteristics. Try this: 1. Pick one of the plain text objects on the chart (the ones without background color) 2. Change the linetype from "invisible" to "continuous" 3. Change the background color to any solid color 4. Repeat steps 1 to 3 for the remaining plan text objects 5. Save the file 6. Close the file 7. Reopen the file Voila, some of the text objects didn't retain their format. - 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 53801] Saved file loses the form ats for some objects
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53801 User eduardojrobledo changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=29070) diagram with | |text and connectors --- Additional comments from [EMAIL PROTECTED] Thu Aug 25 12:15:01 -0700 2005 --- Created an attachment (id=29070) diagram with text and connectors - 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 53801] New - Saved file loses the formats for some objects
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53801 Issue #:|53801 Summary:|Saved file loses the formats for some objects Component:|Drawing Version:|680m118 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|wg Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Thu Aug 25 12:13:38 -0700 2005 --- When saved, a file with a digram "loses" the following formats on some of the text objects: 1. background color 2. line type I have tried the same file in two diferent computers, loosing different parts of the format. I can supply an example file, but don´t find where to attach 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 46252] New - Language changes without reason
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46252 Issue #:|46252 Summary:|Language changes without reason Component:|Word processor Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|mru Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Tue Mar 29 19:11:02 -0800 2005 --- When the document language is set to spanish, as you write, the language changes by itself to english in the middle of the 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]
[graphics-issues] [Issue 44171] New - On the templates the area of text boxes can't be colored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44171 Issue #:|44171 Summary:|On the templates the area of text boxes can't be |colored Component:|Presentation Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|wg Reported by:|eduardojrobledo --- Additional comments from [EMAIL PROTECTED] Sat Mar 5 08:29:50 -0800 2005 --- When modifying the template on background mode, the background color of text boxes can't be colored with any other color but white (when another color is choosen, it defaults to white upon closing the window) - 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]
