World of KJ
http://worldofkj.com/forum/

Excel Spreadsheet to [Table] Tag Converter Tool
http://worldofkj.com/forum/viewtopic.php?f=3&t=8997
Page 3 of 3

Author:  Bluebomb [ Wed Jul 14, 2010 1:11 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

I don't know what happened but just in the past 2 days, my tables come out like this when I paste it using the Converter tool. Wrong text colors and extra code added in that I did not add myself. Yes, I enabled macros.

[color=#][/color]Thursday adm.(so far)July 15
RankTitleLWTWWKD % chgQD % chg
1Toy Story 3 (3D Cantonese)--32294----
2Predators--1617----
3La Comédie Humaine--1086----
4Shrek: Forever After (3D Cantonese)--945----
5Twilight 3: Eclipse--718----


It's supposed to come out like this:

Thursday adm.(so far)July 15
RankTitleLWTWWKD % chgQD % chg
1Toy Story 3 (3D Cantonese)--32294----
2Predators--1617----
3La Comédie Humaine--1086----
4Shrek: Forever After (3D Cantonese)--945----
5Twilight 3: Eclipse--718----


Can somebody help please?

Author:  Krem [ Thu Jul 15, 2010 1:25 am ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Was it working well before? What version of Excel are you using?

Author:  Bluebomb [ Thu Jul 15, 2010 7:54 am ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Krem wrote:
Was it working well before? What version of Excel are you using?


Yes, it was. I've been using your template/excel document for about 3 months now before the screw-ups started happening just a couple of days ago. I'm using Excel 2003.

Author:  Krem [ Fri Jul 16, 2010 12:50 am ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Hmm, i see that it's adding unneeded tags in the code.

Can you do me a favor and email me the spreadsheet you're having an issue with at krem81 at yahoo dot com?

Author:  Bluebomb [ Fri Jul 16, 2010 1:11 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Krem wrote:
Can you do me a favor and email me the spreadsheet you're having an issue with at...


Sent.

Author:  Bluebomb [ Sun Aug 01, 2010 3:14 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Well, I managed to fix it for now.

I downloaded a new copy of the Excel2BB excel file, re-entered all the formulas manually and it worked! Hopefully it's not a temporary fix.

Author:  matatonio [ Fri Aug 13, 2010 6:31 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Question.. does this work on Excel 2007?..

Author:  matatonio [ Sat Aug 14, 2010 5:09 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

and if it does, i really cant figure it out. Help Please! :tears:

EDIT: nevermind, got it. :)

Author:  Jerry Aycock [ Fri Sep 26, 2014 11:54 am ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

It seemed to convert but when I pasted in post .. it didn't change to table ??
It is my Phbb board..

It works Great on this post .. Am I missing something on my board ??
BBCode is enabled ..

Thanks
Jerry
www.tidewaterfishing.net

Author:  Eagle [ Fri Sep 26, 2014 12:22 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

Jerry,

It's a bit of a custom tool. The excel converter simply adds the tags, the tags also have to be setup in your phpbb board. If they're not configured, it won't know how to display them.

Karl

Author:  Jerry Aycock [ Fri Sep 26, 2014 9:42 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

How can I set up codes on my Phbbs ???

This is the closest I have come to being able to post my Table.

Thanks for any help...

Jerry

Author:  Jerry Aycock [ Sun Sep 28, 2014 8:17 pm ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

I will try again.
I can run the converter and it works GREAT on this board. But not on mine.
Any advice on how to add the proper BBCODE to MY board to be able to do this will be appreciated.
I have searched and searched to do this, Can anyone point me in the right direction..

As I said after WEEKS this is as close as I have gotten..

Thanks
Jerry

Author:  Jerry Aycock [ Tue Sep 30, 2014 9:28 am ]
Post subject:  Re: Excel Spreadsheet to [Table] Tag Converter Tool

I found out how to add my bbcode.

Page 3 of 3 All times are UTC - 5 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/