Created attachment 172119 [details] Example file from Excel Attached user made document contains two similar line charts with complex axis labels. The main difference between them is that the top ones data series have their name defined as a static string “Nth quarter” while the bottom ones data series have their name defined as a cell reference. The top ones axis label is completely garbled with the last year number and all quarter numbers visible in a single vertical “cell” of the complex axis label. The bottom one looks fine with the same data. Changing the “Range for Name” values from the static string to a cell reference fixes the display of the top chart. Steps to reproduce: 1. Open attached document Actual results: Top charts X-axis label is unreadable. Expected results: Top charts X-axis label should look like the bottom ones with year numbers and quarter numbers. LibreOffice details: Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 91330c503b7eb91d777978018b66890af87cf8f5 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also in: 7.0, 6.0, 5.0, 4.0, 3.6 But not yet in 3.5.
Created attachment 172120 [details] Screenshot of the original document side by side in Excel and Calc – top chart
Created attachment 172121 [details] Screenshot of the original document side by side in Excel and Calc – bottom chart
Bibisect in 43all, large range: commit 4ef3a89e32ccba70e4b194ad97d110b88ce41c72 Date: Tue Dec 11 11:22:03 2012 +0000 source-hash-8450a99c744e9005f19173e4df35d65640bcf5c4 Author: tino <ttk448@gmail.com> AuthorDate: Thu Dec 6 14:05:11 2012 +0000 Commit: Markus Mohrhard <markus.mohrhard@googlemail.com> CommitDate: Sat Dec 8 02:27:06 2012 +0100 fdo#33365 added wrapper for boost random, use that in RAND() previous source-hash-9d7c1dcbbbce69bebec54d85004a0da5074775cd https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=9d7c1dcbbbce69bebec54d85004a0da5074775cd..8450a99c744e9005f19173e4df35d65640bcf5c4
Maybe this commit, should be built without to check: author Kohei Yoshida <kohei.yoshida@gmail.com> 2012-12-06 14:36:50 -0500 committer Kohei Yoshida <kohei.yoshida@gmail.com> 2012-12-06 23:03:37 -0500 commit 3a5c3dc392f451f9718ef2fe2076d41bdd9b87ee (patch) tree 1850d24c4c2f64c19bc7ce1b1ccae527f86b7a81 parent 9c46411ebd5ba696347dc9025c3b045f65f74205 (diff) bnc#792528: Import static data series labels from xlsx correctly. Static data series label is a data series label whose value is a string value rather than a cell reference. Also, when inputting static string label in the UI, we don't have to manually check for quotes; the formula compiler will take care of that later. Change-Id: I1657fc9879a7f652bba84898e308c3a5d5ba87a3 Diffstat