From: "John F. Whitehead" <address@hidden>
Date: 13 October 2005 19:40:13 BDT
To: address@hidden
Subject: [Aquamacs-bugs] can't paste into Excel
This bug report will be sent to the Free Software Foundation,
not to your local site managers!
Please write in English if possible, because the Emacs maintainers
usually do not have translators to read other languages for them.
Your bug report will be posted to the address@hidden
mailing list and possibly to the gnu.emacs.bug news group.
Please describe exactly what actions triggered the bug
and the precise symptoms of the bug:
When copying text from Aquamacs, and copying it into Microsoft
Excel, an invisible bogus character gets inserted. This causes
Excel to not understand what was inserted and give an error or
misformat the insertion.
1. Copy text from Aquamacs -- for instance just select the single
character "1" from a buffer you typed some numbers into.
2. Switch to Excel and select a cell
3. Type "=" (just the equals sign character), to indicate you're
going to enter a formula
4. Hit cmd-v to paste
5. Excel says "The formula you typed contains an error."
6. Hit OK, put the Excel cursor at the end of the cell formula
(which reads "=1"), and hit back arrow several times. You'll see
that with the first back arrow, it moves from after the 1 to
between the = and the 1; with the second back arrow THE CURSOR DOES
NOT MOVE, indicating there is an invisible character there; and
with the third back arrow the cursor moves to before the =.
7. If you use the arrows to move and then the delete key, you can
delete the middle invisible character, and the formula is
interpreted correctly.
Both apps are current: Aquamacs is 0.9.6 and Microsoft Excel 11.2
(050714).
Regression testing:
A) This does not happen with pasting from any other app (TextEdit,
the system terminal-based Emacs, Porkrind Emacs, etc.).
B) If you skip step 3 above, and just paste without the =, then
Excel does not display an error -- but this is only because the
leading invisible character is still there, and forces Excel to
interpret the paste as text, rather than as a number. You can
confirm this by doing a copy and paste of "1+1" -- it will show up
as "1+1" with a leading character, instead of as "2".
C) This happened with earlier versions of Aquamacs.
D) If you view the pasteboard after copying "1" (using Pasteboard
Peeker -- see <http://developer.apple.com/samplecode/
PasteboardPeeker/PasteboardPeeker.html>) you'll see that apparently
the public.utf1j6-plain-text value for utxt is 4 bytes -- if you
copy the same character from another application, it is only 2
bytes. Apparently an extra character is indeed being inserted on
the clipboard by Aquamacs. Similarly the ut16 value is 6 (instead
of 4 like from other apps). The other values seem to be correct.
I use Emacs & Excel together a lot, and can't use Aquamacs because
of this bug.
Thanks -
jfw
In GNU Emacs 22.0.50.1 (powerpc-apple-darwin7.9.0)
of 2005-09-28 on lucy - Aquamacs Distribution 0.9.6
Distributor `Apple Computers', version 10.4.2
configured using `configure '--without-x' '--prefix=/usr/local''
Important settings:
value of $LC_ALL: nil
value of $LC_COLLATE: nil
value of $LC_CTYPE: nil
value of $LC_MESSAGES: nil
value of $LC_MONETARY: nil
value of $LC_NUMERIC: nil
value of $LC_TIME: nil
value of $LANG: nil
locale-coding-system: iso-latin-1
default-enable-multibyte-characters: t
Major mode: Text
Minor modes in effect:
smart-frame-positioning-mode: t
recentf-mode: t
osx-key-mode: t
mouse-wheel-mode: t
show-paren-mode: t
delete-selection-mode: t
pc-selection-mode: t
cua-mode: t
encoded-kbd-mode: t
tooltip-mode: t
auto-compression-mode: t
menu-bar-mode: t
global-font-lock-mode: t
font-lock-mode: t
blink-cursor-mode: t
unify-8859-on-encoding-mode: t
utf-translate-cjk-mode: t
column-number-mode: t
line-number-mode: t
transient-mark-mode: t
Recent input:
1 + 1 + 2 <down-mouse-1> <mouse-movement> <mouse-movement>
<drag-mouse-1> H-c <down-mouse-1> <mouse-1> <menu-bar>
<help-menu> <report-emacs-bug> <down-mouse-1> <mouse-1>
<menu-bar> <help-menu> <report-emacs-bug>
Recent messages:
Loading edmacro...done
Loading cus-edit...
Note, built-in variable `x-use-old-gtk-file-dialog' not bound
Note, built-in variable `x-use-underline-position-properties' not
bound
Loading cus-edit...done
Loading plugins ...
Loading /Applications/Office/Aquamacs Emacs.app/Contents/Resources/
site-lisp/site-start (source)...done
... done.
Loading ~/Library/Preferences/Aquamacs Emacs/customizations.el
(source)...done
For a introduction to Aquamacs Emacs, type Apple-?.
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads,
discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
__
https://lists.sourceforge.net/lists/listinfo/aquamacs-bugs