To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79154 Issue #|79154 Summary|More choices for broken cross-file references Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P4 Subcomponent|open-import Assigned to|spreadsheet Reported by|tuharsky
------- Additional comments from [EMAIL PROTECTED] Tue Jul 3 13:26:25 +0000 2007 ------- I have an Excel table with bad references -the referenced file is not available. M$ Excel misbehaves in this case -it asks, whether to upgrade the cells from external source, then claims that "some" of the cells could not be refreshed, and uses the old values there. Nobody knows, which values are fresh from references and which are old. OOo Calc behaves differentially -it asks, whather to get the values from referenced sources. If I answer "No", I know there are old values everywhere. If I answer "Yes", and it fails to get the values from referenced file, it places #N/A into affected fields. Thus I know, which values couldn't be refreshed from original source. However, I thing some "inbetween" behaviour should also be available. Calc asks, whether to try to get fresh data from original sources. I answer "Yes", and he fails to do so for some values. He should display a warning with exact source files cited and status (OK/failed) and allow me to choose from 2 options: 1, the old way -let's place the #N/A into the unavailable values (original reference remains there) 2, new way -keep old values but mark them by different colour (e.q. grey them) The second choice is good in the case that user is facing a spreadsheet with several referenced resources, some of them unavailable for now. User might know, that those unavailable references are not crucial. He could still do calculations based on old values, knowing that they are old, and greyed for better resolution. The computated values, based on old (unrefreshed) values could possibly get greyed too. --------------------------------------------------------------------- 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]
