To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74155 Issue #|74155 Summary|copy of table cell by formula reference fails for text | data Component|Word processor Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|mru Reported by|jes
------- Additional comments from [EMAIL PROTECTED] Sat Feb 3 16:22:58 +0000 2007 ------- A formula in a table cell can refer to another cell. Such a reference is, in effect, replaced by the value of the other cell. If the formula in a cell consists of nothing but a reference to another cell, the formula produces a copy of the other cell. So, if in cell A1 we have "123" and cell A2 we have the formula "=<A1>", cell A2 will be a copy of cell A1. In Calc, this replacement works transparently for any value a cell can hold. In Writer, this behavior only holds for numeric values. Steps to reproduce: 1. File > New > Text Document 2. Insert > Table... OK (Accept default 2x2) 3. Select table; Number format = Text 4. In cell A1: Enter: "01080" 5. In cell A2: Enter: = (Formula bar grabs focus) Click on cell A1; formula bar shows "=<A1>" Enter. Cell A2 now shows "1080" instead of "01080" 6. In cell A1: Clear contents (Ctrl+A;Delete) Enter: "Abc" Note: formula in A2 does not update. Tools > Update > Update all Cell A2 now shows "0" instead of "Abc" I encountered this when I needed a table to show the same data in two different fonts: human-readable in one column, as bar codes in the other column. The data are mostly numeric but may have leading zeros (which are significant), or punctuation. Unfortunately, this problem makes Writer unsuitable for this task, as it is very difficult to visually check for missing zeros or non-updated fields when the data appear as bar codes. The two columns need to match perfectly and reliably. Using Calc might be one workaround, but I need to make labels, for which Writer is far better suited. Using fields is another possible workaround. Fields can accurately copy the data, but cannot be used for a whole table full of such data. --------------------------------------------------------------------- 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]
