Calc: commands in menu Format | Change case doesn't work on a formatted date Step to reproduce : 1: new document 2: enter a date (1/2/2015 - 1 feb. 2015) 3: format cell, number is a date, pattern = "MMMM" --> cell display "february" (all lowercase) 4: use Format | Change case to get an uppercase on the first letter or all uppercase --> nothing happens. Expected behavior : the cell MUST render the date with the appropriate casing (e.g "February" or "FEBRUARY") If it is not possible (I feel the function is just a one shot text transformation), then : - Either add a "font effect" named "Case" or something like that, that allow to specify the casing (not limited to dates) - Or extends the pattern syntax to specify what case rendering to use. (e.g. I tried something like "Mmmm", but it could be something like "MMMM[case:WordStarstWithUppercase]"
Hi David, thanks for reporting. As you have comment, I think change case will never work in a format result. Format result is language dependent, e.g. in Spanish is lowercase, English US is first letter uppercase. If there are not dependent cells, it's possible use TEXT() function to format the result, and applying on it the UPPER()/PROPER()/LOWER() functions.
Unfortunately for me I have hundreds of cascading dependent cells (i.e _value_ = _previous_value_ + 1). Well I still think that it would be nice to have a font effect for specifying case.
changing summary
(In reply to David SPORN from comment #2) > Unfortunately for me I have hundreds of cascading dependent cells (i.e > _value_ = _previous_value_ + 1). > > Well I still think that it would be nice to have a font effect for > specifying case. I don't see any particular reason for this not to exist, so Status -> NEW (cc'ing Jay -- he might have something useful to say)
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.