Description: In Calc 6.4, Column chart will neglect all the data more than the 10th in the second column. Steps to Reproduce: 1.In sheet1, fill $test2.$A$2:$C$26, with label and data one by one 2.create a column chart 3. Actual Results: the data in $B display normally, however, the first 10 data in $C are shown in the chart and neglect all others. Expected Results: Every data must be shown in chart. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 158285 [details] test bed for column chart
Created attachment 158286 [details] screen shot of the bugs
Created attachment 158292 [details] Both the 1st and the last bar(value of 30) missing when open a xlsx file created by other program
Created attachment 158293 [details] xlsx file created using other office program
Created attachment 158741 [details] Comparison MSO 2010 and LibreOffice 7.0 master
The chart looks the same in Version: 7.0.0.0.alpha0+ Build ID: 4ee7ee1c4a515479bc174543af4dbc400035c0ba CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded and in MSO 2010. Could you please explain where is the problem ?
Column bars missing in Calc 6.4. Bar chart generated using MSO 2013 is attached here.
Created attachment 158772 [details] Open the test1.xlsx in MSO2013 and then generate a bar chart using the same data set
[Automated Action] NeedInfo-To-Unconfirmed
I occasionally used the Calc6.1 on Raspbian, the bar chart works well as expected, screenshot not shown.
I tested with info from description and I con NOT reproduce the bug. Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Created attachment 160931 [details] the bug The chart is not updateing with the numbers. See my pictures.
Hi, I search more, it's about your numbers. If you format them as number you will see that some of them are left align, because they are ont seen as numbers, but as text. You need to format everything as number, and then insert number again as number, or remove that charater ' from the numbers. See the video. Wainting for your answer and tests.
Created attachment 160932 [details] see the solution Video with solution for you. It is not a bug.