To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33851
------- Additional comments from [EMAIL PROTECTED] Mon Aug 21 05:46:18 -0700 2006 ------- Kami, > 6. Delete cells > Delete only non-filtered rows. > - Excel 2003 does that. Also OOo does that, so I didn't mention it. > * Copy (Currently it is ok in Calc) I also think so. And also the reference handling within formulas is acceptable, I think. So we can remove Copy from the list and remain with Cut/Paste/Fill > * Delete (Must be fixed ASAP in Calc) As said, this _is_ fixed, don't remember right now exactly when it was changed, some 2.x version. > * Fill cells (Must be fixed ASAP in Calc) I forgot to mention in my last comment above for section #4 that there is also the case of relative references in formulas with Fill. So "must be fixed" doesn't do, we need to specify what should happen and how to adjust the references. My suggestion: do it the same as if one single cell was copied to the clipboard and then pasted to several locations, leaving out the hidden rows. Most logical. And is also what Excel 2003 does. > * Cut (Must be fixed in Calc and Excel) - It should work like Delete Seconded, additionally keep in mind that cut cells will probably be pasted somewhere else. As mentioned, relative references should be adjusted as usual for this pattern. A second Paste then should follow the same logic it already has nowadays when pasting a copied range. > * Paste (Excel is paste only values, Not true. See my section #3 above. Maybe you're confusing this with the paste action after having copied cells from a filtered range. > * Fill series (NA in Excel) Do we need it at all? I don't think so. Applying a series fill onto a filtered range doesn't make much sense, except if you want to enumerate a set of identical values. That again would be a valid usage scenario. > Also what about to implement a button (generally a switch) that show > and hide the filtered data. It might make the life easier, does't it? PLEASE do NOT introduce any new ideas or RFEs here that are not of the topic discussed, life is already complicated enough.. > In my opinion we should slice this issue to parts and implement it one > by one. I also favoured that idea once, however, the reference adjustments that have to be done in the case of cut/copy/paste actions are related anyway, all actions that involve the clipboard need to be specified together in their interaction. We could split off the Fill(Series), but then again, would it be worth it? Fill is simply "copy one cell to several places", and if Series is to be disabled, that's it. If we focus on the specification I think we can do it in one draw. > I think the delete should be the first (along with cut) - PATCH is > provided by ooo-build's guys but we have to test/review it. As the Delete is already implemented there would be only the Cut left. Btw, that go-ooo patch seems to have some draw-backs and makes Calc crash, see issue 68258. Jim (sparcmoz), > Scenario 1 copy/paste - [...] I would be interested if anyone can > explain the reasons for pasting formulas from a filtered copy. Well, usually you paste what you copied, and if you wanted result values instead of formulas you could always use PasteSpecial respectively the <Insert> key. I also do not think that it is of much use in this case though. If we agree to do it different and specify as such, fine. Note however that when pasting on the filtered range, the formulas should be retained and adjusted, as the user probably wants to reuse them. > Scenario 4 fill - [...] I think this feature alone would be large > improvement. The requirement in this case seems clearly specified. Seconded. Do you plead for splitting the Fill scenario off to a separate issue so it could be implemented independently and maybe earlier? It seems we're finally seeing some light at the end of the tunnel.. Eike --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
