Jump to content


Photo

posting info from spreadsheets


  • Please log in to reply
4 replies to this topic

#1 Osiris

Osiris
  • Member

  • 195 posts
  • Joined: April 11

Posted 26 March 2018 - 00:30

I am trying to post information from an Excel spreadsheet and the format looks good when it is copied into the box, but then when you preview the post the formatting goes away and it is just a linear line of information.

 

How can I get the proper table format without having to self-adjust the formatting?

 

thanks!!



Advertisement

#2 Osiris

Osiris
  • Member

  • 195 posts
  • Joined: April 11

Posted 09 April 2018 - 12:49

Thank you for liking my post!

 

Hoping a more solid fix is around.



#3 ANF

ANF
  • Member

  • 10,433 posts
  • Joined: April 12

Posted 17 April 2018 - 23:25

How can I get the proper table format without having to self-adjust the formatting?

As far as I know, you can't.

There seems to be other bulletin boards where you can create your own table like this...

[table]
[tr][td]Row 1, Col 1[/td][td]Row 1, Col 2[/td][/tr]
[tr][td]Row 2, Col 1[/td][td]Row 2, Col 2[/td][/tr]
[/table]

...but that doesn't work here.

What you can do is to place the text inside a Code box like this:
 
Row 1, Col 1	Row 1, Col 2	
Row 2, Col 1	Row 2, Col 2	and the second row has a third column as well
This won't give you any table cells, but you can align the information from the spreadsheet in neat columns.

image.png
With no text selected in the post box, click on Code in the toolbar.

Now this window will pop up:

image.png
Paste the information from the spreadsheet into the box, click OK, and you'll get this:

image.png
Use "normal" spacebar spaces if you want to add more space between the columns before you hit Post.

Edited by ANF, 18 April 2018 - 09:25.


#4 SophieB

SophieB
  • RC Forum Host

  • 12,105 posts
  • Joined: July 12

Posted 18 April 2018 - 08:46

I am trying to post information from an Excel spreadsheet and the format looks good when it is copied into the box, but then when you preview the post the formatting goes away and it is just a linear line of information.
 
How can I get the proper table format without having to self-adjust the formatting?
 
thanks!!


I’m not one of the developers or anything, but is the info in a format suitable for saving it as a screenshot and then uploading the picture instead?

#5 Costaz

Costaz
  • Member

  • 3,205 posts
  • Joined: December 03

Posted 20 April 2018 - 08:22

When I first started posting results in the Games sub-forum, Makarias posted the following, which has been extremely helpful, and addresses your question a bit: http://forums.autosp...gary/?p=5882133

 

Thanks again, Makarias :wave:

 

 

I suppose you just copy/paste spreadsheet cells to make a row in your tables, say A1, B1 and C1 for the three columns of overall standings. They then come out with tabs between them, and since our nicknames vary in length the tabs don't get nicely aligned and the whole shebang looks messy.

You can instead merge the cell texts together into a single cell with the suitable amount of space characters between them to make it all look very tidy, write something like this in another cell:

=rept(" ";2-len(A1))&A1&" "&B1&rept(" ";35-len(B1))&rept(" ";3-len(C1))&C1

Breakdown:


rept(" ";2-len(A1))&A1 -First column (pos)
&" " -Space character between first and second column
&B1&rept(" ";35-len(B1)) -Second Column (names)
&rept(" ";3-len(C1))&C1 -Third Column (points)


*The & joins together different bits of text.

*The rept function repeats the single space written in the quote marks (you could write anything you'd like to repeat several times in there) and the X-len(Y) thing defines how many times it is repeated. =rept("a";5) returns aaaaa. The value of X determines the width of the column when the rept is joined together with cell Y. 35 is probably longer than necessary for forum nicks, around 20 or so may be enough.

*Note that the different order in the Second column (text before spaces) makes it left aligned, unlike First and Third columns, which become right aligned (spaces before text). The extra Space character between First and Second column is necessary when a left aligned column comes after a right aligned one.

*"rept" and "len" are english language commands and may have to be replaced by the corresponding commands in whatever language you use your spreadsheet; in Swedish they are "rep" and "längd".

Hopefully that helps and isn't completely stupid! I'm not any good with spreadsheets really.