Two Plus Two Newer Archives

Two Plus Two Newer Archives (http://archives1.twoplustwo.com/index.php)
-   MOD DISCUSSION (http://archives1.twoplustwo.com/forumdisplay.php?f=52)
-   -   UUB mod for charts & spreadsheets? (http://archives1.twoplustwo.com/showthread.php?t=318399)

*TT* 01-29-2007 07:24 PM

UUB mod for charts & spreadsheets?
 
Is there a UUB mod that allows for the creation of charts and spreadsheets? Currently the only option we have is to past using the CODE text modifier, but it doesn't accurately format the cells when pasting from a spreadsheet. Since there is more and more analytical data being posted here over time, that would be a nice option for Chuck to add - if the add on software already exists.

TT [img]/images/graemlins/club.gif[/img]

Sniper 01-29-2007 07:50 PM

Re: UUB mod for charts & spreadsheets?
 
Create the spreadsheet/graph... take pic... host & post the image...

*TT* 01-29-2007 08:25 PM

Re: UUB mod for charts & spreadsheets?
 
[ QUOTE ]
Create the spreadsheet/graph... take pic... host & post the image...

[/ QUOTE ]

Yes thats the option most commonly used, but then the data is not able to be manipulated by the end user - an unfortunate disadvantage (unless you have OCR software of course, and even then it works like crap).

TT [img]/images/graemlins/club.gif[/img]

Jurollo 01-29-2007 08:52 PM

Re: UUB mod for charts & spreadsheets?
 
As mods we can post in HTML. So you could use the <table> function and physically make a table in a post.

Jurollo 01-29-2007 08:55 PM

Re: UUB mod for charts & spreadsheets?
 
An Example:



<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="75%" id="AutoNumber1">
<tr>
<td width="33%">A</td>
<td width="33%">B</td>
<td width="34%">C</td>
</tr>
<tr>
<td width="33%">1</td>
<td width="33%">2</td>
<td width="34%">3</td>
</tr>
</table>




I am sure you could incorporate Excel directly in html

Big_Jim 01-29-2007 08:59 PM

Re: UUB mod for charts & spreadsheets?
 
We can use html?

&lt;BLINK&gt;NEATO!&lt;/BLINK&gt;

EDIT: Lame. =(

Jurollo 01-29-2007 09:06 PM

Re: UUB mod for charts & spreadsheets?
 
Yea... just do this...
http://img297.imageshack.us/img297/2852/html1cb6.jpg

http://img401.imageshack.us/img401/1853/html2jb6.jpg

Then HOLLA! HTML!

I used it in the MTTC Sticky Thread to do all the hotlinking and mouseovers.

Big_Jim 01-29-2007 09:07 PM

Re: UUB mod for charts & spreadsheets?
 
EDIT: ohhhh

Clever.

Sniper 01-29-2007 09:34 PM

Re: UUB mod for charts & spreadsheets?
 
That you have Javascript in that post is one of the reasons why this functionality is not enabled for posters [img]/images/graemlins/wink.gif[/img]

Jurollo 01-29-2007 09:53 PM

Re: UUB mod for charts & spreadsheets?
 
[ QUOTE ]
That you have Javascript in that post is one of the reasons why this functionality is not enabled for posters [img]/images/graemlins/wink.gif[/img]

[/ QUOTE ]
I realize this. But this functionality could help *TT*, who's a mod [img]/images/graemlins/grin.gif[/img]

*TT* 01-29-2007 10:26 PM

Re: UUB mod for charts & spreadsheets?
 
[ QUOTE ]
[ QUOTE ]
That you have Javascript in that post is one of the reasons why this functionality is not enabled for posters [img]/images/graemlins/wink.gif[/img]

[/ QUOTE ]
I realize this. But this functionality could help *TT*, who's a mod [img]/images/graemlins/grin.gif[/img]

[/ QUOTE ]

An excellent step in the right direction! It would be nice if we could transfer this ability to the users, but i see how the power of allowing users to post HTML code could be far to dangerous.

PS: I'm a mod? How embarrassing!

TT [img]/images/graemlins/club.gif[/img]

Jurollo 01-29-2007 11:10 PM

Re: UUB mod for charts & spreadsheets?
 
The next post I am going to make is a test. Someone tell me if you can import it to Excel via copy/paste.

Jurollo 01-29-2007 11:11 PM

Re: UUB mod for charts & spreadsheets?
 
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<link rel=Original-File
href="http://www.jurollo.com/test.xls">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<link rel=File-List href="MTT%20Spreadsheet(2007)_files/filelist.xml">
<link rel=Edit-Time-Data href="MTT%20Spreadsheet(2007)_files/editdata.mso">
<link rel=OLE-Object-Data href="MTT%20Spreadsheet(2007)_files/oledata.mso">

</head>

<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
<frame src="MTT%20Spreadsheet(2007)_files/sheet006.htm" name="frSheet">
<frame src="MTT%20Spreadsheet(2007)_files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
<noframes>
<body>


This page uses frames, but your browser doesn't support them.</p>
</body>
</noframes>

</frameset>
</html>

Jurollo 01-29-2007 11:15 PM

Re: UUB mod for charts & spreadsheets?
 
Once my FTP starts working that post should be an excel file.

*TT* 01-29-2007 11:56 PM

Re: UUB mod for charts & spreadsheets?
 
I don't think the Active X controls work in anything but IE. I am using Firefox, I doubt I'll ever see the excel spreadsheet you intend to embed. [img]/images/graemlins/frown.gif[/img]

TT [img]/images/graemlins/club.gif[/img]

bluefeet 01-30-2007 12:00 AM

Re: UUB mod for charts & spreadsheets?
 

I'm on IE...I see nothing.

Jurollo 01-30-2007 12:00 AM

Re: UUB mod for charts & spreadsheets?
 
[ QUOTE ]
I don't think the Active X controls work in anything but IE. I am using Firefox, I doubt I'll ever see the excel spreadsheet you intend to embed. [img]/images/graemlins/frown.gif[/img]

TT [img]/images/graemlins/club.gif[/img]

[/ QUOTE ]
Yea it does need to use IE, I use Firefox too but its a solution (to an extent)

Jurollo 01-30-2007 12:01 AM

Re: UUB mod for charts & spreadsheets?
 
[ QUOTE ]

I'm on IE...I see nothing.

[/ QUOTE ]
My FTP is acting up, otherwise it should work. I will post when i get it loaded on my FTP.


All times are GMT -4. The time now is 09:46 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.