To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111412 Issue #|111412 Summary|Cells linked to other spreadsheets are occassionally c |orrupted Component|Spreadsheet Version|OOO320m12 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|scott1946
------- Additional comments from [email protected] Wed May 5 18:58:25 +0000 2010 ------- Links between sheets in separate workbooks are, sometimes, losing the sheet name in the link. I have a work book that contains sheets for all my customers. There is another sheet t hat is the summary of the totals of the work types for each customer. Those totals are then extended by an amount of money giving sales this month per customer. Those totals are then linked to from another workbook that has amonthly sheet and several summary pages(Gross Sales, Outstanding Sales, Year To Date, Invoiced To Date). There are also links to my purchase workbook and my VAT(English Sales Tax) workbook.Once in awhile any some or all of these links are corrupted. The corruption appears to be the name of the sheet in the workbook is dropped and I am left with '<path>/<Workbook>.xls'#$''.<cell>. This also happens on my VAT workbook with its links into my Purchase workbook. I have just started my new sales year so I have little in the sets of workbooks. These are "Save As" versions of last years with every entry removed and re-entered for this new year in a different directory. I assume that they are now created as V3.2 workbooks. Today was my second set of entries into thse workbooks and today the links have corrupted. Yesterday was OK! --------------------------------------------------------------------- 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]
