To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=45705 Issue #:|45705 Summary:|Linking to external spreadsheets to cell names |doesn't work Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|tuatara
------- Additional comments from [EMAIL PROTECTED] Mon Mar 21 20:21:10 -0800 2005 ------- OOo version 1.9.79 I have two spreadsheets. Sheet A has two cells that are named, each of which calculated from two other cells. (as an aside: the names are current_total, new_total). Sheet B is blank. >From Sheet B I do the following: - Select Cell (say) C12. - Insert | Link to external data - Select Sheet A. - [At this point 'current_total' and 'new_total' are shown.] - Select 'current_total' - Click OK The field formula is set to: =C9+C2 which is then evaluated locally to 0. The field formatting seems to be copied from Sheet A!current_total I do it again on cell D26, this time I got the formula =D23+D16. Again, formatting was copied. I changed SheetA!current_total to be calculated from three other cells, such as: =H15+H8+I8 and then link to SheetB, the sheetB cell becomes: =G14+G7+H7. So: it looks like the formula is being copied rather than the value, and then moved relative, then evaluated locally. The formatting is also copied. I have scanned for this bug in your database. A similar one exists where external data links are wrong, but it was 'closed' with a comment of 'WORKSFORME' from the developer. That bug had little detail so I am hoping that the extended detail in this report will help. All the best with it. Paul --------------------------------------------------------------------- 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]
