How do you post a column aligned table of data ?

Discussions about the forum and contents
Post Reply
User avatar
ps56k
Posts: 799
Joined: Sat Mar 19, 2011 1:28 pm
Location: Chicago area

How do you post a column aligned table of data ?

Post by ps56k » Mon Jun 27, 2016 11:21 am

For some other threads,
how do you post a column aligned table of data ?

ie -
1 2 3 4
11 22 33 44
111 222 333 444

livesoft
Posts: 62360
Joined: Thu Mar 01, 2007 8:00 pm

Re: How do you post a column aligned table of data ?

Post by livesoft » Mon Jun 27, 2016 11:36 am

Like this:
ps56k wrote:For some other threads,
how do you post a column aligned table of data ?

ie -

Code: Select all

   1   2   3   4
  11  22  33  44
 111 222 333 444
Use the "Code" button and you will force a mono-spaced font within that section.
Wiki This signature message sponsored by sscritic: Learn to fish.

User avatar
ps56k
Posts: 799
Joined: Sat Mar 19, 2011 1:28 pm
Location: Chicago area

Re: How do you post a column aligned table of data ?

Post by ps56k » Mon Jun 27, 2016 11:37 am

tnx - I'll try that...

this is a test - using Firefox -
but the text on my typing screen is aligned, but the forum Preview it is not -
I must have a proportional font within the browser...

which means, I have to go back and forth between my "browser" image
and the resulting "Preview" image to get it all fudged to be aligned.

Code: Select all

Test      a    b    c    d
11         2    3    4    5
22       33  44   55  66

User avatar
CABob
Posts: 4586
Joined: Sun Feb 25, 2007 8:55 pm
Location: Southern California

Re: How do you post a column aligned table of data ?

Post by CABob » Mon Jun 27, 2016 11:56 am

Requesting additional information or clarification. I get:

Code: Select all

     1       2            3       4
    11      22          33     44
  111     222        333   444
What am I missing?
Bob

User avatar
triceratop
Moderator
Posts: 5581
Joined: Tue Aug 04, 2015 8:20 pm
Location: la la land

Re: How do you post a column aligned table of data ?

Post by triceratop » Mon Jun 27, 2016 11:57 am

This topic is now in the Forum Issues and Administration forum.
"To play the stock market is to play musical chairs under the chord progression of a bid-ask spread."

livesoft
Posts: 62360
Joined: Thu Mar 01, 2007 8:00 pm

Re: How do you post a column aligned table of data ?

Post by livesoft » Mon Jun 27, 2016 12:04 pm

CABob wrote:What am I missing?
You are not missing anything. You have too many space characters which take up space with a mono-spaced font.
Wiki This signature message sponsored by sscritic: Learn to fish.

User avatar
ps56k
Posts: 799
Joined: Sat Mar 19, 2011 1:28 pm
Location: Chicago area

Re: How do you post a column aligned table of data ?

Post by ps56k » Mon Jun 27, 2016 12:08 pm

When I am typing - I'm guessing the screen area I'm typing into is actually using a proportional font, as everything is aligned -
Then using the CODE and the Preview - it is NOT aligned - since the mono-spaced chars are now different compared to the proportional spacing.

Code: Select all

this is totally aligned while typing prior to Preview - 

this is using spaces       
                                   a       b      c       d       e
                                aaa    bbb  ccc    ddd   eee

this is using tabs	
				aa	aa	aa	aa	aa
				bb	bb	bb	bb	bb
				cc	cc	cc	cc	cc   

User avatar
telemark
Posts: 2300
Joined: Sat Aug 11, 2012 6:35 am

Re: How do you post a column aligned table of data ?

Post by telemark » Mon Jun 27, 2016 12:54 pm

What I do is type everything in another editor using a monospace font, then copy and paste into the browser. There are probably easier ways.

Edit to add: within a

Code: Select all

 section, of course.
Last edited by telemark on Mon Jun 27, 2016 1:01 pm, edited 1 time in total.

User avatar
Epsilon Delta
Posts: 7430
Joined: Thu Apr 28, 2011 7:00 pm

Re: How do you post a column aligned table of data ?

Post by Epsilon Delta » Mon Jun 27, 2016 12:59 pm

Also don't use tabs. It sometimes seems that tn two applications expand tabs exactly the same way.

Most text editors that support a fixed width font have an option to convert tabs to spaces.

DSInvestor
Posts: 10877
Joined: Sat Oct 04, 2008 11:42 am

Re: How do you post a column aligned table of data ?

Post by DSInvestor » Mon Jun 27, 2016 1:01 pm

If you do not have an editor that uses monospaced font, use a different character for the spaces maybe a '.'

This way you can see how many "spaces" you have between your columns.
Wiki

User avatar
ps56k
Posts: 799
Joined: Sat Mar 19, 2011 1:28 pm
Location: Chicago area

Re: How do you post a column aligned table of data ?

Post by ps56k » Mon Jun 27, 2016 4:40 pm

telemark wrote:What I do is type everything in another editor using a monospace font, then copy and paste into the browser.
There are probably easier ways..
But when you paste it into the browser window, doesn't it now become the "browser text" which is proportional -
I'll try - now is the time - Notepad with Courier - might work.. YES - THANKS -

Code: Select all


a    b    c    d
aa   bb   cc   dd
aaa  bbb  ccc  ddd

User avatar
#Cruncher
Posts: 2653
Joined: Fri May 14, 2010 2:33 am
Location: New York City
Contact:

Re: How do you post a column aligned table of data ?

Post by #Cruncher » Fri Jun 01, 2018 12:26 am

(I noticed this old thread referenced here by LadyGeek.)

If you have columns of different size numbers in a spreadsheet, you can use the Excel RIGHT and TEXT functions to align them. For example, here is a table prepared from three columns of numbers in cells A2:C45. It was prepared with the following formula entered in cell D2 and then copied down:

Code: Select all

=RIGHT("   "&A2,3)&RIGHT("         "&TEXT(B2,"#0.0"),9)&RIGHT("            "&TEXT(C2,"#,###,##0"),11)

Code: Select all

Age  Divisor    Balance
 70     27.4  1,000,000
 71     26.5    963,504
 72     25.6    927,145
 73     24.7    890,928
 74     23.8    854,858
 75     22.9    818,940
 76     22.0    783,178
 77     21.2    747,579
 78     20.3    712,316
 79     19.5    677,227
 80     18.7    642,497
 81     17.9    608,139
 82     17.1    574,165
 83     16.3    540,588
 84     15.5    507,423
 85     14.8    474,686
 86     14.1    442,613
 87     13.4    411,222
 88     12.7    380,534
 89     12.0    350,570
 90     11.4    321,356
 91     10.8    293,167
 93      9.6    266,022
 94      9.1    238,311
 95      8.6    212,123
 96      8.1    187,458
 97      7.6    164,315
 98      7.1    142,694
 99      6.7    122,597
100      6.3    104,299
101      5.9     87,743
102      5.5     72,872
103      5.2     59,622
104      4.9     48,156
105      4.5     38,329
106      4.2     29,811
107      3.9     22,713
108      3.7     16,889
109      3.4     12,325
110      3.1      8,700
111      2.9      5,893
112      2.6      3,861
113      2.4      2,376
114      2.1      1,386
With only a few rows it's simpler to just copy/paste the cells from the spreadsheet into an editor (using a monospace font) and add spaces manually. But with many rows, using a formula is quicker.

Post Reply