Issue 108634 - File links altered to all lower case in formulae
Summary: File links altered to all lower case in formulae
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1.1
Hardware: PC (x86_64) Linux, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-25 07:11 UTC by whonea
Modified: 2013-01-29 21:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description whonea 2010-01-25 07:11:44 UTC 
When entering or editing a file link in a formula the entire path and file name
are set to all lower case.  A quick test show this to go back as far as 3.0.0.9.

Additional:  when an existing spread sheet is loaded, path case is preserved and
the formula works as expected until an edit is made to the formula (any edit -
not necessarily to the link path).  When an Excel format (.xls) is copied to
another location, case is preserved but the link path remains an exact copy of
the original.  When a Calc spreadsheet is copied to another location, the entire
path is lower cased - probably because the path is altered to reflect to new path.

All test spread sheets were originally developed with Calc - mostly pre-3.0
versions.  Case is preserved in the formula until it is entered into a cell.

Test: enter a formula into a cell.  Using the mouse or simply type a link to
another file with mixed or all upper case elements.  The formula bar will
display the correct text for the link.  Hit enter, the review the cell where the
formula was stored.  All upper case elements are changed to lower case.
Comment 1 maison.godard 2010-06-03 12:41:08 UTC 
a similar problem with formula and named ranges

OOo 3.2 Linux & WinXP

case 1.
define a named range AAA_bbb
type a formula in another cell =AAA_bb
the case is ok, and the formula works

case 2.
without defining a named range
type a formula in a cell =CCC_ddd
it show a #Name? (that is ok)
BUT
the formula is now lowercase =ccc_ddd

this is a real problem when dealing with macros, api and database
Comment 2 maison.godard 2010-06-03 13:12:56 UTC 
confirmed for OOo 3.2.1 RC2
Comment 3 evermillion 2010-07-31 18:21:03 UTC 
Although the original report is for linux, I'd like to add that I'm experiencing the same issue on 
the OS X version. Case being changed in file paths, copy/paste not preserving case in file paths, 
find/replace not preserving case in file paths. I guess any editing of file paths.

OOo v3.2.1
OOO320m18(build:9502)

OSX 10.5.8