Register  |  Sign In
View unanswered posts | View active topics It is currently Thu Mar 28, 2024 11:43 am



Reply to topic  [ 63 posts ]  Go to page Previous  1, 2, 3
 Excel Spreadsheet to [Table] Tag Converter Tool 
Author Message
Veteran

Joined: Fri Oct 19, 2007 10:53 am
Posts: 3007
Post 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?

_________________
June 27 Predictions, April 25 Predictions, April 11 Predictions

Follow me on Twitter: https://twitter.com/hkreleasedates

Blog: http://hkreleasedates.blogspot.com


Wed Jul 14, 2010 1:11 pm
Profile
Cream of the Crop
User avatar

Joined: Wed Nov 29, 2006 8:04 pm
Posts: 2035
Location: Citizens Bank Park
Post 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
Profile ICQ WWW
Veteran

Joined: Fri Oct 19, 2007 10:53 am
Posts: 3007
Post 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.

_________________
June 27 Predictions, April 25 Predictions, April 11 Predictions

Follow me on Twitter: https://twitter.com/hkreleasedates

Blog: http://hkreleasedates.blogspot.com


Thu Jul 15, 2010 7:54 am
Profile
Cream of the Crop
User avatar

Joined: Wed Nov 29, 2006 8:04 pm
Posts: 2035
Location: Citizens Bank Park
Post 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
Profile ICQ WWW
Veteran

Joined: Fri Oct 19, 2007 10:53 am
Posts: 3007
Post 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.

_________________
June 27 Predictions, April 25 Predictions, April 11 Predictions

Follow me on Twitter: https://twitter.com/hkreleasedates

Blog: http://hkreleasedates.blogspot.com


Fri Jul 16, 2010 1:11 pm
Profile
Veteran

Joined: Fri Oct 19, 2007 10:53 am
Posts: 3007
Post 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.

_________________
June 27 Predictions, April 25 Predictions, April 11 Predictions

Follow me on Twitter: https://twitter.com/hkreleasedates

Blog: http://hkreleasedates.blogspot.com


Sun Aug 01, 2010 3:14 pm
Profile
Teh Mexican
User avatar

Joined: Fri Oct 15, 2004 11:56 pm
Posts: 26066
Location: In good ol' Mexico
Post Re: Excel Spreadsheet to [Table] Tag Converter Tool
Question.. does this work on Excel 2007?..


Fri Aug 13, 2010 6:31 pm
Profile
Teh Mexican
User avatar

Joined: Fri Oct 15, 2004 11:56 pm
Posts: 26066
Location: In good ol' Mexico
Post 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. :)


Sat Aug 14, 2010 5:09 pm
Profile
Newbie

Joined: Fri Sep 26, 2014 11:48 am
Posts: 4
Post 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
Profile
Site Owner
User avatar

Joined: Wed Sep 15, 2004 1:09 pm
Posts: 14631
Location: Pittsburgh
Post 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

_________________
Image


Fri Sep 26, 2014 12:22 pm
Profile WWW
Newbie

Joined: Fri Sep 26, 2014 11:48 am
Posts: 4
Post 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
Profile
Newbie

Joined: Fri Sep 26, 2014 11:48 am
Posts: 4
Post 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
Profile
Newbie

Joined: Fri Sep 26, 2014 11:48 am
Posts: 4
Post Re: Excel Spreadsheet to [Table] Tag Converter Tool
I found out how to add my bbcode.


Tue Sep 30, 2014 9:28 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 63 posts ]  Go to page Previous  1, 2, 3

Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.