To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55655 Issue #:|55655 Summary:|Conversion wizard should adjust Calc cell references |to external files Component:|framework Version:|OOO 2.0 Beta2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P1 Subcomponent:|code Assigned to:|tm Reported by:|mmenaz
------- Additional comments from [EMAIL PROTECTED] Sat Oct 8 09:10:18 -0700 2005 ------- I've Excel files that I have converted with the conversion wizard. Some of the sheets cells have refences to another file, i.e.: ='file:///smbshare/Documents/2005_06/pieni.XLS'#$PIENI.$F$9 Even if in principle there could be the chance that one uses the wizard to convert the "master" file without converting also the "related" ones, I think that this is VERY unlikely (and if not, it could convert the single "master" file just saving it in OpenDoc format, without the wizard). In addition, the wizard, and I like it, creates the converted file with a lowercase extensions, even if the "source" file has it uppercase (and I've many files like that). I'm not only abandoning M$ Office, but M$ Windows as well in the client side (done years ago in the server one), so I will access files inside windows and no more samba, so using a case-sensitive filesystem (oh, I do hate case-sensitive filesystem!). So I ask that the wizard take care of looking in the cells that have a reference to an external file, and rename the reference with .ods instead of .xls or .XLS (or whatever case it founds). Having to do it by hand is very time consuming if you have many spreadsheets with such references like I have (around 600). As stated in previous issues I've raised, these are difficoults I'm facing now that I'm converting all my files into OpenDocument format, and I really think they should be take in high consideration to facilitate migration (i.e. for Massachusetts ;)) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]