Trying to copy table structure from website into spreadsheet as tabular
data.
Using Mozilla Firefox v2, we can Edit/Select All, then Edit/Copy.
Go into a QPW notebook, and Edit/Paste.
Data is automatically parsed into the proper columns. Event the date column
is converted to serial dates and formatted to Long Date Intl. Most of the
formatting is correct (except for one column of dollar amounts, that was
formatted as General, except for amounts over $1,000.00 which are written as
strings (leading apostrophe).
Except for these minor formatting issues, Firefox works well.
Data was parsed into columns when it was pasted.
Using IE6 or IE7, Edit/Select All, then Edit/Copy
Go into a QPW notebook, and Edit/Paste.
Data is now a single column of strings (leading apostrophe) with each Row of
info contained within one cell.
Data was not parsed at all when pasted.
Working in QPW
v11.0.0321 on Win XP Pro SP2 (also on workstation with QPW v8
on Win2000Pro)
Any ideas how we can get the data from IE browsers to parse when pasted?
