How do you post a column aligned table of data ?
How do you post a column aligned table of data ?
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
how do you post a column aligned table of data ?
ie -
1 2 3 4
11 22 33 44
111 222 333 444
Re: How do you post a column aligned table of data ?
Like this:
Use the "Code" button and you will force a mono-spaced font within that section.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
Re: How do you post a column aligned table of data ?
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.
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
Re: How do you post a column aligned table of data ?
Requesting additional information or clarification. I get:
What am I missing?
Code: Select all
1 2 3 4
11 22 33 44
111 222 333 444
Bob
- triceratop
- Moderator
- Posts: 5831
- Joined: Tue Aug 04, 2015 8:20 pm
- Location: la la land
Re: How do you post a column aligned table of data ?
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."
Re: How do you post a column aligned table of data ?
You are not missing anything. You have too many space characters which take up space with a mono-spaced font.CABob wrote:What am I missing?
Re: How do you post a column aligned table of data ?
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.
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
Re: How do you post a column aligned table of data ?
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
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.
- Epsilon Delta
- Posts: 7868
- Joined: Thu Apr 28, 2011 7:00 pm
Re: How do you post a column aligned table of data ?
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.
Most text editors that support a fixed width font have an option to convert tabs to spaces.
-
- Posts: 10954
- Joined: Sat Oct 04, 2008 11:42 am
Re: How do you post a column aligned table of data ?
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.
This way you can see how many "spaces" you have between your columns.
Re: How do you post a column aligned table of data ?
But when you paste it into the browser window, doesn't it now become the "browser text" which is proportional -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..
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
Re: How do you post a column aligned table of data ?
(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:
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.
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