[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] Sun Apr 1 23:32:09 +
2007 ---
The criteria for COUNTIF is case insensitive with or without regular expressions
like it is in Excel with or without wildcards. Changing this would probably
break some compatibility with Excel.
If you want to count exact case sensitive matches of the entire string you can
use an array formula like {=SUM(A1:A200=S)*1} or {=SUM(A1:A200=s)*1} . Enter
the formula without the {} and then CTRL-SHIFT-ENTER rather than ENTER.
If you need to compare case sensitive substrings rather than the entire string
use =ISNUMBER(FIND(S;A1) or =ISNUMBER(FIND(s;A1) in Cell B1 then copy and
paste the formula into Cells B2 to B200 so you have TRUE or FALSE in column B.
Then use =COUNTIF(B1:B200;1) to count the number of TRUEs.
-
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 36557] SUM.IF with two conditions
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=36557
User drensink changed the following:
What|Old value |New value
Status|NEW |RESOLVED
Resolution| |INVALID
--- Additional comments from [EMAIL PROTECTED] Sat Oct 28 12:54:13 -0700
2006 ---
SUMIF has one condition by design. The reason is multiple conditions can be
achieved using an array formula and SUM.
{=SUM( ( A1:A10 = Condition1 ) * (B1:B10 = Condition2) * C1:C10)}
Note: Ctrl - Shift - Enter to enter a formula as an array formula
Therefore, this issue should be closed by the owner.
-
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 68652] Apostrophe on the first po sition becomes invisible. That leads to confus ion.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68652 --- Additional comments from [EMAIL PROTECTED] Sat Aug 19 23:45:43 -0700 2006 --- This duplicates Issue 65510 , though the original comment contains information not yet in Issue 65510 . - 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 51564] Summation does not work f rom UI; changes exsisting value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51564 --- Additional comments from [EMAIL PROTECTED] Sun Apr 9 12:02:08 -0700 2006 --- *** Issue 63920 has been marked as a duplicate of this 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 63920] Auto SUM creating sums wi thin specified sums
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63920 User drensink changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Sun Apr 9 12:03:45 -0700 2006 --- Duplicate of Issue 51564 *** This issue has been marked as a duplicate of 51564 *** - 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 63920] Auto SUM creating sums wi thin specified sums
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63920 User drensink changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Sun Apr 2 22:06:41 -0800 2006 --- Confirmed on Windows XP OOo 2.02. Cannot find any duplicates. This one will likely effect a large number of users since it is a widely expected basic functionality of a spreadsheet. The result of an Auto Sum of a selection should be that the sums are entered in the cells below the selection without changing anything in the selection itself. - 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 7269] PageUp-, PageDown keys sho uld work in print preview
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=7269 --- Additional comments from [EMAIL PROTECTED] Sun Apr 2 16:57:53 -0800 2006 --- *** Issue 63914 has been marked as a duplicate of this 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 63914] Use of Page Up/Page Down in Print Preview
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63914 User drensink changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Sun Apr 2 16:57:54 -0800 2006 --- This duplicates Issue 7269. Ddoty1, marking this issue as a duplicate, but please add another vote to Issue 7269. *** This issue has been marked as a duplicate of 7269 *** - 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]
[framework-issues] [Issue 30522] Improved Zooming UI
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30522 --- Additional comments from [EMAIL PROTECTED] Sat Apr 1 01:50:42 -0800 2006 --- *** Issue 63751 has been marked as a duplicate of this 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 63751] make zoom independent per worksheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63751 User drensink changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Sat Apr 1 01:50:43 -0800 2006 --- This duplicates Issue 30522 *** This issue has been marked as a duplicate of 30522 *** - 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 63877] Creating Fixed width file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63877 --- Additional comments from [EMAIL PROTECTED] Fri Mar 31 20:59:59 -0800 2006 --- This feature is available in version 2.02 using File - Save As - Select Type Text (.csv) - Check Edit filter settings - Click Save - Set Character Set, Field Delimiter, Text Delimiter, and check Fixed Column Width in the Export of text files dialog box - Click OK - Click OK on only the active sheet was saved warning dialog. Excel will also only save the active sheet, so the behavior is the same as saving Formatted Text (Space Delimited) (*.prn) from Excel. - 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 9392] Pressing the delete butt on on a selected cell should not necessarily b ring up the Delete Contents popup dialog. Ex cel also does not bring up a dialog on deletio n of a
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9392 --- Additional comments from [EMAIL PROTECTED] Tue Mar 28 19:56:16 -0800 2006 --- How to swap the function of the Backspace and Delete keys in Openoffice 2.02 1. Click Tools in the main menu 2. Click Customize in the submenu 3. Click the Keyboard Tab 4. Set the radio button to Calc which should be the default 5. In the Shortcut keys list: Scroll to and select Backspace 6. In the Functions Lists: Select Edit under Category and the second Delete Contents under Function 7. Click the Modify Button 8. In the Shortcut keys list: Scroll to and select Delete 9. In the Functions Lists: Select Edit under Category and the first Delete Contents under Function 10. Click the Modify Button 11. Click the OK Button Apparently this feature got added at some point and was very poorly documented, at least in relation to this 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 9392] Pressing the delete butt on on a selected cell should not necessarily b ring up the Delete Contents popup dialog. Ex cel also does not bring up a dialog on deletio n of a
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=9392
--- Additional comments from [EMAIL PROTECTED] Sun Mar 26 20:47:21 -0800
2006 ---
CAUTION: I do not know what the full consequences of this modification are on
the modules not related to Calc or on Calc. Keep a backup of the original file
in case you need to restore it.
On Windows XP with the US English OpenOffice.org 2.02 you can change the file
c:\Documents and Settings\{Username}\Application Data\OpenOffice.org2
\user\config\soffice.cfg\modules\scalc\accelerator\en-US\current.xml
where {Username} is the username to change the settings for.
Change the line:
accel:item accel:code=KEY_BACKSPACE xlink:href=.uno:ClearContents/
To:
accel:item accel:code=KEY_BACKSPACE xlink:href=.uno:Delete/
Add the line:
accel:item accel:code=KEY_DELETE xlink:href=.uno:ClearContents/
I am unsure how this change would react with the
accel:item accel:code=KEY_BACKSPACE xlink:href=.uno:Delete/
line in the global\accelerator\en-US\current.xml file, but it appears to
override it.
I have not tried this for any other version of OpenOffice.org, but have
successfully tried it on Fedora Core 5.
This is just a workaround, not a proper fix, so my current opinion is this issue
should not be closed yet.
-
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 63524] text to column
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63524 --- Additional comments from [EMAIL PROTECTED] Thu Mar 23 22:26:39 -0800 2006 --- You can use the DAY function to return the day from a date. For example if cell A1 contains the date 31/12/06, you can return the day by entering =DAY(A1) in another cell. If you want to include the leading 0 adjust the cell format. The request for a text to column option is a duplicate of Issue 4040. - 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 62657] Copy of formula to text i n calc retain color
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62657 User drensink changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Sun Mar 12 01:45:20 -0800 2006 --- Confirmed on Windows XP OpenOffice.org 2.0. Color formatting should change the entire contents of the cell and not leave A1 in blue. The preview in Format - Cells - Font Effects shows the entire text colored properly even if A1 is still in blue. - 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 62657] Copy of formula to text i n calc retain color
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62657 --- Additional comments from [EMAIL PROTECTED] Sun Mar 12 09:44:49 -0800 2006 --- Regina, Thank you for the explanation. What do you think about an enhancement request to add override direct formatting directly to the color selection tool, making it 1 click to apply the color to the entire content if the user desires? In the method you describe if you want to change the color to green instead of black it would be Ctrl-Shift-Space, and then click the color selection tool, and select the new color as opposed to using only the color selection tool. An option in the color selection tool would be in the context of what the user is trying to do at that particular time and easier for beginners to understand. - 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 9392] Pressing the delete butt on on a selected cell should not necessarily b ring up the Delete Contents popup dialog. Ex cel also does not bring up a dialog on deletio n of a
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=9392 --- Additional comments from [EMAIL PROTECTED] Wed Mar 8 02:55:09 -0800 2006 --- *** Issue 62777 has been marked as a duplicate of this 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 62777] delete key behavior incon sistent with Excel
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62777 User drensink changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Wed Mar 8 02:55:11 -0800 2006 --- Duplicate of Issue 9392. JA, just so you know there has been many complaints about this as a severe usability issue since November 19, 2002. Novell's version in Suse even has the keys swapped by default. There is already a patch to swap the keys available, but it is not the proper solution since Openoffice.org users that do not use Excel still want the default to be the backspace key. The people that are converting from Excel or using both simultaneously obviously do not want to spend 24 hours compiling OpenOffice.org just to get a proper key binding option. The proper solution is to have an option to swap the keys in the dialog window that pops up or to set the behavior in the options. The code for the options and dialog windows is a bit harder to understand than just swapping the 2 keys like Novell did. I would have changed it already if I had the skill to write a proper patch that could get put in the upstream code base. Please dont vote against an option (not a default) the rest of us have been asking about for the last 3.5 years. Weirdboy, marking this resolved as a duplicate, but please add to the votes on Issue 9392. *** This issue has been marked as a duplicate of 9392 *** - 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 57758] Accounting formatting n eeded in CALC/Spreadsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57758 --- Additional comments from [EMAIL PROTECTED] Wed Feb 15 02:25:24 -0800 2006 --- Duplicate of Issue 15773, also related to Issue 23839 Both Issue 15773 and Issue 23839 should be resolved together for the alignment and underlining to be appropriate for use related to accounting and finance. - 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 61329] wrong error code given: s hould be 502, is 503
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61329 --- Additional comments from [EMAIL PROTECTED] Thu Feb 9 19:18:41 -0800 2006 --- Lars, I notice in the issue activity you comment that the error should be 502 rather than 503. From the OO 2.0 Help File: Error 502 Invalid argument Function argument is not valid, for example, a negative number for the root function. Notice that =IF(A1100,2) has perfectly valid arguments for an IF formula and is not the direct problem with the example Excel file. The problem does not arise until the resulting text 2 is referenced in a formula in another cell and treated like it was a number. Therefore, Error 502 would not be appropriate in this case. From the OO 2.0 Help File: Error 519 No result (#VALUE is in the cell rather than Err:519!) Formula yields a value that does not corresponds to the definition, or a cell that is referenced in the formula contains text instead of a number. This is more appropriate error since this is the exact problem with the example spreadsheet. I definitely agree with you that Error 503 is completely inappropriate. The results of the simplified example in my last comment were from Excel 2002, so there will still be conversion problems from documents for Excel 2002 and possibly older formats even if the formula results in a more descriptive 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 61329] Error. 503 in calculated cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61329 --- Additional comments from [EMAIL PROTECTED] Wed Feb 8 21:45:03 -0800 2006 --- The problem arises with the string values in the IF formulas in Column V of the attached example Excel file. Equation that works in Excel, but gives Error 503 in OpenOffice.org =IF(U5165,2,IF(U5285,3,IF(U5370,4,IF(U5500,4,IF(U5650,6,IF(U51000,4,IF(U51305,6,Large Shear))) Equation corrected to work in OpenOffice.org =IF(U5165;2;IF(U5285;3;IF(U5370;4;IF(U5500;4;IF(U5650;6;IF(U51000;4;IF(U51305;6;Large Shear))) Note the only difference is the removal of the quotes around the values to enter in the cells based on the condition resulting in the entry of a number rather than a string. A very simplified example of the problem: Excel A1 =100/2 results in 50 A1 =100/2 results in 50 A1 100 B1 2C1=A1/B1 results in 50 A1 100 B1 2 C1=A1/B1 results in #VALUE! A1 100 B1 =2 C1=A1/B1 results in 50 A1 100 B1 '2 C1=A1/B1 results in 50 OpenOffice.org A1 =100/2 results in 50 A1 =100/2 results in 50 A1 100 B1 2C1=A1/B1 results in 50 A1 100 B1 2 C1=A1/B1 results in Error:503 -- This is correct error A1 100 B1 =2 C1=A1/B1 results in Error:503 -- This is incorrect error A1 100 B1 '2 C1=A1/B1 results in Error:503 -- This is incorrect error Notice that if =100/2 works in a single cell, there is no apparent reason that A1 100 B1 =2 C1=A1/B1 should not result in the same answer. - 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 55652] Number shouldn't trigger autoinput in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55652 User drensink changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Sat Oct 8 13:54:13 -0700 2005 --- Note that 2005. does not literally mean 2005. but means the cell input in A1 is '2005 and that autoinput can be disabled using tools - cell contents - autoinput. This issue only applies to the behavior of autoinput when the end user wants to keep it enabled. Numbers stored as text should not be a criteria to enable autoinput for number inputs. In other words, '2005 should not be a basis for enabling autoinput on 2005. - 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 55652] Number shouldn't trigger autoinput in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55652 User drensink changed the following: What|Old value |New value Keywords| |oooqa - 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 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Sun Sep 4 19:31:57 -0700 2005 --- You didn't get my point. The argument doesn't have to be a direct value I think I did get your point and thought I had explained that in the statement below to be interpreted as (The argument DOES have to be a direct value) Though it would be easier to just restrict that argument to only the values 0,1,True,False and anything else would result in a formula error and if it was not that would be in error. I can understand that you might want to or have to generalize from this specific case because the next complaint would be that a formula result could not be used. I can also understand that there may be no existing code in the current formula handling to force an argument to be only a direct value. Since it seems all of the above is not a realistic option, would you be willing to agree a reasonable option would be to make the setting applicable to each sheet in a workbook, rather than to the entire workbook? This would allow an import from Excel using wildcards and then adding a new sheet to the workbook that uses regular expressions within the same workbook. The user could reference cells on those sheets within the same workbook that are results of regular expressions. Thankyou for being patient in explaining your objections and the reasons for those objections in detail. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Mon Aug 15 19:32:08 -0700 2005 --- This gets a bit more complicated than it seems at face value, but I will continue a bit more to see if there is an optimal solution to the problem. What should be exported if that argument is the result of a formula? Keep in mind this would not be the argument with the wildcards/regular expressions in it, but an additional, optional argument whose value would be restricted to 0 or 1, True or False. If it is set to 1, then the formula uses wildcards and you export the other argument to the function with the wildcards in it as it is written by the author of the document and strip the 1 during export since Excel does not use it because by default it uses wildcards. If it is not set or set to 0, then you know you are exporting a document that is very likely not to be compatible with Excel, but could warn and continue exporting anyway. If the additional, optional argument is a result of a formula, which should not be necessary, then that formula should result in True or False, 0 or 1 otherwise it would be in error. That still would not matter because you would just check to see if it results in 0 and 1 and strip the whole formula off just like you would strip the 1 off. Though it would be easier to just restrict that argument to only the values 0,1,True,False and anything else would result in a formula error. I'd rather implement a simple wildcard search than fiddling around with the argument's string content. Bear in mind that all other content that possibly could form a regular expression would have to be escaped otherwise. The additional, optional argument would just determine which code path is taken. If you want to do a whole new implementation of the formula using wildcards instead of messing with the string content of the argument containing wildcards/regular expressions, the same principle would still work. The biggest problem I see with the supposedly simple solution, just turn off regular expressions and turn on wildcards is that it immediately eliminates the use of more powerful regular expressions in that document, preventing someone from importing a document containing wildcards from excel for the purpose of using regular expressions. The continued incompatibility on export of formulas with the same names using regular expressions would also still have to be dealt with in the simple case. The basis of my approach is almost exactly the same as doing it for the whole document or sheet, with the exception that it is done for each cell where those formulas are used, rather than the whole document at once. You still have to decide whether its a regular expression or wildcard and fix the code for each formula to handle it if you do it for the whole 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]
[sc-issues] [Issue 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Mon Aug 15 19:53:26 -0700 2005 --- One more note: It would be an irritatant to a user to have to add the ;1 constantly to a formula. The option for the document could be added anyway so when it is set to wildcards the ;1 is automatically added upon finishing the formula input. - 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 52810] Reassign the function of Delete key on the keyboard
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52810 --- Additional comments from [EMAIL PROTECTED] Wed Aug 10 19:39:03 -0700 2005 --- This is a duplicate of Issue 9392 opened in November of 2002. It is still counterintuitive to a lot of people, so there should be an option to swap the behavior of the backspace and del keys for those users that want to change it from the default. All anyone has asked for to date is an option to change it from the default, not to actually change the default for current users. If changing the defaults is why providing the option (not default) has been held up for 2.5 years, that is not a good reason. Regardless, this should be marked as a duplicate of 9392. - 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 53130] Sort more useful - no ran ge change
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53130 --- Additional comments from [EMAIL PROTECTED] Tue Aug 9 20:20:53 -0700 2005 --- Note this could be implemented simply by having a range selection box inside the dialog box like used for range selection when entering formulas, so the dialog box stays open while you reselect an undesired automatic range including reselecting a range that extends beyond the viewable area. The intention also seems to be to have shortcut keys/commands that do not require bringing up the dialog box at all, after all if you know what the default sort column is going to be anyway you dont need to set it in the dialog box. - 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 53134] New - Sort - Option to exp and selection
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53134 Issue #:|53134 Summary:|Sort - Option to expand selection Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|drensink --- Additional comments from [EMAIL PROTECTED] Tue Aug 9 20:27:12 -0700 2005 --- If a column is selected in a spreadsheet that is a subset of a contiguous range of data, provide an option to expand selection to the contiguous range of data when the Data - Sort command is used. - 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 52611] Unpredictable sort range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52611 --- Additional comments from [EMAIL PROTECTED] Tue Aug 9 20:31:08 -0700 2005 --- Related: Issue 53134 Issue specifically related to an option to expand selection to a contiguous range of data when a column is selected that is part of the contiguous range of data. - 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 52611] Unpredictable sort range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52611 --- Additional comments from [EMAIL PROTECTED] Mon Aug 8 20:51:26 -0700 2005 --- fst, Agreed the original issue is not valid, but the fact remains openoffice calc does NOT have the option to expand selection when you have a column selected and it is through the interior of a contiguous range of data. Should this be written up with different and more careful detail in another issue or is there a good reason not having the option is preferred? - 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 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Fri Aug 5 21:10:25 -0700 2005 --- I gave my last comment more thought and realized you can maintain the same behavior openoffice uses now with regular expressions, make the excel imports and exports compatible, and mix the use of both regular expressions and wildcards on the same sheet and in any cells by doing the following. 1. Provide an optional argument to any formula function that will take regular expressions in openoffice, but takes wildcards in excel. 2. If the argument is set to true, assume the function arguments use ? and * as wildcards. 3. If the argument is false or not set, assume the function arguments may contain regular expressions. 4. For documents imported from excel, add the argument set to true to the cell containing the formula. 5. For documents in openoffice assume the argument is not set by default. 6. For documents in openoffice to be exported to excel the user can set the argument to use wildcards. 7. If the user doesnt set the argument, warn that excel does not fully support the use of regular expressions. This would allow the use of the same formula names for both cases and should be fairly easy to code into the existing regular expression code, since it then becomes a simple replacement of ? and * in the arguments fed to the functions with the equivalent 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 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Wed Aug 3 20:08:49 -0700 2005 --- Eike, I did not quite understand your comment at first, because the strings I was using for the DSUM criteria were a string (substring) in a cell (reference to cell being a formula). I now see that you could not just go replacing them all because there is no way to know if they are just an * or ? or actual wildcards short of scanning the whole sheet to see if each is an input into a formula that handles wildcards which would not be so good logic and performance wise. I then wondered what would happen with a spreadsheet using wildcards was imported, but the user wanted to use regular expressions on that same sheet and still have the wildcards calculated. The obvious hangup with that is the ? and * do different things depending which option you want. A good answer to that would be for the functions like DSUM to have two implementations, one that calculates with regular expressions and one that calculates with wildcards. This would create yet another problem since DSUM used in calc is not the same as DSUM in excel, but the same formula name has been used by both excel and calc users, though this might be easy to take care of on import and export by translating DSUM in excel to something like DSUMWILDCARD in calc and something similar on export. This all assumes someone would actually want to use both wildcards and regular expressions on the same sheet, but that might be a bit crazy and I understand implementing the option you propose is probably far quicker, especially if you could have it coded in 2.0 or 2.0.1 instead of later versions. - 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 52611] Unpredictable sort range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52611 --- Additional comments from [EMAIL PROTECTED] Sun Jul 31 23:06:28 -0700 2005 --- That makes more sense. I had gotten in the habit of selecting the entire sheet before doing the sort on both excel and calc, but often forgot to do that first and cancelled the sort and redid the selection. So adding the ability to expand the selection like Excel does and also expanding the selection to the entire sheet in the sort dialog would be a nice enhancement. The summary should be changed to something like Add expand selection and expand selection to entire sheet to sort dialog. Can someone with permissions change it and change status to NEW and RFE and set target. I have confirmed 1.9.118 does not have this capability. Issue 7277 already exists for changing the column selection difference, but I do not see any duplicates of this difference in the database. - 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 52611] Unpredictable sort range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52611 --- Additional comments from [EMAIL PROTECTED] Sun Jul 31 16:07:46 -0700 2005 --- David, You might want to clarify with an example because in 1.9.118 calc seems to select the lists to sort almost the same as Excel when you have a single cell selected. The only differences I see is calc always has the column to the left of the list by default, and excel uses the column of the cell you had selected by default and if you are on an empty cell away from a list calc assumes you are sorting the column and excel warns you there is no list. The other difference is if you select a range that is one column of a multiple column list, excel warns you and gives you an opportunity to expand the selection and calc does not. Excel does not select every row/cell automatically on sort when a single cell is selected, so what exactly did you mean by that? Both calc and excel select an entire list automatically if a cell on or next to the list is selected, so that must not be what you mean. I also fail to see why you think it is so random, when it seems so consistent for the lists of data I used. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344 --- Additional comments from [EMAIL PROTECTED] Sat Jul 30 17:13:09 -0700 2005 --- Instead of disabling regular expressions in the options when opening an excel document that uses wildcard characters or adding a wildcard option to the options, wouldn't it be easier to actually convert the ? and * wildcard characters to regular expressions on import and then convert the regular expressions back to wildcards when exporting back to excel formats, giving a warning for any regular expressions that cannot be converted exactly to wildcards. - 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 43936] ooo produces invalid pdf
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43936 --- Additional comments from [EMAIL PROTECTED] Wed Mar 2 22:52:21 -0800 2005 --- I verified eberlein's document causes the error There is an error processing this page, There was a problem reading this document (135) when opening a pdf file created in Openoffice Beta RC 1.9.m79 on Windows XP Pro using Adobe Reader 6. In the example document if you run the cursor over the second email url, instead of the tool tip showing the proper email address, it shows a trailing closing parenthese at the end of the email address that seems unrelated to the text parenthese. If you turn off URL recognition in Tools - Autocorrect - Options, delete the second email url, turn URL recognition back on and retype the second email URL the tool tip will then properly show the URL without the trailing parenthese and the exported PDF file will not result in an error. When trying to recreate the problem from a new document using font and margin settings as close to possible to the original and the exact same text, no matter how you type the second email address the tooltip will never show a trailing parenthese and the resulting PDF will open without error in Adobe Reader 6. Eberlein, this error might be easier to reproduce if you could describe exactly how you managed to produce the extraneous parenthese in the second email address that doesn't seem to appear when starting from a new document. Since a parenthese would not be a valid character in a URL, it is likely causing the error in Adobe Acrobat Reader. - 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]
[gsl-issues] [Issue 41133] New - Activation Order in OO does not export as Custom Tab Order in PDF
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=41133 Issue #:|41133 Summary:|Activation Order in OO does not export as Custom Tab |Order in PDF Component:|gsl Version:|680m69 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|cp Reported by:|drensink --- Additional comments from [EMAIL PROTECTED] Sat Jan 22 11:07:18 -0800 2005 --- Acrobat Reader 6.0 and 7.0 automatically assume the tab order for a form is left to right top to bottom unless a custom tab order is specified in the PDF format. This only works right for very simple forms. OpenOffice 1.9.62 and 1.9.69 allow you to specify an Activation Order and that works great while in Openoffice. However, the Activation Order in OpenOffice should relate exactly to a custom tab order when exported to a PDF. Acrobat 6.0 can make a document that works with these custom tab orders, but OpenOffice appears not to have that functionality properly coded to the PDF standards. This would be a nice feature to have fixed before the 2.0 release version if possible. - 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]
