Hi all, I have a peculiar situation where a Calc sheet was saved as a *.xls excel 2003 for XP. Excel could not edit the formula, it disappeared when you tried to edit it.
In OO-Calc, I tried it as well then. I have a long formula where many cells are concatenated to form a text string. It works. Now I want to expand the formula to include more cells. When I edit either in the top editing space or in the formula wizard, it shows the formula instead of the result in the cell. What causes it? I have tried formatting all the relevant cells to text and saved the sheet as *.ods. When I copy another cell with the same formula into the cell where I try to edit, it works with the old formula again. :-/ Al --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
