Author |
Message |
Bluebomb
Veteran
Joined: Fri Oct 19, 2007 10:53 am Posts: 3028
|
 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 |
Rank | Title | LW | TW | WKD % chg | QD % chg |
1 | Toy Story 3 (3D Cantonese) | -- | 32294 | -- | -- |
2 | Predators | -- | 1617 | -- | -- |
3 | La Comédie Humaine | -- | 1086 | -- | -- |
4 | Shrek: Forever After (3D Cantonese) | -- | 945 | -- | -- |
5 | Twilight 3: Eclipse | -- | 718 | -- | -- |
It's supposed to come out like this:
| Thursday adm. | (so far) | | | July 15 |
Rank | Title | LW | TW | WKD % chg | QD % chg |
1 | Toy Story 3 (3D Cantonese) | -- | 32294 | -- | -- |
2 | Predators | -- | 1617 | -- | -- |
3 | La Comédie Humaine | -- | 1086 | -- | -- |
4 | Shrek: Forever After (3D Cantonese) | -- | 945 | -- | -- |
5 | Twilight 3: Eclipse | -- | 718 | -- | -- |
Can somebody help please?
|
Wed Jul 14, 2010 1:11 pm |
|
 |
Krem
Cream of the Crop
Joined: Wed Nov 29, 2006 8:04 pm Posts: 2035 Location: Citizens Bank Park
|
 Re: Excel Spreadsheet to [Table] Tag Converter Tool
Was it working well before? What version of Excel are you using?
_________________ Let's go Phillies.
|
Thu Jul 15, 2010 1:25 am |
|
 |
Bluebomb
Veteran
Joined: Fri Oct 19, 2007 10:53 am Posts: 3028
|
 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.
|
Thu Jul 15, 2010 7:54 am |
|
 |
Krem
Cream of the Crop
Joined: Wed Nov 29, 2006 8:04 pm Posts: 2035 Location: Citizens Bank Park
|
 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?
_________________ Let's go Phillies.
|
Fri Jul 16, 2010 12:50 am |
|
 |
Bluebomb
Veteran
Joined: Fri Oct 19, 2007 10:53 am Posts: 3028
|
 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.
|
Fri Jul 16, 2010 1:11 pm |
|
 |
Bluebomb
Veteran
Joined: Fri Oct 19, 2007 10:53 am Posts: 3028
|
 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.
|
Sun Aug 01, 2010 3:14 pm |
|
 |
matatonio
Teh Mexican
Joined: Fri Oct 15, 2004 11:56 pm Posts: 26066 Location: In good ol' Mexico
|
 Re: Excel Spreadsheet to [Table] Tag Converter Tool
Question.. does this work on Excel 2007?..
|
Fri Aug 13, 2010 6:31 pm |
|
 |
matatonio
Teh Mexican
Joined: Fri Oct 15, 2004 11:56 pm Posts: 26066 Location: In good ol' Mexico
|
 Re: Excel Spreadsheet to [Table] Tag Converter Tool
and if it does, i really cant figure it out. Help Please!  EDIT: nevermind, got it. 
|
Sat Aug 14, 2010 5:09 pm |
|
 |
Jerry Aycock
Newbie
Joined: Fri Sep 26, 2014 11:48 am Posts: 4
|
 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
|
Fri Sep 26, 2014 11:54 am |
|
 |
Eagle
Site Owner
Joined: Wed Sep 15, 2004 1:09 pm Posts: 14631 Location: Pittsburgh
|
 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
_________________
|
Fri Sep 26, 2014 12:22 pm |
|
 |
Jerry Aycock
Newbie
Joined: Fri Sep 26, 2014 11:48 am Posts: 4
|
 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
|
Fri Sep 26, 2014 9:42 pm |
|
 |
Jerry Aycock
Newbie
Joined: Fri Sep 26, 2014 11:48 am Posts: 4
|
 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
|
Sun Sep 28, 2014 8:17 pm |
|
 |
Jerry Aycock
Newbie
Joined: Fri Sep 26, 2014 11:48 am Posts: 4
|
 Re: Excel Spreadsheet to [Table] Tag Converter Tool
I found out how to add my bbcode.
|
Tue Sep 30, 2014 9:28 am |
|
|