[sc-issues] [Issue 59745] Cell notes do not move whe n cells are sorted in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59745 --- Additional comments from [EMAIL PROTECTED] Sun Mar 30 08:54:54 + 2008 --- I wouldn't be optimistic: a. The announcements for v3 focus on featuritis, rather than fixing things that don't work. b. I get the sense that the person responsible for notes doesn't actually use them. Notes are the buggiest feature in Calc - they lose position, they lose size, they disappear if they lose focus before you enter data, etc. c. It is still marked as enhancement despite: (i) working properly in Excel, Gnumeric and KSpread, and even earlier versions of OOO. The only place Notes don't work is OOO. (ii) It has 7 separate bugs filed, all related to the same issue (59745 + 64665, 50266, 80174, 63671, 67076, 61253) numerous duplicates (72872, 75478, 76735,..) d. Finally, it is not marked as started - still marked as new, despite being opened in 2005. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85322] Inserting cols mis-updates range arg of functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85322 --- Additional comments from [EMAIL PROTECTED] Thu Jan 17 09:55:50 + 2008 --- Further information: Problem does occur with OOO 2.1 under K(ubuntu). The problem can be turned off/on by deselecting/selecting Expand references when new columns/rows are inserted. So the problem appears to be an excessive behavior of this option. The function range should be expanded in this way when new cols are added within the range not completely to the left of it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 85322] Inserting cols mis-updates range arg of functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85322 Issue #|85322 Summary|Inserting cols mis-updates range arg of functions Component|Spreadsheet Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|undecidable --- Additional comments from [EMAIL PROTECTED] Thu Jan 17 09:42:46 + 2008 --- Selecting columns then inserting columns to the left of a range of columns causes function ranges to be updated incorrectly where the range argument of the function includes the selected columns (explained in English below). What appears to be happening is average(B2:E2) is being internally converted to Average($B2:E2) when columns are added and the column with the function in it is selected as part of the range. I use Average() as an example though it appears to happen with all functions with range arguments. I give an example of both bad behavior and much worse behavior. Both happen in OOO 2.3.1 under WXP both happen in OOO 2.1 under W2000. Do not happen in OOO 2.2 under (K)ubuntu ! EXAMPLE 1 (bad) To Reproduce 1a enter 1,2,3,4 in cells B2, C2, D2, E2 b enter formula in cell B3 =average(B2:E2) c select cols B to E then insert columns (this inserts 4 cols to the left of the range) d the average formula, which should read: =average(F2:I2) now in error reads =average(B2:I2) 2. now select the new col C and insert column. the average formula still reads: =average(B2:I2) ie totally ridiculous. Notes: 1 this is not the same as adding cols within the range, where they should be included in the new range definition. here we are adding cols to the left of a range. 2 Other functions exhibit the same behavior when their argument includes a range, eg sum() though I have not verified all functions. 3 The same happens even if you try to just add 1 col not 4 as in my example. (ie just select col B in step c above) 4 The same happens if your range covers rows rather than cols, and you insert rows. 5 Excel behaves correctly in all cases. EXAMPLE 2 (worse) enter 1,2,3,4 in cells D2, E2, F2, G2 enter formula in cell D3 =average(D2:G2) select cols B to G and insert columns (this inserts 6 cols to the left of the range) the average formula, which should now read: =average(J2:M2) now in error reads =average(D2:M2) Same issue as above, just more surprising that it happens even when the start of the range is two cells to the left of the cell containing the formula. Why is it a Problem Every year when financial institutions add 12 more months, they have to fix formulas. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, 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 59745] Cell notes do not move whe n cells are sorted in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59745 --- Additional comments from [EMAIL PROTECTED] Wed Dec 19 09:47:22 + 2007 --- A Real Workaround! ( excellent repair!) Copy / pasting the affected cells, even in situ repairs the position of the notes. (Moving the cells does the same). Method 1 - Fine So after inserting/deleting the new rows/columns, the notes are all in the wrong place. Select the cells affected by the insertion (eg all cells below the new lines inserted) do a control-C followed by a control-V, which copies and pastes the cells in situ (in their places). The notes are now where they should be. Method 2 - Gross For large sheets, you can just select the whole sheet (click on the top left corner of the sheet) and do the same control-C followed by a control-V, which copies and pastes the whole sheet in situ. Analysis copy/paste and move handle note positions correctly, insert/delete rows/columns, sorting etc do not. I have only verified this in 2.3.1. Effect If I had found this repair years ago my children would not know so many curse words. Hope this is helpful to some other irritated souls! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, 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 59745] Cell notes do not move whe n cells are sorted in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59745 --- Additional comments from [EMAIL PROTECTED] Thu Dec 20 07:50:26 + 2007 --- Agree. That appears to be a bug in copy/paste that happens whether the cells are being pasted to the same place or not, and is independent of the bug under discussion here. For me, at least in 2.3.1, the new size of the note after copy/paste is still acceptable. In fact this issue is filed as bugs 64665 and 50266, and is classified as Defect. Yet this much more serious (and painful) 59745 is classified as Enhancement. It is this great variety of the human intellect that makes us such an interesting species. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, 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 59745] Cell notes do not move whe n cells are sorted in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59745 User undecidable changed the following: What|Old value |New value CC|'glumelle,lars,masayan,mh,|'glumelle,lars,masayan,mh, |pagalmes,pmike' |pagalmes,pmike,undecidable | |' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, 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 59745] Cell notes do not move whe n cells are sorted in Calc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59745 --- Additional comments from [EMAIL PROTECTED] Mon Dec 17 05:32:52 + 2007 --- A comment on the bug, issues this bug causes, and a workaround that works (with some issues) but breaks my mother's heart when I use it. 1. It is the same issue as 80174, 63671, 67076 and 61253 where the same thing happens on adding rows/cols, resizing rows etc. Notes are being tied to an absolute position (that of a particular cell that was once-upon-a-time near the 'noted' cell ) rather than a position always relative to the 'noted' cell. 2. It is especially egregious for finance and accounting use. For example, at the beginning of every year finance people may add 14 more columns (12 new months, year and budget) to large spreadsheets. Almost all cells have notes and all notes are effectively lost as they are so far off screen they are not viewable. For this reason I am casting 3 of the 5 votes I was given on registering, for this bug. 3. A workaround: (which feels a bit like mentioning the name of Lord Voldemoort and offered slightly tongue-in-cheek), is: before adding rows or columns, close the spreadsheet, open it in Excel, add the rows or columns in Excel, then close it again and continue work in OOO. Notes are handled properly, ie positioned relative to the 'noted' cell, in Excel. It is not perfect, as not all formats are transcribed perfectly, but it is better than losing access to the notes. Of course if you don't have access to excel... 4. The argument above that this bug is really an 'enhancement' because the present behavior is as per specification is simply an argument that the bug is in the specification not in the coding. I think both specification and coding issues ought be addressed here. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]