1. Open CALC 2. Put 1 in A1 3. Mark A1 to A7 3. Edit > Fill > Series 4. down, linear, start value 1, end value 10, no increment gives me the falt "invalid value". Expexted is the linear serie 1; 2.5; 4; 5.5; 7; 8.5; 10 CALC should be able to calculate a linear serie given start, end and number of values. This is independant of the version of Libre Office and the operating system.
I'm not sure if you can leave increment open. You can get your expected result by setting increment to 1.5.
Not a bug - as MM explained - just user error. Follow MM's instructions and you'll get the result that you want. Thanks.
It's an ask for an enhancement: Calc should be able to see how much cells are marked by the user. Together with start-value (=first row) and end-value (=last row) Calc should be able to find the increment itself.
Fair enough - valid enhancement. @Robert- please note that enhancements are entirely taken on by volunteers. Many are never implemented (if a volunteer is not interested in the request). So, despite it being a valid request, there is no guarantee that it will ever be implemented. Just want to be clear on what it means that it's "confirmed" (e.g., it's a fine request).
hm I tried it in Version: 7.0.0.0.alpha0+ Build ID: 6c59c9d2b8818674640a50656ffba90f9cd3900e CPU threads: 4; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US Calc: threaded and with start and end values but without increment value I got correct series So it's WFM now