Something I noticed in OpenOffice recently...

[PC]

...In the spreadsheet program (Calc), you can copy data from a table on a webpage and it will treat it as imported data.

This must have been done in one of the more recent updates because it wasn't always like this.  As some of you might have noticed from many of my posts, I have a slight obsession with numbers  and, frequently, copy table data from webpages.  This had always been a nightmare of formatting and macro writing to get the results that I wanted but now it's a piece of cake.

Thank you, OpenOffice.org and your minions, ie your programmers and developers! 

[The Chief]

I wouldn't know...  I don't use OpenOffice because....  I kid you not.... their spreadsheet program doesn't have the same shade of gold that I use in Excel to balance my check book.  Yes, I'm serious, that's really my primary reason for not using it

[NatsAddict]

I wouldn't know...  I don't use OpenOffice because....  I kid you not.... their spreadsheet program doesn't have the same shade of gold that I use in Excel to balance my check book.  Yes, I'm serious, that's really my primary reason for not using it

Go to Tools-Options and under OpenOffice.org, you can set any color you desire.




I have also used the table copy feature, but am not certain that OO deserves the full praise.  There are several Firefox extensions (I use Data Analytics) that enable the copying of tables into just about every spreadsheet - even the one on Google. 

Safari has this capability as well, working with OO, but not Google's spreadsheet.

IE fails miserably on both.

[PC]

IE fails miserably on both.

I just tried to copy a table from IE into OpenOffice and it worked fine, just like Firefox.

[The Chief]

Never knew we had such a savvy bunch here!

[NatsAddict]

I just tried to copy a table from IE into OpenOffice and it worked fine, just like Firefox.

When I try, it puts everything into a single cell.

Here is the IE & OO 2.2 result of the AL Standings from Yahoo:




[attachment deleted by admin]

[PC]

You could Paste Special it as HTML format.  That would "roughly" import it as data.

For IE, it appears to be tied to the underlying script/code or OO has decided to strategically make Internet Explorer data less importable.  Don't know why they'd do that, though.