Apache OpenOffice (AOO) Bugzilla – Issue 8275
more border types (dashed, dotted, etc)
Last modified: 2013-04-19 17:15:42 UTC
mehr Rahmen Arten predefined please; eg top,botom,right ("]") border type !!! or let the user customize border types which are saved as predefined ones Yes! this is even better; then he can also customize style and have them chosen via the normal border icon!!
Hi Bettina, one4you
*** Issue 8396 has been marked as a duplicate of this issue. ***
*** Issue 16490 has been marked as a duplicate of this issue. ***
*** Issue 9812 has been marked as a duplicate of this issue. ***
*** Issue 15311 has been marked as a duplicate of this issue. ***
*** Issue 17393 has been marked as a duplicate of this issue. ***
It is possible in MS-Office (Excel, Word...) to format borders (table, paragraph etc) as dotted lines. We should have this feature too.
Hi! I just noticed the many ! in my first description: they may appear more demanding than they were and are meant! Hmm, just like these... Lars
Just read that my issue (15311) is a duplicate of this one. Here's my point again in hopes of making it clearer. --- It is impossible to distinguish the hairline border (0,05 pt) from the 1 pt border in normal view (100% zoom). Only in zoom factors above 150% you can tell them apart. How about displaying the hairline border in "dotted lines", just like, erm, MS Excel does it? ---
*** Issue 18292 has been marked as a duplicate of this issue. ***
*** Issue 21378 has been marked as a duplicate of this issue. ***
Summary: More border styles - predefined or customizable.
*** Issue 27104 has been marked as a duplicate of this issue. ***
*** Issue 28367 has been marked as a duplicate of this issue. ***
*** Issue 28938 has been marked as a duplicate of this issue. ***
Hi Bettina, This Issue marked as started, please check, or reassign to the developer. I think It is good improvements since many people requesting this. Thanks Screenshot of the Excel and Calc border : http://www.openoffice.org/nonav/issues/showattachment.cgi/15086/excel.gif http://www.openoffice.org/nonav/issues/showattachment.cgi/15087/calc% 20border.gif
*** Issue 30847 has been marked as a duplicate of this issue. ***
*** Issue 27647 has been marked as a duplicate of this issue. ***
I've just been notified that Issue 30847 is a duplicate of this issue. My question is: I've read all the messages posted in this issue, but it is not clear to me whether this issue really covers some missing line types, especially dotted and dashed lines, as available table border types. The absense of dotted/dashed lines affect compatibility with MS Word and Excel, which both have these line types avaiable as table borders. As of the current version of OO.o, dotted/dashed lines are mapped to solid lines. The addition of such line types will immensely improve the compatibility with MS Word/Excel. Kohei
Also note that my above comment applies to both Writer and Calc. I see that this issue itself is filed against the Spreadsheet component, but should also be applied to the Word processor component, as well. If a separate issue should be filed for Writer, I'll be glad to file it. Please let me know if a separate filing is necessary. Kohei
"hairline border" is always as small as the output device can display (on screen -> one pixel) displaying it as dotted would not be WYSIWYG, since you get a solid one when printing. There are no plans changing this. - Hope this explaines it. I don't reassign to framework or another component since this would clear the votes (you'd all have to vote again). keywords set according to new RFE process, reassigning, enhancing summary.
*** Issue 34108 has been marked as a duplicate of this issue. ***
But what about additional border thickness, f.e. 0.5 and .75. In press, 0.05 often gets invisible.
cloph, regarding screen display of "hairline" borders: I understand it's not WYSIWYG if the hairline border ist displayed as dotted on screen. But what's the point if you can't tell a hairline border and a normal 1pt border apart? (Well, unless you have a very big screen resolution or work with 200% zoom - both verly unlikely for most users.) So the obvious difference between these two border types IMHO has to be made *visible* on screen. Am I alone with this? I'll discuss this on the german user ML.
this should really be done for ooo 2.0 - it is a major ms incompatability issue
*** Issue 28973 has been marked as a duplicate of this issue. ***
*** Issue 48746 has been marked as a duplicate of this issue. ***
*** Issue 27903 has been marked as a duplicate of this issue. ***
*** Issue 49517 has been marked as a duplicate of this issue. ***
This still happen in OOo 2.0.1 which assume to interoperate better with MS Office. The bug occurs in both Writer and Calc. Please change the "Issue Type". It is a defect not an enhancement. It prevents proper conversion from MS Office files, loosing an important formatting information. I would also like to see "Target Milestone" set to something tangible.
*** Issue 12049 has been marked as a duplicate of this issue. ***
The original reporter asked for a feature, now we are discussing a very different real bug. I will not plough through the duplicate entries to look for lost information but the development that this issue took is a little peculiar. BTW: other OpenDocument-capable software is displaying borders correctly, even if OO had been used to create it. This is not an enhancement issue anymore. Please, folks, call it a bug, now.
Not only the dotted lines are necessary. The line widths 1.5pt and 2.0pt are needed also! And wave-line... So, the possibility to customize lines is the better solution, but the faster solution is to add the such lines as dots and 1.5/2 pt widths manually.
I have checked the OpenDocument specification. It seems it does not support other thing than no line, line, double line. (http://www.oasis-open.org/committees/download.php/12572/OpenDocument-v1.0-os.pdf) OpenDocument-v1.0-os.sxw 1 May 2005 Copyright © OASIS Open 2002 - 2005. All Rights Reserved. Page 587 of 706 15.5.26 Border Line Width If the line style for a border is double, use the border line properties style:border-linewidth, style:border-line-width-top, style:border-line-width-bottom, style:border-line-width-left and style:border-line-width-right to individually specify the width of the inner and outer lines and the distance between them. The style:border-line-width specifies the line widths of all four sides, while the other attributes specify the line widths of one side only. The value of the attributes can be a list of three space-separated lengths, as follows: • The first value specifies the width of the inner line • The second value specified the distance between the two lines • The third value specifies the width of the outer line The result of specifying a border line width without specifying a border width style of double for the same border is undefined. <define name="style-paragraph-properties-attlist" combine="interleave"> <ref name="common-border-line-width-attlist"/> </define> <define name="common-border-line-width-attlist"> <optional> <attribute name="style:border-line-width"> <ref name="borderWidths"/> </attribute> </optional> <optional> <attribute name="style:border-line-width-top"> <ref name="borderWidths"/> </attribute> </optional> <optional> <attribute name="style:border-line-width-bottom"> <ref name="borderWidths"/> </attribute> </optional> <optional> <attribute name="style:border-line-width-left"> <ref name="borderWidths"/> </attribute> </optional> <optional> <attribute name="style:border-line-width-right"> <ref name="borderWidths"/> </attribute> </optional> </define> <define name="borderWidths"> <list> <ref name="positiveLength"/> <ref name="positiveLength"/> <ref name="positiveLength"/> </list> </define> Can someone confirm it?
Hi mba! Do you have an idea about this issue? Thanks, KAMI
Component of this report is "Spreadsheet". However, some duplicates (Issue 28367) are related to Writer. Is it a global issue ? If so, could the component be updated ? Issue 932 seems also to be a duplicate. May be interesting for Kami (see last posts).
Borders are most often handled by the drawing layer but also by some other components (e.g. tables in Writer). So you will not find a component that fits for all issues. The best fit would be "drawing" as this is the project where most of the implementation will take part. I take the liberty to change the issue accordingly.
Damned, I forgot that this kills the votes. :-( I'm sorry, all users that have voted for this issue: please vote again. Now I'm gonna write 1000 times "you shall not change the component of an issue that has a lot of votes". For the records: when I changed the component, this issue had roughly 50 votes (IIRC).
Isn't there a sort of an administrator who could simply restore those 50 votes? On the other hand, personally, I do not believe in the power of the vote to get an issue resolved. Its like the magic of a funny tire-pattern would protect you from Aquaplaning.
..and all because people don't read all the comments added to an issue ;-) (see comment #22) automatically moving votes is not possible, since the number of votes per issue and per component is limited, so this would create all kinds of conflicts..
*** Issue 82493 has been marked as a duplicate of this issue. ***
Issue #77347 deals (among others) with line styles. Latest comment there (from va Tue Jan 22 10:09:36 +0000 2008) VA: Set target to OOo 3.x. We create child tasks for the different palettes with appropriate targets, e.g. a new Color Palette is planned for 3.0.
*** Issue 94301 has been marked as a duplicate of this issue. ***
Is this issue related or dup of Issue 5929 "Make all line styles available everywhere in OO.o" ?
Looks like everybody is talking about this issue, but nothing is done. I just noticed that I'm unable to use dotted lines in Writer for a table. And this is annoying, as I'd like to have way to just give a slight hint at the cell borders, but not have them fully drawn. Furthermore this is an obvious incompatibility with MS Office.
The dot-line function is mandatory function for Japanese customer who use MS-Office. Many customer who want to use Oo wait for this function. I suppose Oo3.0 would support this function but it has not been resolved. I hope this bug8275 priority rise up and this improvement makes big impact Japanese customer.
Just my two cents: This feature is really an essential one for all linguists working with "Optimality Theory" (phonology). Working with this theoretical framework you need to draw tables with solid and dashed lines between the columns. Dashed lines really have a meaning here: two columns with a dashed line inbetween mean that they are ranked equally. I'm really working on convincing as many people as possible to use OOo here at the university department. But such basic missing features are a huge drawback. I'm not a programmer but as far as I can see every other Word Processor available has the possibility to draw dashed (or at least dotted) lines in tables. OOo can only draw solid ones. I really looked all the related issues (21378, 12949, 30847, 5929, 62003 and many other duplicates) for a long time and thought that if so many people have the same issue since 2002 developers will some day include this. But this was in OOo 1.0! We are now at OOo 3.1 and 7 years later! Why is this feature so complicated to achive?
Its extremely frustrating that you can't add dashed borders to cells in Calc. I used borders all the time before switching from windows to linux for many different reasons. Its definately a major flaw in calc that it doesn't have this and makes Calc inferior to excel in my opinion. It needs to definately be fixed. I'd rather have this simple function than any other feature.
related to both issue 5929 and issue 47120
*** Issue 108121 has been marked as a duplicate of this issue. ***
This issue has been opened in 2002, contains a request to introduce dotted, dashed, and wave lines. When?
It seems that OOo-developers do not want to include dotted and dashed lines in tables. If it is really the case that this is missing in the ODF-specification (I don't know), then this should be changed NOW! We all have waited enough. The missing of this feature makes it impossible for many users to use OpenOffice.org, see my comment from Thu Jun 4 16:58:47 +0000 2009. In some cases loosing dashed lines when sending a .doc to a MicrosoftOffice-User means loosing information. This is crucial when you communicate with editors, for example. And no, drawing lines on top of a table does not solve the issue, those lines are misplaced most of the times when you open the .doc in Word. This problem is simply ignored by the developers. I don't know why. There's not even an official statement on this. And there seems to be no other way to communicate this than in this tracker. However we don't get answers here, too.
Hi joeee. "This problem is simply ignored by the developers. I don't know why. There's not even an official statement on this." Developers never ignore problems (unles by accident of course). Simply too much work, too many wishes, for too little people. What also plays a role for quite some issues, is that some core code for certain modules is being rewritten. Has a big advantange for the future, but also means that other issues depending on that work being finished, have to wait in any case. There have been (official) statements about this situation in quite some issues and quite some mail threads. But it makes little sense to check all open issues to see if such a statement should be added ;-) BTW: I would not be surprised if there is some general explanation on the qa.openoffice.org start page. OK, this does not make that this issue will be solved faster, sorry. Sometimes users/community memebrs are in the position that they have good contacts with a firm or a independent developer. That could lead to an action to submit a patch ..
Am I correct in my understanding of "------- Additional comments from kami_ Wed Jun 20 06:33:46 +0000 2007 ------- I have checked the OpenDocument specification. It seems it does not support other thing than no line, line, double line. (http://www.oasis-open.org/committees/download.php/12572/OpenDocument-v1.0-os.pdf)" that we need to include desired line styles in ODF first and only then ask OO developers to support this feature of the standard. To add more line styles to ODF you need to follow guidance the http://www.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=25143. As a first step the list of desired line styles should be compiled.
Is this a duplicate of Issue 5929 ?
@ qOk: see http://www.openoffice.org/issues/show_bug.cgi?id=8275#desc50
Absence of dotted/dashed border line style im calc harms compatibility with xls. The display of an xls spreadsheet, originally formatted with both solid and dotted/dashed cell borders, looks quite differently in Calc - the visible difference between various border styles in various cells may practically disappear. The visible difference is just striking.
See http://cedric.bosdonnat.free.fr/wordpress/?p=545 and http://cedric.bosdonnat.free.fr/wordpress/?p=568 for some news on this topic.
Please I need this feature !
I recently switched from ms word to OOo, but as an OT phonologist, the lack of dashed lines in tables makes this program impractical and essentially unusable. I will have to decide now if I'm going to switch back, which would be shame giving how many other features I really like! Like joeee, I would love to sell my colleagues on the benefits of OOo, but that's not going to happen without dashed lines in tables.
this enhancement would be much appreciated.
How can a bug with 167 votes be only a "P3" priority. Isn't "P3" merely an average priority (scale is from P1 to P5)? Shouldn't the enormous number of votes bump the priority up by one - to "P2"? If the Open Document Format (ODF) needs to be fixed to include dashed lines, then a bug needs to be created for that here (to track the progress at ODF), made a high priority, and then this bug made dependent on it.
Can I add my plea for this feature to be added? Many people use dotted lines when printing parts of a spreadsheet as they are easier on the eye than solid ones. The 0.05pt line is not a great stand-in as it seems to depend a lot on the dpi of the printer (certainly my printers) and varies from ugly to invisible... Excel has had this feature, probably since v1.0 - I've just taken my OO doc to someone else's PC so I can edit it in MS Office, oh the shame! ;)
Ok. My last comment here. I switch to LibreOffice. Why? LibreOffice has implemented exactly the missing feature described in this thread from its very first release. Obviously it was no so complicated to implement as always stated in this thread here. And as far as I know LibreOffice complies to the OpenDocument-standard as well. Hope AOO will have this feature at sometime. Until then it's not usable for my needs.
It sure would be nice to have more border styles to choose from...or extensions that could add some more fancy/decorative ones.