Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Gridlines should disappear (like in Excel) when the background color is changed or text exceeds the border of a cell. This makes for example the creation of nice looking forms easier. | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | skiani <skiani> | ||||||||
Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||||||
Status: | CLOSED WONT_FIX | QA Contact: | |||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | ccheney, frank.loehmann, islobodin, issues, josef.latt, kyoshida, niklas.nebel, openoffice, pagalmes.lists, rail_ooo | ||||||||
Version: | 642 | Keywords: | ms_interoperability, rfe_eval_ok, usability | ||||||||
Target Milestone: | --- | ||||||||||
Hardware: | PC | ||||||||||
OS: | Linux, all | ||||||||||
Issue Type: | PATCH | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Issue Depends on: | |||||||||||
Issue Blocks: | 15522 | ||||||||||
Attachments: |
|
Description
skiani
2002-04-07 13:23:07 UTC
Joost->Falco: reassigned as RFE to you. Grid lines in Calc should be "painted over" when assigning a backgroud to cells. start enhanced summary, set keywords and reassigned issue according to RFE process *** Issue 5721 has been marked as a duplicate of this issue. *** *** Issue 68749 has been marked as a duplicate of this issue. *** Created attachment 51594 [details]
proposed patch
set the issue type to PATCH. So, I should assign this to fl (since this is a usability issue) ? CC'ing Niklas as well. cc me kohei: Seems like this enhancement breaks cell value highlighting. How to reproduce: 1. set the cell background to any color 2. enable Value highlighting in Tools - Options - Calc - View Result: The cell background color is gone. Created attachment 51976 [details]
revised patch
@rail: good finding! Hopefully the revised patch will fix that one. Kohei: seems OK now. Thanks for prompt action. set target to 3.x Created attachment 52108 [details]
slightly improved patch
Slightly improved to also overlap the grid lines on the top and left side of each colored area. This improves the overall appearance. Also remove an unused variable. nn: Please review this patch. If the patch is considered in good shape, then I'll commit it to a CWS. Niklas is on vacation for the next two weeks. New target. To say that I'm upset by this issue is an understatement. I've been using Calc for years, but when I upgraded my Ubuntu distribution, I discovered that the grid line behaviour that I've designed all my spreadsheets around has changed, apparently to suit a bunch of Excel users. I agree that there should be a compatibility option for Excel-created spreadsheets, but I am dumbfounded that you would make it the default behaviour, without, apparently, giving any option to restore the old behaviour. You have, quite simply, broken the design of year's worth of spreadsheets. I strongly request that you amend this patch/change to enable the user to select/de-select this behaviour. I have many reports generated by a program, that are designed for MS Office. They look horrible in OOo... please fix asap! Thanks. Branch-date (feature- and code-freeze) for OOo 3.2 is nearly done. Therefore I change the target of this issue to OOo 3.x. If you think it is a stopper for OOo 3.2 please change the target back. My 1000 cents for the Additional comments from ivarc Fri Oct 24 04:19:13 +0000 2008. I'm adding this comment to all open issues with Issue Type == PATCH. We have 220 such issues, many of them quite old. I apologize for that. We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0. If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know. On the other hand, if the patch is no longer relevant, please let us know that as well. If you have any general questions or want to discuss this further, please send a note to our dev mailing list: dev@openoffice.apache.org Thanks! -Rob This patch is nonsense, IMHO. In Libreoffice this behaviour was introduced and must be changed after heavy protests, so that this feature could be disabled. Because of this and the changed margin I changed from Libreoffice to AOO. Close this very old issue, please. I agree that implementing the patch wouldn't be a good user experience. Therefore I'm closing this issue. |