Skip Menu |
 
Update: The rt.cpan.org bug tracker service is no longer shutting down.

This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id: 113231
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: wbarrett1076 [...] comcast.net
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
X-RT-Original-Encoding: ascii
Content-Length: 1475
Download (untitled) / with headers
text/plain 1.4k
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.