Description: When an X-Y scatter chart has a linear trendline, the trendline will become a mean value line, if the X values are formatted as a dates AND the trendline has 'force intercept' selected. Also, the intercept value has a maximum entry of 10,000, which is much too low. Steps to Reproduce: 1. create an x-y scatter chart with data as numbers 2. add a linear trendline 3. format the x values as 'date' and set them as valid dates 4. set 'force intercept' on the trendline with an appropriate value Actual Results: Trendline on chart becomes a horizontal mean value line, while still displaying as a trendline. Expected Results: Trendline should adjust to have y intercept as selected Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
(In reply to elittera from comment #0) > Description: > When an X-Y scatter chart has a linear trendline, the trendline will become > a mean value line, if the X values are formatted as a dates AND the > trendline has 'force intercept' selected. Also, the intercept value has a > maximum entry of 10,000, which is much too low. > > Steps to Reproduce: > 1. create an x-y scatter chart with data as numbers > 2. add a linear trendline > 3. format the x values as 'date' and set them as valid dates Please attach an example document showing the state at step 3 so we can quickly test. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Seems duplicate by title. Sample would still be useful. *** This bug has been marked as a duplicate of bug 140555 ***
Reproduce in 7.1 and 7.4+. Linear is not really replaced by Mean but looks so.
Created attachment 180726 [details] Test ODS