Apache OpenOffice (AOO) Bugzilla – Issue 74826
Right and bottom borders: Thin and thick line interchanged
Last modified: 2013-07-21 07:58:18 UTC
I use a BASIC macro to assign borders to tables. Tables can be in WRITER and CALC. Both use the structure com.sun.star.table.BorderLine, but the behavior is different: Take a Border with 2 lines, the first thicker than the other (e.g. InnerLineWidth=35, OuterLineWidth=2, LineDistance=88). Now assign this line to the bottom, left, top, right border of a cell in a table. In Writer: InnerLineWidth is allways thicker (35), OuterLineWidth always thin (2). In Calc: Top and left line width is always thicker(35), bottom and right thin (2). To try it, you can use BorderLiner from ooomacros.org.
@hillerd Please contribute a complete set of sample documents with integrated macros and step by step instruction.
Closing issue due to reporter's inactivity. Pls. feel free to reopen this issue if you find out that the problem is still existing with a current stable OOo version and if you can contribute requested additional information.
closed
reopened, still a bug in OOo 2.2 (sorry, due to a relocation I had no private access to internet for a while; now I am back and here comes your data)
Created attachment 47554 [details] Extension that causes the strange behaviour
Created attachment 47555 [details] ods document with cellborders
Created attachment 47556 [details] text document with table cell and borders
What to do: - start writer or calc - (in writer create a table,) place the curser in a cell of a table - start BorderLiner - select a linestyle with 1 big and a small line (e.g. number 12) - put focus on document - press the keys 2 4 6 8 - this creates the border line around the cell - note that it looks different in writer and in calc Some remarks on the extension: - starting function is "DoBorders" - which calls "SetBordersCell" - which now calls "SetBordersUniqueCell" - which finally assigns the borderstyle "sBorderWork" depending on the key pressed - NB: the extension does not distinguish between tables in Calc and Writer, nevertheless the result is different
This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future.
Reproducible with "AOO 4.0.0-Dev – German UI / German locale [AOO400m3(Build:9702) - Rev. 1503709 (2013-07-17) ]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile 0. Download BorderLiner 1.3.1, in menu 'Tools -> Options -> OOO -> Securety' select an appropriate security level to execute macros. 1. Open new blank Writer document from AOO Start Center and insert Table 3x3 cells 2. Menu 'Tools -> Macros -> Execute -> My Macros -> Borderliner -> Main -> Main' <Execute> > BorderLiner Dialog appears 3. Select Line Type '13' (spin buttons), Color (slider) 'Blue', Sat. + Illu. = 1, apply to Element 4. Click into cell B2 5. On numeric key board (Num Lock enabled) press one by one 2,4,8,6 > will apply border to bottom, left, top, right, As expected outer border line thick, inner border line thin 6. In BorderLiner dialog <Done> > Dialog will close 11. Open new blank Calc document from AOO Start Center 12. Menu 'Tools -> Macros -> Execute -> My Macros -> Borderliner -> Main -> Main' <Execute> > BorderLiner Dialog appears 13. Select Line Type '13' (spin buttons), Color (slider) 'Blue', Sat. + Illu. = 1, apply to Element 14. Click into cell B2 15. On numeric key board (Num Lock enabled) press one by one 2,4,8,6 > will apply border to bottom, left, top, right, As expected outer border line thick, inner border line thin for left and top border line Unexpected: outer border line THIN, inner border line THICK for right and bottom 16. In BorderLiner dialog <Done> > Dialog will close BUT: ---- That has nothing to do with BordeLiner macro, I see the same problem when I apply vorders to a calc cell: 24. Click into Calc document cell F15 25. Menu 'Format -> Cells -> Borders -> Line arrangement = all around Style = 6.55 pt (item 14 in the list box) Expected: thin line inside thick line all around Actual: see result step 15 Additional info: ----------------- a) Very old problem, I already see it in OOo 1.1.5 b) Competitors: LibO: still shows this problem with new borders UI SoftMaker FreeOffice: creates borders as expected, outer thick, inner thin Symphony: Same problem as AOO Gnumeric 1.10.16: Does not offer such cell borders Unbelievable that this problem never has been reported, but I can't find a report.