[sc-issues] [Issue 4695] INDIRECT function fails wit h named cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4695 --- Additional comments from [EMAIL PROTECTED] Fri May 25 18:26:31 + 2007 --- Although XL seems to limit the content of the names to be simple, I don't see why we want to continue that. In which case the same problem that arose with the validation lists comes up, how to interpret a general tokenarray in a context outside a cell. eg define FOO as IF(A1;A2;A3) =INDIRECT(FOO) - 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 4695] INDIRECT function fails wit h named cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4695 --- Additional comments from [EMAIL PROTECTED] Fri May 25 21:04:04 + 2007 --- XL compat will also require support for parsing Sheet!name - 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 56566] Dynamic Range Names in Val idation Lists
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56566 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |45378) Calculate dropdown | |lists --- Additional comments from [EMAIL PROTECTED] Thu May 24 20:46:57 + 2007 --- Created an attachment (id=45378) Calculate dropdown lists - 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 56566] Dynamic Range Names in Val idation Lists
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56566 User jodygoldberg changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Thu May 24 20:57:00 + 2007 --- I came across this issue earlier this week. The attached patch seems to solve the issue. However, there is a feature regression with this approach. Dates will lose their formating. As the values pass through ScMatrix we lose the assigned format, and the display hard codes the default format. The previous patches here took a similar approach, and suffered from the same flaw (along with apparently accepting anything as valid). er: I'll talk to you about the general approach. - 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 21149] Excel filter: Array consta nts are not imported.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21149 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |45344) Use new ScMatrix ab | |ilities, and remove O(n^2) | | code --- Additional comments from [EMAIL PROTECTED] Wed May 23 13:50:01 + 2007 --- Created an attachment (id=45344) Use new ScMatrix abilities, and remove O(n^2) code - 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 21149] Excel filter: Array consta nts are not imported.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21149 --- Additional comments from [EMAIL PROTECTED] Wed May 23 13:50:45 + 2007 --- dr : This patch is in jgarrays now. - 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 76934] Selection trigger when the cursor is in the middle of a token that can n ot be followed by a range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76934 --- Additional comments from [EMAIL PROTECTED] Mon May 7 16:02:53 + 2007 --- fst : it depends on how you define 'defect' :-) I'll likely have a look at this as part of our XL compat display work. - 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 76934] Selection trigger when the cursor is in the middle of a token that can n ot be followed by a range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76934 User jodygoldberg changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Fri May 4 17:17:55 + 2007 --- It's a bit more subtle than that. We can be smarter about when to initiate a range selection. =2+Ok =sin(Ok =3NOTOK It's actually somewhat trickier than that. We need to look at what is on both sides of the cursor position =sin(cursor3 : not ok If we want to really have a decent finger feel we need to start considering the start and end of the _selection_ rather than jut the edit position =startsel3endselcursor : is ok, if we replace the 3 with a range. - 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 32342] Matrix/array constants as a parameter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32342 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |44642) Latest variant of t | |he patch --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 15:19:13 + 2007 --- Created an attachment (id=44642) Latest variant of the patch - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 32342] Matrix/array constants as a parameter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32342 User jodygoldberg changed the following: What|Old value |New value CC|'jodygoldberg'|'dr,jodygoldberg' --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 15:20:46 + 2007 --- Adding Daniel for review of the xls in/out segments. - 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 21149] Excel filter: Array consta nts are not imported.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21149 --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 15:22:03 + 2007 --- The patch in 32342 supports xls in/out - 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 21149] Excel filter: Array consta nts are not imported.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21149 --- Additional comments from [EMAIL PROTECTED] Tue Apr 24 16:00:27 + 2007 --- The patch still has some issues with xls export. After doing a recalc in XL the value is incorrect for SUM({1,2}). It looks like it's getting the wrong operator class. dr : do you have a write up of the new and improved mechanism for ptg classing ? - 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 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 --- Additional comments from [EMAIL PROTECTED] Thu Apr 19 16:54:09 + 2007 --- *** Issue 76526 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 76526] INDIRECT is not XL compati ble
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76526 User jodygoldberg changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE Summary|Formula not imported corre|INDIRECT is not XL compati |ctly |ble --- Additional comments from [EMAIL PROTECTED] Thu Apr 19 16:54:10 + 2007 --- duplicate of the #30172 that will be solved when the XL compatible versions from the R1C1 patch are enabled. *** This issue has been marked as a duplicate of 30172 *** - 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 30172] Calc's INDIRECT function a dditionally should interpret the exclamation m ark as sheet-cell separator.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=30172 User jodygoldberg changed the following: What|Old value |New value IssuesThisDependsOn| |71455 --- Additional comments from [EMAIL PROTECTED] Thu Apr 19 16:57:01 + 2007 --- There are XL compatible versions in mainline now, from the R1C1 work (although they do not handle the .de style ZnSn localization). They'll be generally enabled as part of the OpenFormula work rather than the current INDIRECT_XL approach used in oo-build. Unfortunately none of this will help with the differences in allowable sheetnames which may cause a sheet to be renamed on import. - 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 71455] How to handle OOo - xls - OOo for incompatible functions (eg INDIRECT/ INDIRECT_XL)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71455 User jodygoldberg changed the following: What|Old value |New value CC|'er' |'dr,er' Summary|The result of the INDIRECT|How to handle OOo - xls - |_XL will be Error:502 if t| OOo for incompatible fun |he name of the referenced |ctions (eg INDIRECT/INDIRE |sheet contains accentuated|CT_XL) | letter | --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 16:40:30 + 2007 --- aexl : I would look at the problems differently. The issue is not that INDIRECT_XL can not handle OOo style parsing. We may not want to export it to XL as INDIRECT at all. ps In the future let's open a distinct bug - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 32342] Matrix/array constants as a parameter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32342 User jodygoldberg changed the following: What|Old value |New value Assigned to|er|jodygoldberg Status|STARTED |NEW --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 16:46:19 + 2007 --- er: Here's a simple patch to handle the core elements. xls in/out is almost ready but I'd like to discuss how to handle back compatibility. - 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 32342] Matrix/array constants as a parameter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32342 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |43488) Parse and display i | |nline arrays --- Additional comments from [EMAIL PROTECTED] Fri Mar 2 16:47:40 + 2007 --- Created an attachment (id=43488) Parse and display inline arrays - 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 21149] Excel filter: Array consta nts are not imported.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21149 User jodygoldberg changed the following: What|Old value |New value CC|'dancer' |'dancer,jodygoldberg' - 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 72190] XL style sheet name parsin g for ScAddress
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72190 User jodygoldberg changed the following: What|Old value |New value CC|''|'dr' --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 06:02:04 -0800 2006 --- The audit replicates the initial r1c1 audit. It's unclear if it buys us much in that the inout address still needs to initialized, and right now we're only guaranteed that the table is set. I'll take a stab at it and see. DR : could you have a look at the REFMODE xls export ? - 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 63686] xls import of non-trivial pivots is slow
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63686 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41052) updated patch to ma | |intain the order of insert | |ed items --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:08:07 -0800 2006 --- Created an attachment (id=41052) updated patch to maintain the order of inserted items - 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 72188] DataPilot Optimization of large fields via a hashtable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72188 Issue #|72188 Summary|DataPilot Optimization of large fields via a hashtable Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:10:39 -0800 2006 --- DataPilots with large fields of somwhat unique elements (eg 30k strings) are extremely slow due to O(n^2) algorithms. Add a hash to improve perfomance. - 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 72188] DataPilot Optimization of large fields via a hashtable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72188 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41053) hash the items for | |lookup --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:19:06 -0800 2006 --- Created an attachment (id=41053) hash the items for lookup - 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 72189] IsWordChar implicit cast
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72189 Issue #|72189 Summary|IsWordChar implicit cast Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:23:27 -0800 2006 --- As discussed with er. ScCompiler::IsWordChar had an unfortunate implicit cast from a sal_Unicode to a String in an inlined function that is clearly a hotspot during parsing. The impact is minimal due to the inline test for ascii-ness but the problem can be removed entirely by an simple interface change. - 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 72189] IsWordChar implicit cast
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72189 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41054) tweak the interface | | to take a String, pos tup | |ple in place of a sal_Unic | |ode --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:24:09 -0800 2006 --- Created an attachment (id=41054) tweak the interface to take a String, pos tupple in place of a sal_Unicode - 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 71455] The result of the INDIRECT _XL will be Error:502 if the name of the refer enced sheet contains accentuated letter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71455 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41055) minor patch --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:31:08 -0800 2006 --- Created an attachment (id=41055) minor patch - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 71455] The result of the INDIRECT _XL will be Error:502 if the name of the refer enced sheet contains accentuated letter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71455 --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:32:34 -0800 2006 --- Yes I realize that this adds exactly the performance degradation that I just submitted a patch for :-) Fixing that will require more of an interface change in the XL style header parsing. - 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 72190] XL style sheet name parsin g for ScAddress
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72190 Issue #|72190 Summary|XL style sheet name parsing for ScAddress Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:39:21 -0800 2006 --- Attached is a minor update to the r1c1 patch. The pieces are small enough that I'll file both patches in one issue. 1) corrects a problem in the XL sheet name parsing For addresses with no sheet name qualifiers 'A1' vs 'Sheet!A1' the code always returned the 1st table (all of our tests happened to be from sheet1 :-) The interface was not exactly clear that it expects the current table to be passed in via the result parameter. This raises some issues for the Details argument that I added. We may be able to do without it's address field, but it will take another code audit to do it. Is it worth it ? 2) adds xls export As part of the lobotomization of the r1c1 patch to get it to go in without visible change I left out xls import/export. On futher reflection the xls export is safe and moves r1c1 that much closer to being turn key when a UI is available. - 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 72190] XL style sheet name parsin g for ScAddress
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72190 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41056) Use the current tab | |le from the result parm ra | |ther than reseting to tabl | |e 0 --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:40:05 -0800 2006 --- Created an attachment (id=41056) Use the current table from the result parm rather than reseting to table 0 - 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 72190] XL style sheet name parsin g for ScAddress
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72190 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |41057) xls export --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:40:27 -0800 2006 --- Created an attachment (id=41057) xls export - 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 71455] The result of the INDIRECT _XL will be Error:502 if the name of the refer enced sheet contains accentuated letter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71455 User jodygoldberg changed the following: What|Old value |New value Issue type|DEFECT|PATCH OS/Version|Linux |All Platform|PC|All - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72188] DataPilot Optimization of large fields via a hashtable
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72188 User jodygoldberg changed the following: What|Old value |New value Issue type|ENHANCEMENT |PATCH - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72189] IsWordChar implicit cast
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72189 User jodygoldberg changed the following: What|Old value |New value Issue type|ENHANCEMENT |PATCH - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72190] XL style sheet name parsin g for ScAddress
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72190 User jodygoldberg changed the following: What|Old value |New value Issue type|DEFECT|PATCH - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 62494] xls import of pivot tables loses autoformating
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62494 User jodygoldberg changed the following: What|Old value |New value OtherIssuesDependingOnTh| |68544 is| | --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:47:12 -0800 2006 --- This doesn't strictly block the 68544, but the patch there does import and export what appears to be the autoformat id for the pivot table. - 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 68544] Pivot Report without Forma t layout ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68544 --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:48:15 -0800 2006 --- Any thoughts here ? It involves ODF changes which need to be proposed sooner rather than later. - 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 20857] R1C1 notation for the spre adsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20857 User jodygoldberg changed the following: What|Old value |New value OtherIssuesDependingOnTh|49499,59362 |49499,59362,71455,72190 is| | - 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 72191] Need a UI to select which cell address convention to use
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72191 Issue #|72191 Summary|Need a UI to select which cell address convention to u |se Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Fri Dec 1 10:56:50 -0800 2006 --- The core changes to enable cell formulas to be displayed using XL style R1C1 and A1 notation are in place. However, there are no use visible hooks for selecting which of the 3 current styles to use - OOo - XL A1 ([book]Sheet1:Sheet2!A1:A3 and A:C) - XL R1C1 ( !RC:RC[2]) there is a potential to eventually add Lotus style references here and if possible to use this selection to choose the entire formula convention rather than just the address spec. eg - Use a locale specific argument separator foo(a,b,c) Could someone on the usability/UI team make a proposal ? - 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 20857] R1C1 notation for the spre adsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20857 User jodygoldberg changed the following: What|Old value |New value IssuesThisDependsOn|69883 |69883,72191 - 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 71455] The result of the INDIRECT _XL will be Error:502 if the name of the refer enced sheet contains accentuated letter
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71455 User jodygoldberg changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |STARTED --- Additional comments from [EMAIL PROTECTED] Wed Nov 15 09:15:54 -0800 2006 --- The problem will be with the new XL style parsing that went in with the r1c1 code. - 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 71343] exported OLE2 property sec tions have incorrect sizes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71343 Issue #|71343 Summary|exported OLE2 property sections have incorrect sizes Component|framework Version|680m189 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|tm Reported by|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Wed Nov 8 06:20:46 -0800 2006 --- The gnome project's libgsf generated warnings on OLE2 property sets generated by OLE2. It turns out that gsf uses the ole2 section size to calculate the size of the last property rather than OOo's mechanism of reading based on the type of the property. The code is OOo had a simple flaw it measured size as start = stream.Tell() foreach prop { prop.write() } size = stream.tell - start which does not work because prop::write does a seek back to the header to store the starting offset. The section size becomes start+num_props*8 - 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 71343] exported OLE2 property sec tions have incorrect sizes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71343 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |40431) Proposed fix --- Additional comments from [EMAIL PROTECTED] Wed Nov 8 06:21:36 -0800 2006 --- Created an attachment (id=40431) Proposed 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]
[framework-issues] [Issue 71343] exported OLE2 property sec tions have incorrect sizes
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71343 User jodygoldberg changed the following: What|Old value |New value CC|''|'dr' OtherIssuesDependingOnTh| |64516 is| | --- Additional comments from [EMAIL PROTECTED] Wed Nov 8 06:35:39 -0800 2006 --- Thankfully this looks fairly recent. 2006/04/27 13:36:16 dr 1.35.2.1: #i64516# rework OLE property set filters - 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 68544] Pivot Report without Forma t layout ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68544 User jodygoldberg changed the following: What|Old value |New value CC|'jodygoldberg'|'dr,jodygoldberg' --- Additional comments from [EMAIL PROTECTED] Wed Nov 8 06:41:36 -0800 2006 --- Here's a patch including XLS import/export and a proposed odf extension. There is still some problems with - load xls - save ods - reload ods but they seem to be different. I'll open a new bug there. - 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 68544] Pivot Report without Forma t layout ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68544 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |40435) Add ScDPOutput:;Hea | |derLayout and i/o for odf | | xls --- Additional comments from [EMAIL PROTECTED] Wed Nov 8 06:43:37 -0800 2006 --- Created an attachment (id=40435) Add ScDPOutput:;HeaderLayout and i/o for odf xls - 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 68544] Pivot Report without Forma t layout ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68544 User jodygoldberg changed the following: What|Old value |New value Status|NEW |STARTED OS/Version|Linux |All --- Additional comments from [EMAIL PROTECTED] Fri Oct 6 06:17:02 -0700 2006 --- There are two distinct issues that are breaking the layout. 1) 0 is being treated as an 'empty' rather than zero, which loses one row. 2) The header layout that is losing the other row seems to have several significant factors. : The number of col/row/data fields : The 'Classic' table format (the default default value) sets a flag. In the Office Open XML it is called 'gridDropZones' and Office12 sets it via a ui that calls it a compatibility feature. I have not managed to set it with anything other than the Classic autoformat in released versions. It's unclear if this flag is set distinctly somewhere in the xls format (possibly in SXVDEX). Suggested course of action. I've started on the 0 vs empty problem. The main difficulty there is that we're going to need an ODF extension to handle the different semantics without breaking backwards compat. - 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 45843] GETPIVOTDATA function miss ing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 --- Additional comments from [EMAIL PROTECTED] Fri Sep 1 11:02:59 -0700 2006 --- The plan is to do some serious reworking of the datapilot internals to convert the model from a string based to index based operation (something closer to the XL 'pivotcache'). Given that the approach in the latest patch takes an invalid approach I'll likely delay working on this until after the cache work is complete. If someone else is interested they are welcome to 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]
[tools-issues] [Issue 66155] ~/.cwsrc parsing broken . ..
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66155 --- Additional comments from [EMAIL PROTECTED] Wed Jun 7 08:19:44 -0700 2006 --- 1) You're correct. That was a last minute change that I did not review properly sorry about that. 2) blah. This brings back unpleasant memories of why I haven't used perl in a while. Thanks for the review. - 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]
[tools-issues] [Issue 66155] ~/.cwsrc parsing broken . ..
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66155 --- Additional comments from [EMAIL PROTECTED] Tue Jun 6 08:28:54 -0700 2006 --- Thank you. I'd also suggest a warning that failure to connect to server is likely related to an invalid password. - 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 49499] address function should s upport 5 parameters
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49499 --- Additional comments from [EMAIL PROTECTED] Thu Apr 6 06:52:29 -0700 2006 --- This is handled by the r1c1 work which replaces address with something simpler. - 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 63686] xls import of non-trivial pivots is slow
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63686 --- Additional comments from [EMAIL PROTECTED] Tue Mar 28 11:33:22 -0800 2006 --- dr : I wondered about that but decided that the code in sc/source/filter/xml/XMLExportDataPilot.cxx was probably more recent and probably the normative source. There is also code in ScDPSaveDimension::GetExistingMemberByName that does not check for NULL. nn : Do we need the extra protection ? - 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 63686] New - xls import of non-tr ivial pivots is slow
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63686 Issue #:|63686 Summary:|xls import of non-trivial pivots is slow Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Mon Mar 27 12:13:17 -0800 2006 --- Importing xls files with non-trivial pivot tables (6000 entries) takes too long. The filter appears to use O(n^2) lookups. The attached patch replaces the list with a hash and acheives significant speedups. The current code does not seem to require that names be unique on insertion but does assume that they are unique on extraction. Additionally code of the form for (i = 0 ; i list.length() ; i++) use (list.getElement (i)); Should be avoided. The attached patch is more likely to be interesting to nn than dr. - 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 63686] xls import of non-trivial pivots is slow
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63686 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=35294) Use a hash | |instead of a list --- Additional comments from [EMAIL PROTECTED] Mon Mar 27 13:28:27 -0800 2006 --- Created an attachment (id=35294) Use a hash instead of a list - 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 62491] data pilot mis-groups dat a with page fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62491 User jodygoldberg changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Thu Mar 9 08:04:55 -0800 2006 --- There is clearly more going on here than meets the eye. I've just replicated this test using Office 2k, XP, and 2003 and all 3 are able to display the content of the sheet on refresh. It's unclear (at least to me) when XL starts numbering fields internally. Please stop closing this report. I'm working on fixing it and need a place holder for the eventual patch. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 62491] data pilot mis-groups dat a with page fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62491 User jodygoldberg changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Wed Mar 8 20:14:54 -0800 2006 --- We're clearly looking at different versions of XL. Office XP is what created that file and it does not lose the content on refresh. What version of XL are you testing with and what does it do for you ? - 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 62502] When pasting text into Ca lc using text import it does not allow you to click save and does not ask you to save on clo se.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62502 User jodygoldberg changed the following: What|Old value |New value CC|''|'mmeeks' Assigned to|mmeeks|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Tue Feb 28 09:37:06 -0800 2006 --- I'll have a look now. - 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 62502] When pasting text into Ca lc using text import it does not allow you to click save and does not ask you to save on clo se.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62502 --- Additional comments from [EMAIL PROTECTED] Tue Feb 28 15:17:09 -0800 2006 --- I'm having no luck replicating this with current go-oo builds. The patch that would be involved seems correct. Could you specify exactly what build or debian package version you are using ? - 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 45843] GETPIVOTDATA function mis sing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 User jodygoldberg changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Feb 27 07:43:05 -0800 2006 --- re: CONTINUE handling. blah my other tests were working smoothly I'll examine this now to find the misunderstanding. different summary function or displayed value is selected The XL variant does not support custom agregation routines. There seems to have been some attempt but it does not work as far as I can tell. By definition it returns the sum. As an extension we could consider supporting using the field aggregator, or allowing user specified aggregation in the target field specifier, but that would be an extension. Getpivotdata should be limited to values that are actually part of the DataPilot table This is an interesting point for debate. XL apparently has this restriction. A filter that has no visible subtotal will return a REF, but that seems like a pointless limitation. Re: Refreshing after XL import. I realize it is a kludge. We're being hit with several layers of problem, that was a solution that will solve some of them at the expense of others. 1) Having GetPivotData depend on ScDPOutput means that it is pulling values from the _generated_ result. On xls import we do not appear to be generating based on the cached data and instead use the in sheet. Throw in a few other bugs and the DPOutput has a tenuous link to what is on the screen until we ::Output. The re are two potential solutions for GETPIVOTDATA. Either pull the data off the sheet, which seems impossibly kludgy (there is no layout information), or ensure that the DPOutput is generated using the cached values with a matching aggregation approach to Ms XL. The latter seems best, but will take some time. 2) GetPivotData is being calculated before the pivot is loaded and generating a #REF. We need to trigger a recalc for things that use them. I looked at two mechanisms. a) Keep track of all formulas that use GETPIVOTDATA on xls import and recalc them after loading the pivots. This became unyeildy as all of the potential callers were considered (cells, validation, names). b) mark the content of the pivot table as being dirty to force all things that reference it to recalc. This is less clean, but much simpler. It is also a useful side effect of regeneration. 3) It was the easiest way to do what RefreshAfterLoad + SetButtons does for the ods importer. Although it does lose us the autoformating. Solving these problems will take some time. For now, I'm advocating the 1 line sledge hammer of ScDPObject::Output. - 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 45843] GETPIVOTDATA function mis sing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 --- Additional comments from [EMAIL PROTECTED] Mon Feb 27 09:32:22 -0800 2006 --- Ahh, interesting. I was testing with different aggregators on the col/row fields which produced some nonsensical results when using the autogenerated getpivotdata feature. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 45843] GETPIVOTDATA function mis sing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=34406) new version of | |getpivotdata against m156 --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 07:32:50 -0800 2006 --- Created an attachment (id=34406) new version of getpivotdata against m156 - 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 62491] New - data pilot mis-group s data with page fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62491 Issue #:|62491 Summary:|data pilot mis-groups data with page fields Component:|Spreadsheet Version:|680m156 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 09:44:50 -0800 2006 --- Refreshing the attached xls clears the displayed 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 62490] New - xls import of pivot tables does not create in sheet controls
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62490 Issue #:|62490 Summary:|xls import of pivot tables does not create in sheet |controls Component:|Spreadsheet Version:|680m156 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 09:27:54 -0800 2006 --- Loading an xls creates the ScDPObject but does not create the in sheet controls. For now I've hacked a call to ScDPObject::Output after the import but that is suboptimal. The ods importer calls RefreshAfterLoad but that assumes that button attributes have already been set, which is not the case for xls. - 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 45843] GETPIVOTDATA function mis sing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 09:30:04 -0800 2006 --- Beyond the specific implementation of GETPIVOTDATA testing the function highlighted a few problems with the pivot data import from xls. The first is that the function depends on the pivot tables existing to produce results. The xls importer does a recalc on import _before_ loading the pivots. I attempted a few elegant solutions to this but decided to fall back on a brute force ScDPObject::Output call after the pivot is created. As mentioned in #62490 that call forces the generation of in sheet controls. It has the additional side effect of regenerating the view of the data pilot in the sheet, which triggers a recalc for getpivottable users. - 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 62491] data pilot mis-groups dat a with page fields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62491 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=34415) sample file | |that loses pivot data on | |refresh --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 09:45:32 -0800 2006 --- Created an attachment (id=34415) sample file that loses pivot data on refresh - 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 62493] New - xls import of pivot table loses custom field settings
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62493 Issue #:|62493 Summary:|xls import of pivot table loses custom field settings Component:|Spreadsheet Version:|680m156 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 10:15:07 -0800 2006 --- The attached file has custom sum and average settings for the Channel field. They are not imported. Is this functionality supported ? - 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 62493] xls import of pivot table loses custom field settings
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62493 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=34418) sample file | |that loses the SUM and | |AVERAGE rows when | |refreshed. --- Additional comments from [EMAIL PROTECTED] Thu Feb 23 10:16:11 -0800 2006 --- Created an attachment (id=34418) sample file that loses the SUM and AVERAGE rows when refreshed. - 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 38759] MIN/MINA MAX/MAXA should return 0 if all parms are empty
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=38759 User jodygoldberg changed the following: What|Old value |New value Summary|=MAX and =MIN gives error |MIN/MINA MAX/MAXA should |with blank cells |return 0 if all parms are | |empty --- Additional comments from [EMAIL PROTECTED] Mon Jan 2 12:52:10 -0800 2006 --- This is an MS Excel compatibility issue. Muthu is working on a patch. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20496 --- Additional comments from [EMAIL PROTECTED] Mon Dec 19 06:53:36 -0800 2005 --- You will be able to enter +A1 or (with my R1C1 patch) +R1C1 and have that interpreted as a formula. The focus of this discussion is a specialization of the patch to avoid making it create a formula when it is not needed. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20496 --- Additional comments from [EMAIL PROTECTED] Fri Dec 2 08:04:01 -0800 2005 --- giuliano1969 : The patch does not need to handle the case of '+table.A1' because it is written to look only for the very specific case of [+-]{formated number}. table.A1 is not a number nor is .A1. The closest we would come to a problem would be with some of the work I'm doing for R1C1 style addresses. That change also adds support for MS Excel style A1 addresses. Which include full row references of the form '2:2'. Which means that a user could conceiveable enter +2:2. However, even that would not cause a problem because 1) 2:2 is not a valid number. We would match only on the leading 2 then fail 2) Even if there is a custom number format that could somehow produce 2:2 (something like #:0). It makes absolutely no sense as an expression. Anyone that goes that far out of their way deserves to have '+2:2' get entered as the constant 22. - 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 58752] New - full column selectio n does not notify InputHandler
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58752 Issue #:|58752 Summary:|full column selection does not notify InputHandler Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Thu Dec 1 12:00:24 -0800 2005 --- 1) Start editing a cell with an expression =SUM( 2) Use the arrow keys to select a cell 3) Hit ctrl-space to select a full column The inputhandler for the expression does not change to reflect that the full column has been selected, but the column is drawn in reverse video. (m141) - 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 55735] Improve the accuracy of E RF/ERFC for large x value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55735 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=31375) The variant I | |used in ooo-build --- Additional comments from [EMAIL PROTECTED] Fri Nov 11 07:52:24 -0800 2005 --- Created an attachment (id=31375) The variant I used in ooo-build - 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 20857] R1C1 notation for the spr eadsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20857 --- Additional comments from [EMAIL PROTECTED] Thu Nov 10 09:14:55 -0800 2005 --- development is still underway on the patch. A CWS has been created for it, but only about 2/3 of the sc module currently builds. This change modifies quite a bit of low level api. - 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 55735] Improve the accuracy of E RF/ERFC for large x value
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55735 --- Additional comments from [EMAIL PROTECTED] Wed Nov 9 06:52:05 -0800 2005 --- Nice work I'll put this in ooo-build temporarily. One small style/performance comment on the patch. Why use stl vectors for constants ? You would be better off using static const double qn[] = { . } rather than setting up the constants each time it's called. For the erfc0600 case jsut replicate the loop or use pointers to select which arrays to use. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20496 --- Additional comments from [EMAIL PROTECTED] Tue Nov 1 07:45:41 -0800 2005 --- rubinj : not quite. -123 is not the same as =-123 It should be considered a constant rather than an expression whose value is constant. -123-12 would be the same a =-123-12 because (ignoring const folding) it requires some operations. That is why the proposed patch does the numbermatch test. - 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 56646] New - Redraw problem on al ignment change
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56646 Issue #:|56646 Summary:|Redraw problem on alignment change Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|ui Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Tue Oct 25 11:40:55 -0700 2005 --- If the number of rows covered by an edit is changed by an alignment change the new rows are redrawn rather than the old. a) Open the attached file b) Begin editing cell B5 c) Toggle the alignment Right then Left note the detritus where the edit used to be. - 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 56646] Redraw problem on alignme nt change
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56646 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30829) sample file --- Additional comments from [EMAIL PROTECTED] Tue Oct 25 11:41:42 -0700 2005 --- Created an attachment (id=30829) sample file - 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 56149] CVS access to sc module
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56149 User jodygoldberg changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Thu Oct 20 05:41:44 -0700 2005 --- Tunnel works smoothly. Thank you. - 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 56149] CVS access to sc module
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56149 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30614) DSA public key --- Additional comments from [EMAIL PROTECTED] Tue Oct 18 08:05:47 -0700 2005 --- Created an attachment (id=30614) DSA public key - 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 56149] CVS access to sc module
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56149 --- Additional comments from [EMAIL PROTECTED] Tue Oct 18 08:09:24 -0700 2005 --- Attaching the more useful DSA key in place of the original. - 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 56149] New - CVS access to sc mod ule
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56149 Issue #:|56149 Summary:|CVS access to sc module Component:|www Version:|current Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|TASK Priority:|P3 Subcomponent:|openoffice.org CVS Assigned to:|ssh2key Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Mon Oct 17 07:17:49 -0700 2005 --- I'd like to get cvs access to the sc module. Eventually for the sch, sch2 modules but that is not an immediate requirement. The current goal to create a cws for my R1C1 work. PS The sc project page lists 'Project Owner: Niklas Nebel' with the email address as [EMAIL PROTECTED] which is not listed with issuezilla. You may want to change that to the '[EMAIL PROTECTED]' address. - 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 56149] CVS access to sc module
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56149 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30559) ssh2 public key --- Additional comments from [EMAIL PROTECTED] Mon Oct 17 07:19:23 -0700 2005 --- Created an attachment (id=30559) ssh2 public key - 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 20857] R1C1 notation for the spr eadsheet
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20857 User jodygoldberg changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Wed Jul 27 09:25:15 -0700 2005 --- I've got a preliminary patch that adds R1C1 style notation support. I'll attach i t here when the 3d ref support is fixed, and I've patched the rest of the calls to the Parser and Formater to use the correct convention. It will be interesting to discuss the best notation for sheet references in R1C1 format. MS Excel does not need to contend with relative vs absolute sheet refs, and the OOo std $sheet!addr seems inconsistent in R1C1 form for relative sheets where we would end up with sheet!r1c1 as opposed to something more consistent like (and I'm just making this up) S[-1]!R1C1 or S[-1]R1C1 While I'm in here I'm also adding support for full col and full row references so that things like R1:R2 or C:C4 work. Sheet!R1C1 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 20496] Enhanced formula input
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=20496 --- Additional comments from [EMAIL PROTECTED] Wed Jul 20 10:29:07 -0700 2005 --- This is the right idea, but the proposed implementation could use a bit more depth. We can't just check for a leading '+' (and '-') that will produce some false positives. +123 or -123 are _not_ formulas. They need to marked as constants, not expressions that are constant. - 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] =?UTF-8?B?W0lzc3VlIDQ5OTA2XSAgUk9XIGFuZCBDT0xVTU4gZnVuY3Rpb25zIA==?= =?UTF-8?B?aW4gYXJyYXkgZm9ybXVsYXMgcmVwZWF0IHRoZSBpbml0aWFsIHZhbHVl?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49906 User jodygoldberg changed the following: What|Old value |New value CC|''|'jodygoldberg' Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Mon Jun 13 12:54:20 -0700 2005 --- The matrix case is a bit different. - 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] =?UTF-8?B?W0lzc3VlIDQ5OTA2XSAgUk9XIGFuZCBDT0xVTU4gZnVuY3Rpb25zIA==?= =?UTF-8?B?aW4gYXJyYXkgZm9ybXVsYXMgcmVwZWF0IHRoZSBpbml0aWFsIHZhbHVl?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49906 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=27145) Sample of the | |matrix case --- Additional comments from [EMAIL PROTECTED] Mon Jun 13 12:55:24 -0700 2005 --- Created an attachment (id=27145) Sample of the matrix case - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] =?UTF-8?B?W0lzc3VlIDQ5OTA2XSAgUk9XIGFuZCBDT0xVTU4gZnVuY3Rpb25zIA==?= =?UTF-8?B?aW4gYXJyYXkgZm9ybXVsYXMgcmVwZWF0IHRoZSBpbml0aWFsIHZhbHVl?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49906 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=27146) handle the | |matrix case too. --- Additional comments from [EMAIL PROTECTED] Mon Jun 13 12:56:51 -0700 2005 --- Created an attachment (id=27146) handle the matrix case too. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 50248] Excel import: Major performance problem importing shared formulas
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50248 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=26984) updated patch | |that searches list in | |order --- Additional comments from [EMAIL PROTECTED] Tue Jun 7 09:11:15 -0700 2005 --- Created an attachment (id=26984) updated patch that searches list in order - 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 50248] Excel import: Major performance problem importing shared formulas
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50248 --- Additional comments from [EMAIL PROTECTED] Tue Jun 7 09:12:07 -0700 2005 --- This patch passes your shared expr tests. Are you sure that overlapping shared ranges are legal ? - 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 50248] New - Major performance problem importing shared expresions from xls
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50248 Issue #:|50248 Summary:|Major performance problem importing shared expresions |from xls Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|PATCH Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|jodygoldberg --- Additional comments from [EMAIL PROTECTED] Thu Jun 2 08:48:53 -0700 2005 --- On several large workbooks (9meg and up) the number of shared expressions gets large (1000). The current approach of walking a list several times becomes time critical. My baseline testing was taking 45s to load a file that could load in gnumeric/XL in 5. The attached patch knocked that down to 25s. - 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 50248] Major performance problem importing shared expresions from xls
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=50248 User jodygoldberg changed the following: What|Old value |New value Attachment is patch| |Created an attachment | |(id=26835) patch to hash | |on the top left corner of | |the shared region, and | |decrease the number of | |iterations of the list | |when falling back. --- Additional comments from [EMAIL PROTECTED] Thu Jun 2 08:51:11 -0700 2005 --- Created an attachment (id=26835) patch to hash on the top left corner of the shared region, and decrease the number of iterations of the list when falling back. - 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 49498] =info function to provide some environment information
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49498 --- Additional comments from [EMAIL PROTECTED] Fri May 20 08:30:59 -0700 2005 --- re 'Windows (32-bit)' the only use I have ever seen for this is in attempts to differentiate windows from mac. I think we're safer to pretend to be win excel, than provide real info. Most of the other values are somewhat bogus on modern architectures. - 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 47724] adding #Div/0! error in calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47724 --- Additional comments from [EMAIL PROTECTED] Mon May 9 10:14:22 -0700 2005 --- nn : There are two goals. 1) Improve user readability '#DIV/0' is much clearer than 'Err: 503' 2) Improve MS Excel compatibility. We'll be able to avoid misexporting the error type and having things jump when loaded into XL. Both seem best handled on a patchwork basis, making incremental improvements as we find more cases. I've attached a test workbook with some obvious candidates from the statistical functions. We should expand it as people verify other ideas. - 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 47644] improved error values on XL import
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47644 User jodygoldberg changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=25938) tests of | |conditions that should | |return DIV/0 --- Additional comments from [EMAIL PROTECTED] Mon May 9 10:15:26 -0700 2005 --- Created an attachment (id=25938) tests of conditions that should return DIV/0 - 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 47724] adding #Div/0! error in calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47724 --- Additional comments from [EMAIL PROTECTED] Tue Apr 19 12:03:59 -0700 2005 --- The patch should be extended to handle matrix cases. - 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 45843] GETPIVOTDATA function missing ...
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45843 --- Additional comments from [EMAIL PROTECTED] Tue Apr 12 14:42:06 -0700 2005 --- The xls import and export will break when loading biff8 files. In 97/2k getpivotdata had 2 args http://support.microsoft.com/?kbid=211949 It was not until biff8x in XP/2003 that the signature changed. MS did not appear to change the function ordinal - 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 28707] load MMMM date format instead of MMMMM
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=28707 --- Additional comments from [EMAIL PROTECTED] Thu Mar 31 06:16:41 -0800 2005 --- I ran into this too in the OOo importer in gnumeric. With only two flags - short - textual There's only room to select 4 options. this will require some addition flags. - 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 3866] The function NETWORKDAYS accepts negative values as inputs, instead of giving error message.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=3866 --- Additional comments from [EMAIL PROTECTED] Thu Mar 31 06:37:04 -0800 2005 --- re: er Fri Apr 5 02:02:52 -0800 2002 Actually I think the reverse is true. It is a bug in NETWORKDAYS. That function needs to validate it's inputs, including the date serials. Checking for a negative sign is incorrect. eg if A1=-10, then passing -A1 is correct. It's up to the function to handle things. - 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]