To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49425
------- Additional comments from [EMAIL PROTECTED] Fri May 27 07:29:35 -0700 2005 ------- Hi er, thanks for your ------- Additional comments from er Fri May 27 03:33:44 -0700 2005 ------- > The xls file you attached to the other issue ... 26600/test1.XLS > already has absolute references, you can see if opened in Excel. Ah! I should have suspected that: I thought that happened when translating into .sxc by Calc, as viewed from Lotus the ranges in the .XLS file still appear to be relative refs. > Also, Calc's Lotus import is quite rudimentary and covers > only basic features like values and formulas, ... I realized this when I tried to import in OOo-1.9.82 ;( > We don't put much effort in the Lotus filter but > emphasize on .xls instead. And, this is a pity (from my point of view) as Lotus _is_ "The Spredsheet", Excel being only its 'rough copy'! > I don't know Lotus well, but to me that sounds less flexible, for > example, what about mixed references like $A1 you can use in Excel and Calc. On my turn, I don't know yet all Calc potentialities; however, just tested the mixed reference like $A1 and found they seem to work exactly the same, both in Calc and Lotus (apart from the major Lotus 'flexibility' to call the range defined as $A1 both as 'range' and as '$range' according to the result you wish). Thanks for your attention, anyway. Regards, Ennio. PS: Might you decide to change 'philosophy' in future and pay better attention to Lotus please be aware that I could possibly contribute as a final tester. --------------------------------------------------------------------- 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]