Bug 81437

Summary:	FILEOPEN: Imported Excel XLSX chart border property ignored
Product:	LibreOffice	Reporter:	Luke <lukebenes>
Component:	Chart	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	libreoffice, suokunlong
Version:	3.5.7.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=75380 https://bugs.freedesktop.org/show_bug.cgi?id=72838 https://bugs.freedesktop.org/show_bug.cgi?id=54361 https://bugs.freedesktop.org/show_bug.cgi?id=82217
Whiteboard:
i915 platform:		i915 features:
Bug Depends on:
Bug Blocks:	75057
Attachments:	Sample XSLX file with automatic border Sample XSLX file with manual border Screenshot showing missing border

Description Luke 2014-07-16 18:34:21 UTC

Created attachment 102934 [details]
Sample XSLX file with automatic border

When importing XLSX files, the chart border property is ignored and charts always have no border.

Steps to reproduce:
1. Create a chart in Excel.
2. Format Chart Area -> Set to Manual or Automatic
3. Save as XSLX
4. Open in LO 4.2+

What is expected?:
Chart in Calc will show a border.

Actual Results:
Imported does not have a border in Calc. This can be verified in Calc by 
1. Right click on chart -> Edit
2. Right click on chart -> Format Chart Area
3. Note Border style is "none" when it was "Automatic" in Excel



Bug 72838 has some other great examples of this bug.

Comment 1 Luke 2014-07-16 18:34:52 UTC

Created attachment 102935 [details]
Sample XSLX file with manual border

Comment 2 Luke 2014-07-16 18:42:46 UTC

Created attachment 102936 [details]
Screenshot showing missing border

Comment 3 Kevin Suo 2014-07-17 05:55:50 UTC

Confirmed with
Version: 4.3.1.0.0+
Build ID: 5536b127a105123de6f64dcf8f53dfa277faef3c
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-07-16_10:15:31

Set to NEW.

Comment 4 ign_christian 2014-07-17 16:11:52 UTC

Reproduced with LO 4.2.6.1, 4.1.6.2, 4.0.4.2, 3.6.7.2, 3.5.7.2 on Ubuntu 12.04 x86 (I also confirmed transparent background issue)

LO 3.3.0.4 shows the border though not perfect (in Chart Area | Borders :
Line Properties > Style : Continuous) and correct white background.

Surprisingly AOO 3.4.1 and 4.1.0 show good border (same as LO 3.3.0.4: style: Continuous) and correct white background.

Maybe fix in Bug 54361 (bug with transparent background) will also fix this border bug.

Comment 5 Luke 2014-08-01 20:48:18 UTC

Thanks to Kohei fixing Bug 75380, the manual border case is now working attachment 102935 [details]. Unfortunately, the most common setting, automatic border is still not working. Tested on master~2014-08-01_00.34.17_LibreOfficeDev_4.4.0.0.alpha0.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.