Created attachment 112830 [details] double lined upper edge disappears See attachment. I select certain cells and format these cells (ctrl-1), I apply an upper adge, double line. Saving the document and reopening it, I see the double lines have disappeared...
Confirmed with v4.3.6.1 under windows 7 x64. Confirmed with v4.4.0.3 under mint 17.1 x64. In 'line arrangement' I select 'user-defined' and upper arrow. If you select style and/or color, after reload these are set back to the default. Happens when you set the line width to 1.10 pt or under. Also doesn't happen when you save it as xlsx, because the line width is set to 2.50 pt no matter what. But that's another bug, I guess.
*** Bug 90599 has been marked as a duplicate of this bug. ***
works OK in LibreOffice 3.5.0 Build ID: d6cde02 -> regression
This seems to have begun at the below commit. commit 2c62596cf264ef10749d8bfdb2bb2ebef2d98fbc Author: Kohei Yoshida <kohei.yoshida@collabora.com> Date: Mon Mar 3 17:58:11 2014 -0500 fdo#75260: Correctly draw double lines for both Writer and Calc. Fix all sorts of incorrect double line handling in drawinglayer in order to draw thick-thin double line types correctly. Also change handling of border lines in writer tables. There are still some outstanding issues but it's much better than how it was before. Also realized that Word and Excel handle simple thin double lines differently; Word varies widths of all of the lines and the gap whereas Excel only has one fixed size for its double line. For this reason I decided to add a separate double line type (DOUBLE_THIN) to handle Excel's double line. Change-Id: Iaaa353b6e4f998b524262bea59260b4333e0cdb4
*** Bug 92638 has been marked as a duplicate of this bug. ***
*** Bug 93809 has been marked as a duplicate of this bug. ***
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
Hi, This is still the case in 5.1.2 release
Confirmed in LibreOffice 5.1.0.3. I have selected a range of cells, and formatted them using double line edge (right side of range instead of upper edge as in original poster submission). After saving the document, closing LibreOffice Calc, then reopening - double lines disappeared, and opening cell formatting shows that they have *no* cell border.
Confirmed for LibO Calc V5.2.0.0 RC2
The error must occur when the file is saved. Saving a (nearly empty) .ods containing a double bordered range with LibO and reopening it with AOO 4.1.2 leads to the same result: Border missing.
(Everything tested again with 5.2.0.0 RC2) The error did not occur in a test when the simple file was saved in xls (1997-2003) or in xlsx (2003-2013). Reloading such an alien file and saving it again in native ods produced file correctly containing the double border! The original bug did not show as soon as the border width (for the double line!) was set to a minimum of 1.25 point (default setting was 0.75 point). The cycle of creating an example, saving it in xlsx, reloading it, saving it in ods again, an reloading it another time leads to the changed border width of 1.75 pint.
I think this is a duplicate of bug 79260 which is also talking about problems with saving double line borders. See the third comment over there.
*** Bug 79260 has been marked as a duplicate of this bug. ***
Thanks Roeland for pointing this out. (you might consider to do triage like this yourself, when you see an issue like you did now.)
You're welcome Cor. I will!
(In reply to Roeland from comment #16) > You're welcome Cor. I will! Very friendly Roeland! Please now where to find other QA-ers (irc, qa-mailinglist) for discussion and questions. Enjoy ! Cor
Adding Cc: to Kohei Yoshida
*** Bug 88208 has been marked as a duplicate of this bug. ***
I don't understand why this is considered a regression and new bug when Bug 75260 is still open. All those duplicates here should be duplicates there and that one should be of highest importance.
Hi timur, you're right. Closing this one as dupe of that one. *** This bug has been marked as a duplicate of bug 75260 ***
Well, I've reconsidered it and I think it's better to have different bugs as bug 75260 is too general, and this one is only focus on the FILESAVE problem. are they related? of course they're, but betther to keep them splitted. Sorry for the noise.
*** Bug 102299 has been marked as a duplicate of this bug. ***
*** Bug 102858 has been marked as a duplicate of this bug. ***
*** Bug 94736 has been marked as a duplicate of this bug. ***
*** Bug 95458 has been marked as a duplicate of this bug. ***
(In reply to Wolfgang Jäger from comment #12) > (Everything tested again with 5.2.0.0 RC2) > The error did not occur in a test when the simple file was saved in xls > (1997-2003) or in xlsx (2003-2013). > Reloading such an alien file and saving it again in native ods produced file > correctly containing the double border! > The original bug did not show as soon as the border width (for the double > line!) was set to a minimum of 1.25 point (default setting was 0.75 point). > The cycle of creating an example, saving it in xlsx, reloading it, saving it > in ods again, an reloading it another time leads to the changed border width > of 1.75 pint. thanksWolfgang Jager tried the 1.25 point and it worked great cheers:)
(In reply to Wolfgang Jäger from comment #12) > (Everything tested again with 5.2.0.0 RC2) > The error did not occur in a test when the simple file was saved in xls > (1997-2003) or in xlsx (2003-2013). > Reloading such an alien file and saving it again in native ods produced file > correctly containing the double border! > The original bug did not show as soon as the border width (for the double > line!) was set to a minimum of 1.25 point (default setting was 0.75 point). > The cycle of creating an example, saving it in xlsx, reloading it, saving it > in ods again, an reloading it another time leads to the changed border width > of 1.75 pint. Cheers Wolfgang jager changing to 1.25 point worked for me thank you :)
I tried Wolfgangs suggestion of changing the point to 1.25 (default 0.75) and it worked for me so thanx very much and thanx to you all for your help and advice :)
The absolute minimum size for double_thin borders to become visible is 1.15pt (1.14 doesn't work). Double-thin can be hidden until the size is 1.15 in cui/source/tabpages/border.cxx by changing the mnMinWidth from 10 to 23 in { DOUBLE_THIN, 23, &sameColor, &sameColor, &sameDistColor }, I'm still trying to figure out WHY it requires 1.15pt.
A better solution is changing svtools/source/control/ctrlbox.cxx: - if ( bGapChange && nGap > MINGAPWIDTH ) + if ( bGapChange && nGap >= MINGAPWIDTH ) The width size is automatically increased to 1.10 when reloaded. However, that looks like it exposes another bug, where extra borders are added to other cells - perhaps because of duplicate styles.
(In reply to Justin L from comment #33) > However, that looks like it exposes another bug, where extra borders are > added to other cells - perhaps because of duplicate styles. bug 103924 is unrelated, so proposing the fix https://gerrit.libreoffice.org/#/c/30836
Justin Luth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9259fcd40b1749cd421c433bcc436cb335cbbe43 tdf#88827 - double-thin border: MINGAPWIDTH is a valid width It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8fc6be8d2c0fd455b9c461143594457a08a3e250&h=libreoffice-5-2 tdf#88827 - double-thin border: MINGAPWIDTH is a valid width It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
i tested the fix with homebuild LO V6.0 kde4 i have followed the steps in the description even changed the color to red saved the file closed and reopen the double line in red is still there Version: 6.0.0.0.alpha0+ Build ID: 0a7fe0ab0b5b18cfbf1d9f7971d851fe00b6d36a CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group