The attached XLSX file has an rectangle shape formatted as blue background and white text. When resave this file with LibreOffice, the blue shape background color is gone. This makes the text on the shape not visible.
Steps to Reproduce:
1. Resave the attached shape.xlsx file to shape2.xlsx.
2. Open shaple2.xlsx compare with shape.xlsx.
---> Shape's blue background color is gone.
Reproduced in the following versions:
Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Locale: zh-CN (zh_CN)
Version: 220.127.116.11 (x64)
Build ID: bcace328aabc4c8c10b56daa87da0a2ee6579b5a
Threads 4; Ver: Windows 6.19; Render: default;
Locale: zh-CN (zh_CN)
Created attachment 121871 [details]
Created attachment 121872 [details]
shape2.xlsx (resaved from shape.xlsx)
I can confirm with Version: 18.104.22.168.alpha0+
Build ID: 75f0f9d5538577e0d4923b4d46ba6f88b6199814
CPU Threads: 4; OS Version: Linux 4.2; UI Render: default;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-01-12_14:23:15
and Version: 22.214.171.124.alpha2+
works OK in LibreOffice 3.5.0
Build ID: d6cde02 -> regression
This seems to have begun at the below commit.
Adding Cc: to Matúš Kukan ; Could you possibly take a look at this one?
130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4 is the first bad commit
Author: Matthew Francis <email@example.com>
Date: Thu May 28 17:55:40 2015 +0800
Author: Matúš Kukan <firstname.lastname@example.org>
AuthorDate: Tue Dec 17 21:59:50 2013 +0100
Commit: Matúš Kukan <email@example.com>
CommitDate: Fri Dec 20 16:26:35 2013 +0100
svx: split into direct implementation getFactories
bibisect-43max$ git bisect log
# bad: [74b89c3193673ba9897dc4a4541500ef6e8d9bf7] source-hash-8f97326bdd3f42fc82aa5e1989fd03b0af1daf64
# good: [9c392cfdfe6e9a9bce98555ea989283a957aa3ad] source-hash-fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3
git bisect start 'latest' 'oldest'
# bad: [e289d9d328719fd70e9a2680fd0e4f586a97b3be] source-hash-3c0a7cf4f67720f2cca2c4eb543f838d5b644e7f
git bisect bad e289d9d328719fd70e9a2680fd0e4f586a97b3be
# bad: [0327d0bc45d60df0d1c8ac2470cf252b6bb8f780] source-hash-38fed70782ae6ac6b0282897c7abc6fa33a6de9e
git bisect bad 0327d0bc45d60df0d1c8ac2470cf252b6bb8f780
# bad: [130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4] source-hash-4a969ac35174520f1ffeb4f919f5d7bb6d99a628
git bisect bad 130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4
# good: [a4ca1d9431eedeb3ce6b22b96cfabc5ccc3cb857] source-hash-c85f1ed54f64bb7c7d309ec87df9ce8027a4a108
git bisect good a4ca1d9431eedeb3ce6b22b96cfabc5ccc3cb857
# skip: [9f1a043cf79070e06513761e9358747f45c88a31] source-hash-85d1e39d742d7798369b0071f9a5de5f62810d39
git bisect skip 9f1a043cf79070e06513761e9358747f45c88a31
# good: [f6cd344ef54fe1c898898dab200a18c23c6e1c2b] source-hash-6f9c6df388ef77ce546994f33669e7946fa055fb
git bisect good f6cd344ef54fe1c898898dab200a18c23c6e1c2b
# good: [4bcc3798c5513fc0dd457dd669ccd9cdabd6f127] source-hash-85605e15e90308c94aa510e42c45db740464021a
git bisect good 4bcc3798c5513fc0dd457dd669ccd9cdabd6f127
# good: [b1375d80b1a097d6536b795c8b0645fa500b076f] source-hash-44ec9d80aee3f4ec4fc4b5f1b7dfe8b8b0af69f7
git bisect good b1375d80b1a097d6536b795c8b0645fa500b076f
# good: [e8f8d5639b1779975f43c54e5aaa26b7677503ff] source-hash-1822302066fba5a21a8fb72cbaaae9bbe4cf9fbd
git bisect good e8f8d5639b1779975f43c54e5aaa26b7677503ff
# good: [2731ed6401bffee3e77b332d6b09664c1bbc2c1d] source-hash-56d1b1cb7b0e1db8b4eee8e7f53814b107f9b80c
git bisect good 2731ed6401bffee3e77b332d6b09664c1bbc2c1d
# good: [474813d918987e6fc16e22a8e66901ca3174624c] source-hash-b55259eeb549482477c57d854f3de72aff345edb
git bisect good 474813d918987e6fc16e22a8e66901ca3174624c
# good: [1f9f6b05bd72a0c0360a4eadda9384e0ef29f7bf] source-hash-1c80f3ab5c6dde9ff9399885390d4e6d9013be57
git bisect good 1f9f6b05bd72a0c0360a4eadda9384e0ef29f7bf
# good: [eea302a694b90252b8f344efa9ceff05b7940b86] source-hash-296b1e76071698c990e726d2f7935cef9ca07fbe
git bisect good eea302a694b90252b8f344efa9ceff05b7940b86
# first bad commit: [130c0f90cdc74b7300c74ee7d49c459ea8b8c4f4] source-hash-4a969ac35174520f1ffeb4f919f5d7bb6d99a628
(In reply to raal from comment #5)
> This seems to have begun at the below commit.
> commit 4a969ac35174520f1ffeb4f919f5d7bb6d99a628
> Author: Matúš Kukan <firstname.lastname@example.org>
> AuthorDate: Tue Dec 17 21:59:50 2013 +0100
> Commit: Matúš Kukan <email@example.com>
> CommitDate: Fri Dec 20 16:26:35 2013 +0100
> svx: split into direct implementation getFactories
> Change-Id: I888f10a923dc2b97247b2a66cc6bd116eee280a7
Ah, I was wondering how this commit could be responsible and it's not.
That commit is broken in general. Many tests don't work. It was reverted and done later properly.
Anyhow, I think I've found the commit responsible, so keeping this as bisected, just need to double check.
So, the problem commit is
Author: Jacobo Aragunde Pérez <firstname.lastname@example.org>
Date: Thu Jan 16 10:27:46 2014 +0100
ooxml: Preserve shape theme attribute for solid fill
It makes the output more similar to the origin, but in this case (always in xlsx?) we don't write theme/theme1.xml and can't get "accent1" color to be used.
Previously, we were writing color explicitly as
(Well, this commit only changes background color, borders are still visible and were broken somewhere later.. perhaps in 5391d4872e71d1edba7acc4ad2d2e3b5b97e1723)
Adding Jacobo to CC list, as per Comment 7.
These comments also apply here: https://bugs.documentfoundation.org/show_bug.cgi?id=103478#c7
The source of the problem is the same for both bugs.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
*** Bug 119565 has been marked as a duplicate of this bug. ***
*** Bug 106108 has been marked as a duplicate of this bug. ***
Created attachment 165764 [details]
The original file and its saved version in current Calc
Looks better after bug #124013 was fixed. Fill color is now saved in:
Version: 126.96.36.199.alpha0+ (x64)
Build ID: 52a49f9e480ca03e231cfda82640a928393131c9
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Note: the line width around it goes from 0.07 cm (2 pt in Excel) to 0.
Setting as duplicate since original report was about the background color disappearing, which is now preserved.
Unduplicated bug #119565 for the missing theme-based line width.
*** This bug has been marked as a duplicate of bug 124013 ***