Steps to reproduce: 1. A1=1%; 2. Drag the "+" handle at the bottom-right corner of A1, to fill series down side. Current Behaviour: 1%, 101%, 201%, 301%, 401%.... Expected Behabiour: 1%, 2%, 3%, 4%... This is an enhancement request. Version: 4.4.2.1 Build ID: 93fc8832889bf050a10ec6d0171dae213adc9b55 Locale: zh_CN Win7 X86
Reproducible with LO 4.4.1.2, Win 8.1 This enhancement request sounds reasonable for me. I don't see why it would be good to add always 100% by default.
I thought a litte bit more about it and maybe the reason why it works currently that way is the following: If you have in A1 = 1 then you will get 1; 2; 3; 4 ... If you have in A1 = 0.01 then you will get 0.01; 1.01; 2.01; 3.01 ... -> +1 is always added and because 1% can also be written as 0.01 it is probably currently extended that way with +1 (each time) which can also be written as +100%, but for 1% I personally would prefer the expected behaviour suggested by Kevin (equivalent to 1; 2; 3; 4 ...)
We have two ways: 1) Menu/Edit/Fill/Series, and set up the increment option properly. 2) With A1: =1% and A2: =2%, selecting both at the same time and drag, works properly, LibreOffice knows what increment use.
I am aware that Calc is smart, but I am requesting to make it much smarter: When A1=1 then fill down, it should know that we expect 1, 2, 3, 4... When A1=0.1 then fill down, it should know that we expect 0.1, 0.2, 0.3, 0.4... When A1=1% then fill down, it should know that we expect 1%, 2%, 3%, 4%... (The last digit should be detected and incremented accordingly, rather than always increment by 1) Also, when A1 is like "I have 2 cats" then the fill down should be also "I have 2 cats" (copy rather than incremental, because it's text not number)
The pattern of what you like seems to be that the increment must be the minimal increment for the given value. If so, maybe a clearer title could help to get the improvement.
(In reply to m.a.riosv from comment #5) Title has been revised.
Created attachment 148184 [details] Video demo of patch.
I have create a patch for percentage values, i.e.: 1%, 2%, 3%, 4%... I attached a video demo above. I hope to discuss it with the design team and submit my code for review later today. NOTE: This does not affect other numeric values such as 0.01. I may look at that later.
Martin van Zijl committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/3931e7c05d38ee7805e2f7898d92a44c037900b5%5E%21 tdf#89998 set increment for percent values to 1% It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d2392723e1db63e31aa31fb4531a368b349fcd88 tdf#89998: sc_ucalc: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
verified as fixed in: Version: 7.2.0.2 / LibreOffice Community Build ID: 614be4f5c67816389257027dc5e56c801a547089 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded