| MIME-Version: | 1.0 |
| X-Spam-Status: | No, score=-1.749 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.001] autolearn=no |
| X-Mailer: | Microsoft Office Outlook 12.0 |
| X-Spam-Flag: | NO |
| X-Virus-Checked: | Checked |
| Content-Language: | en-us |
| Content-Type: | multipart/alternative; boundary="----=_NextPart_000_0001_01D18356.9C357430" |
| Message-ID: | <000001d18391$48944c30$d9bce490$ [...] net> |
| X-Virus-Scanned: | Debian amavisd-new at bestpractical.com |
| X-Spam-Score: | -1.749 |
| Received: | from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 2E52024039A for <cpan-bug+spreadsheet-xlsx [...] hipster.bestpractical.com>; Mon, 21 Mar 2016 12:46:33 -0400 (EDT) |
| Received: | from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6yQXMvkI5X1G for <cpan-bug+spreadsheet-xlsx [...] hipster.bestpractical.com>; Mon, 21 Mar 2016 12:46:31 -0400 (EDT) |
| Received: | from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 693D92400DA for <bug-spreadsheet-xlsx [...] rt.cpan.org>; Mon, 21 Mar 2016 12:46:31 -0400 (EDT) |
| Received: | (qmail 25585 invoked by alias); 21 Mar 2016 16:46:30 -0000 |
| Received: | from resqmta-po-11v.sys.comcast.net (HELO resqmta-po-11v.sys.comcast.net) (96.114.154.170) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 21 Mar 2016 09:46:28 -0700 |
| Received: | from resomta-po-11v.sys.comcast.net ([96.114.154.235]) by resqmta-po-11v.sys.comcast.net with comcast id Yglu1s00454zqzk01gmNrc; Mon, 21 Mar 2016 16:46:22 +0000 |
| Received: | from WBARRETTWATSON ([IPv6:2601:646:8f00:1e67:5bf:30bc:b4dd:fe49]) by resomta-po-11v.sys.comcast.net with comcast id YgmM1s00M0F41Yl01gmNye; Mon, 21 Mar 2016 16:46:22 +0000 |
| Authentication-Results: | hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] comcast.net |
| Delivered-To: | cpan-bug+spreadsheet-xlsx [...] hipster.bestpractical.com |
| Subject: | Microsoft's HYPERLINK function |
| Return-Path: | <wbarrett1076 [...] comcast.net> |
| Dkim-Signature: | v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1458578782; bh=wsjDOpo2mrx9LfRnznlksQuoWA9731MBhUvPhdbAF2o=; h=Received:Received:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type; b=IumZPfGcm93tPq17owCjKD+YHxWYoX6qqyOthXwNJ0v1KoNdJPGs05M8LDMD9hA7U yadZntFkb4yfNUith0jUJVNQMekRtALOEpInMXmpOgHoY9gRdP7EeDN/Z9sTOytRus YvwrdZ2bWzNLu3a6HL3dlIUWXh0vNLl2XP9VVNLKkVbN0QNnvEABGOl7G1d+9kZiGI RZO9BeAEBCNxkoni49EqMRJLq/T2wL++z79y/pKfBudKDrsLYmYCWL9ypGJ00fgilT N0j4KDfTJXHB02HGI8vU78beTtLhlgonARgMcQDIHoCeeDO52JObUjtJE8sKBdgrTL dgFBQRyioTxfA== |
| Thread-Index: | AdGDkJHF79+p842pQHiLJK3WxatPCw== |
| X-RT-Mail-Extension: | spreadsheet-xlsx |
| X-Original-To: | cpan-bug+spreadsheet-xlsx [...] hipster.bestpractical.com |
| X-Spam-Check-BY: | la.mx.develooper.com |
| Date: | Mon, 21 Mar 2016 09:46:57 -0700 |
| X-Spam-Level: | |
| To: | <bug-Spreadsheet-XLSX [...] rt.cpan.org> |
| From: | "William Barrett" <wbarrett1076 [...] comcast.net> |
| X-RT-Interface: | |
| Content-Length: | 0 |
| content-type: | text/plain; charset="utf-8" |
| Content-Transfer-Encoding: | 7bit |
| X-RT-Original-Encoding: | ascii |
| Content-Length: | 1475 |
I love your spreadsheet program, and am using it on some large databases.
But - I spent several days tracking down a mysterious crash. Finally traced
it to the HYPERLINK function in Excel.
This takes an email address - when enabled - apparently anything containing
one @ - then constructs a HYPERLINK function.
That in turn will open an email handler - Microsoft's, of course - and its
windows.
Obviously impossible to support through Spreadsheet.
So - not a bug - but a complaint that your tool fails to provide a
reasonable report on a problem like this. The complaint comes out as a
crash with several lines of mystery function reports. Not even a clue about
the sheet and cell causing the problem.
HYPERLINK is generated automatically when enabled. It can be enabled or
disabled by going into the Excel options menu, Proofing, autocorrect
Options, Autoformat as you type, Replace as you type Internet and network
paths with hyperlinks.
It took me several Google searches to discover this problem. Setting or
clearing this hyperlink feature once apparently covers any Excel session. I
probably set it long ago for another reason, then forgot about it.
Also, once set, most hyperlink functions can be unwound through a visual
Basic operation - look it up in Google. However, 'most' is my finding -
this fixes most of a batch on a spreadsheet, but leaves many unchanged.
Those can only be changed manually by retyping the entry to leave only the
email address.
| content-type: | text/html; charset="utf-8" |
| Content-Transfer-Encoding: | quoted-printable |
| X-RT-Original-Encoding: | ascii |
| Content-Length: | 3636 |