Bug 109332 - [FEATURE] Pulling months should keep the case
Summary: [FEATURE] Pulling months should keep the case
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoFill
  Show dependency treegraph
Reported: 2017-07-25 09:10 UTC by Jean-Sebastien Bevilacqua
Modified: 2023-05-06 18:26 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Sebastien Bevilacqua 2017-07-25 09:10:07 UTC
Steps to reproduce:

1. Write "january" in A1
2. Pull the cell to extends the months
3. You get February, March...

Like you can see, case is not respected when you pull and depending on the language you select, it's different.
For example, in French, all months are lowercase.


- If the pulled month start with an uppercase, all months should start with an uppercase. (January)

- If the pulled month start with a lowercase, all months should start with a lowercase. (january)

- If the pulled month is only uppercase, all months should be uppercase. (JANUARY)

What do you think about this proposal ?

Jean-Sébastien Bevilacqua
Comment 1 m_a_riosv 2017-07-25 11:07:19 UTC
It's possible to create and add your desired list on:
Menu/Tools/Options/LibreOffice Calc/Sort List.

Resolved as not a bug, please if you are not agree, reopen it again.
Comment 2 Jean-Sebastien Bevilacqua 2017-07-25 11:21:30 UTC
Hello  m.a.riosv,

Thanks for your answer but it's not what I need.
The case should be taken from the pulled month (like in Excel) and not from a predefined list.

Jean-Sébastien Bevilacqua
Comment 3 m_a_riosv 2017-07-25 11:36:56 UTC
Have you tested, if you add a capitalized list then it is taken for extend cells, at least it works for me.
Comment 5 Jean-Sebastien Bevilacqua 2017-07-25 12:16:10 UTC
Hello  m.a.riosv,

Indeed if I create a list for each case type, it works great.
So we should pre-register all case type.

Do you know where is the predefined list in the code, like that I can add it.

Jean-Sébastien Bevilacqua
Comment 6 Xisco Faulí 2017-07-26 15:43:52 UTC
putting it back to UNCONFIRMED since no one has confirmed it yet.
Comment 7 m_a_riosv 2017-07-26 15:53:04 UTC
(In reply to Jean-Sebastien Bevilacqua from comment #5)
> .....
> Do you know where is the predefined list in the code, like that I can add it.
> .....

I think there are created on the fly.

Are you agree on close as not a bug?
Comment 8 Jean-Sebastien Bevilacqua 2017-07-27 09:28:16 UTC
Hello m.a.riosv,

Thanks a lot for this very good code pointer. Before closing it, I would like to know if the community would accept if I add month with all case types ?

Comment 9 m_a_riosv 2017-07-27 09:45:37 UTC
I think you need to follow the steps.

Comment 10 m_a_riosv 2017-07-27 09:46:48 UTC
Changed to enhancement, what it's really is now.
Comment 11 Buovjaga 2017-08-21 13:09:14 UTC
Jean-Sébastien: Eike said there might already be a request for this. I think you could try searching Bugzilla with the advanced search: https://bugs.documentfoundation.org/query.cgi?format=advanced
Comment 12 raal 2017-10-22 22:06:12 UTC
Setting as NEW for now.