https://bugs.documentfoundation.org/show_bug.cgi?id=138858

Jean-Baptiste Faure <jbfa...@libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME
                 CC|                            |jbfa...@libreoffice.org

--- Comment #1 from Jean-Baptiste Faure <jbfa...@libreoffice.org> ---
(In reply to Shaun from comment #0)
> Description:
> When entering text in the "range for name" box for a data range any capital
> letters are changed to lower case. (A workaround is available by pointing to
> a cell containing the name, but obviously this is not ideal.)

That is not a workaround, that the normal use of this textbox: "range for
name", not "name".

If you want to type a text value instead of a reference, use double quotes:
"Name" will be shown as Name

Tested in Version: 7.1.6.0.0+ / LibreOffice Community
Build ID: c2c2f74e26c8a7da78a8daee4671e1cb14509c12
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Ubuntu_20.04_x86-64
Calc: threaded

Closing as WorksForMe

Best regards. JBF

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to