To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=71066
------- Additional comments from [EMAIL PROTECTED] Sun Nov 5 11:33:11 -0800
2006 -------
Yes, I see what you're trying to do... I can't find a way to attach a
hyperlink to a cell with a number either - but I think that Calc is working as
it was designed to, so it's not a bug. Maybe you could make a request for
enhancement? But just looking at an old copy of Excel, it doesn't allow
hyperlinked numbers either.
Other ideas:
1. Presumably the hyperlinked data is static - you could simply add 4 to the
SUM() ;)
2. Have the links in an adjacent column
3. Have a hidden column with numbers, possibly even =VALUE(), and SUM that
4. Aha! - use =SUM(VALUE(A1:A2)) , entering by pressing CTRL-Shift-Enter - an
array formula, which will convert to numbers before summing. Should appear as
{=SUM(VALUE(A1:A2))}
Does that solve it?
---------------------------------------------------------------------
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]
