Apache OpenOffice (AOO) Bugzilla – Issue 50019
Cannot apply border formatting to multiple selection
Last modified: 2013-08-07 15:14:30 UTC
It is frequently the case that I want to apply formattings to odd collections of cells. I've been doing this to make spreadsheets look readable and aesthetically pleasing for over 15 years. Applying formatting to a "multiple selection" is something I want to do A LOT, but this feature has always been absent from OOo. When I first started using OpenOffice, back when Sun first opened it up, I reported this problem (now absent from your database), and it's still not fixed. If I knew how to fix this problem, I would. Until then, PLEASE, for my sanity, allow formatting for multiple selections. I'm begging on my knees!
Hi, sorry to tell you, but using m106 I'm able to use most of the formatting feature on multiselections. So I've to close this Issue as worksforme. Frank
closed wfm
Please reopen this. I'm using a VERY recent OOo 2.0, and I am not able to apply borders to multiple selections.
To reproduce: 1. Select several non-contigous cells by cntrl-clicking them. 2. Pick a border (either from Format->Cells...; Borders or from Border toolbar button). -> Error message appears: "Cannot apply border to multiple selection" Workaround: create a style (Format->Styles and Formatting) with the desired border, and apply it to the selected cells. This works fine. Added "border" to summary, as other formatting I've tried works fine on multiple selections. Changed type to RFE. There's a bit of ambiguity as to how the desired functionality should work. If you select a rectangular region of cells and add a border, it's added to the region as a whole, not the individual cells. If the multiple selection is a collection of individual disjoint cells, borders on the individual cells would make sense. But what if the multiple selection includes individual cells and rectangular regions? Or contiguous nonrectangular regions? Applying a style avoids this problem by treating everything as a collection of individual cells, but the border formatting is supposed to deal with regions as regions.
As per http://qa.openoffice.org/issue_handling/workflowcharts/RFE_issues_by_QA.sxd, setting to NEW, assigning to requirements. WRT the ambiguity I mentioned, a competitor product (Excel 2004) applies borders region by region, with the regions being the rectangular groups created by single operations inside of the multiselect sequence, i.e. each click or click and drag creates a new region which gets its own border. No merging of regions is done.
*** Issue 8271 has been marked as a duplicate of this issue. ***
*** Issue 65643 has been marked as a duplicate of this issue. ***
*** Issue 79239 has been marked as a duplicate of this issue. ***
a new extension has been released to temporaririly solve this issue until it will be fixed by the OOo team. the extension is called MultiBorders. u can find it here: http://extensions.services.openoffice.org/project/MB
Created attachment 62280 [details] the updated patch for this issue, but I am still not sure whether it has been ok, niklasn, please see it
*** Issue 40574 has been marked as a duplicate of this issue. ***
Created attachment 62400 [details] the updated patch of this issue
taking the issue
One small change was still needed: UnmarkFiltered must be called with a local copy of ScMarkData, because the selection in the view should not be modified. I changed that already and added the patch with the change to CWS "calc50".
nice to see that you fixed this ancient issue!!!
reassigning to QA for verification
verified in internal build cws_calc50
cc
Verified in DEV300m51 Closing
When will be available ? What OOo version ?
it will be available in OOo 3.2 which should be released in late november 09
Great..!!! Thanks...
Congratulations....!!! It is here at last. :-)