PDA

View Full Version : Swiss Perfect to Word or Excel so that crosstables appear in neat columns



Kevin Bonham
01-02-2010, 11:54 PM
Another layout issue I'm absolutely clueless about, I've tried all kinds of things but none of them work.

When the Copy View function is used in SP you can use CODE tags here to get it to appear in neat lines (give or take the odd error when a word is too long or something like that.)

However I just can't find a way to copy crosstables into Word so that they don't come out looking like this (or like this with some amount of spacing thrown in):

Even paste into Excel as Unicode Text, which often solves problems like this, doesn't work. And copying them from a correct display here doesn't work either. Any help appreciated.

No Name Feder Loc Total 1 2 3 4 5 6 7 8 9 10 11

1 Pan, Andrew NSW 1672 11 35:W 14:W 8:W 6:W 2:W 5:W 22:W 4:W 3:W 9:W 11:W
2 Behar, Joshua NSW 1361 8.5 24:W 7:W 15:W 3:W 1:L 14:W 8:W 11:W 9:L 4:W 5:D
3 Dale, Ari VIC 1085 7.5 31:W 4:W 9:W 2:L 10:W 8:L 5:W 16:W 1:L 6:D 15:W
4 Jack, Martin QLD 1349 7.5 37:W 3:L 18:W 7:W 5:D 24:W 14:W 1:L 8:W 2:L 9:W
5 Mason, Stuart ACT 1218 7.5 28:D 33:W 10:W 17:W 4:D 1:L 3:L 29:W 18:W 15:W 2:D
6 Kiripitige, Punala SA 1332 7.5 34:W 19:W 23:W 1:L 14:L 9:W 16:D 8:D 12:W 3:D 10:W
7 Hughes, Harry QLD 981 7 39:W 2:L 25:W 4:L 13:D 35:W 11:L 28:W 23:D 30:W 14:W
8 Cameron, Lachlan SA 1154 6.5 36:W 42:W 1:L 21:W 29:W 3:W 2:L 6:D 4:L 10:L 23:W

(etc)

Basil
02-02-2010, 12:02 AM
Kev, [code]-to-WORD problems will magically disappear if you use (in WORD) one of the <momentarily forgotten the name of the group> fonts such as Courier.

So ...
1. Copy your [code] text to the computer's memory.
2. Paste into WORD doc
3. Select pasted text and change font to Courier.

Carry on!

Garvinator
02-02-2010, 12:04 AM
Another layout issue I'm absolutely clueless about, I've tried all kinds of things but none of them work.

When the Copy View function is used in SP you can use CODE tags here to get it to appear in neat lines (give or take the odd error when a word is too long or something like that.)

However I just can't find a way to copy crosstables into Word so that they don't come out looking like this (or like this with some amount of spacing thrown in):

Even paste into Excel as Unicode Text, which often solves problems like this, doesn't work. And copying them from a correct display here doesn't work either. Any help appreciated.

No Name Feder Loc Total 1 2 3 4 5 6 7 8 9 10 11

1 Pan, Andrew NSW 1672 11 35:W 14:W 8:W 6:W 2:W 5:W 22:W 4:W 3:W 9:W 11:W
2 Behar, Joshua NSW 1361 8.5 24:W 7:W 15:W 3:W 1:L 14:W 8:W 11:W 9:L 4:W 5:D
3 Dale, Ari VIC 1085 7.5 31:W 4:W 9:W 2:L 10:W 8:L 5:W 16:W 1:L 6:D 15:W
4 Jack, Martin QLD 1349 7.5 37:W 3:L 18:W 7:W 5:D 24:W 14:W 1:L 8:W 2:L 9:W
5 Mason, Stuart ACT 1218 7.5 28:D 33:W 10:W 17:W 4:D 1:L 3:L 29:W 18:W 15:W 2:D
6 Kiripitige, Punala SA 1332 7.5 34:W 19:W 23:W 1:L 14:L 9:W 16:D 8:D 12:W 3:D 10:W
7 Hughes, Harry QLD 981 7 39:W 2:L 25:W 4:L 13:D 35:W 11:L 28:W 23:D 30:W 14:W
8 Cameron, Lachlan SA 1154 6.5 36:W 42:W 1:L 21:W 29:W 3:W 2:L 6:D 4:L 10:L 23:W

(etc)
After copying into word from sp, highlight all the text and then use courier new font.

Kevin Bonham
02-02-2010, 12:04 AM
Amazing. Thanks and glad it was that simple.

Garvinator
02-02-2010, 12:04 AM
Snap!

Basil
02-02-2010, 12:09 AM
Monospaced is the word I was looking for. Monospaced fonts (as opposed to variable width) include monaco, courier and andale mono.

Brian_Jones
02-02-2010, 08:46 AM
Monospaced is the word I was looking for. Monospaced fonts (as opposed to variable width) include monaco, courier and andale mono.

Fonts which use non-proportional spacing!

Jesper Norgaard
02-02-2010, 11:12 AM
Fonts which use proportional spacing!
No. Actually proportional spacing means the size of "B" and "." is very different, since the letters themselves occupy very different size. This means mono-spaced is the opposite of proportionally spaced, e.g. they have fixed size for any letter. I am sure Gunner Underpants is the expert in this area, and I am the novice, but I think Brian is wrong (unless I misunderstood his comment).

Bill Gletsos
02-02-2010, 12:15 PM
Another layout issue I'm absolutely clueless about, I've tried all kinds of things but none of them work.

When the Copy View function is used in SP you can use CODE tags here to get it to appear in neat lines (give or take the odd error when a word is too long or something like that.)

However I just can't find a way to copy crosstables into Word so that they don't come out looking like this (or like this with some amount of spacing thrown in):

Even paste into Excel as Unicode Text, which often solves problems like this, doesn't work. And copying them from a correct display here doesn't work either. Any help appreciated.

No Name Feder Loc Total 1 2 3 4 5 6 7 8 9 10 11

1 Pan, Andrew NSW 1672 11 35:W 14:W 8:W 6:W 2:W 5:W 22:W 4:W 3:W 9:W 11:W
2 Behar, Joshua NSW 1361 8.5 24:W 7:W 15:W 3:W 1:L 14:W 8:W 11:W 9:L 4:W 5:D
3 Dale, Ari VIC 1085 7.5 31:W 4:W 9:W 2:L 10:W 8:L 5:W 16:W 1:L 6:D 15:W
4 Jack, Martin QLD 1349 7.5 37:W 3:L 18:W 7:W 5:D 24:W 14:W 1:L 8:W 2:L 9:W
5 Mason, Stuart ACT 1218 7.5 28:D 33:W 10:W 17:W 4:D 1:L 3:L 29:W 18:W 15:W 2:D
6 Kiripitige, Punala SA 1332 7.5 34:W 19:W 23:W 1:L 14:L 9:W 16:D 8:D 12:W 3:D 10:W
7 Hughes, Harry QLD 981 7 39:W 2:L 25:W 4:L 13:D 35:W 11:L 28:W 23:D 30:W 14:W
8 Cameron, Lachlan SA 1154 6.5 36:W 42:W 1:L 21:W 29:W 3:W 2:L 6:D 4:L 10:L 23:W

(etc)Have you tried Export View as Text from the File menu.

Kevin Bonham
02-02-2010, 12:29 PM
Have you tried Export View as Text from the File menu.

On my copy, which may not be the last available build, there is a Save View as Text option which creates a text file. Copying and pasting from that text file into Word appears to have the same issue - some fonts work, others don't.

Basil
02-02-2010, 12:53 PM
Some background reading.

Monospaced Fonts (http://en.wikipedia.org/wiki/Monospaced_font)
Typefaces (http://en.wikipedia.org/wiki/Typeface)

Brian_Jones
02-02-2010, 01:42 PM
A proportional typeface contains glyphs of varying widths, while a monospaced (non-proportional or fixed-width) typeface uses a single standard width for all glyphs in the font.

Sans serif, serif, whatever will be will be! ;)

ElevatorEscapee
13-02-2010, 09:33 AM
"Serif" means that the typeface/font has "Feet", ie "TIMES NEW ROMAN" (note the capital "I").

"Sans serif" means that the typeface/font is without "feet", eg ARIAL. (Note the difference in the capital "I", this one doesn't have feet).


This image is in a proportional font... and it doesn't work.
___ _____
.'/,-Y" "~-.
l.Y ^.
/\ _\_
i ___/" "\
| /" "\ o !
l ] o !__./
\ _ _ \.___./ "~\
X \/ \ ___./
( \ ___. _..--~~" ~`-.
` Z,-- / \
\__. ( / ______)
\ l /-----~~" / -Mmmmmm, Australian Chess Magazine...
Y \ /
| "x______.^
| \
j Y

The Courier font is non-proportional which allows people to post SwissPerfect results and also to design ASCII text art, (sometimes you need to use the "code" command to get it all to work).




___ _____
.'/,-Y" "~-.
l.Y ^.
/\ _\_
i ___/" "\
| /" "\ o !
l ] o !__./
\ _ _ \.___./ "~\
X \/ \ ___./
( \ ___. _..--~~" ~`-.
` Z,-- / \
\__. ( / ______)
\ l /-----~~" / -Mmmmmm, Australian Chess Magazine...
Y \ /
| "x______.^
| \
j Y

Adamski
13-02-2010, 09:54 AM
Well done Homer Simpson Elevator Escapee! (HSEE for short.)

Rincewind
13-02-2010, 10:03 AM
The other problem you have with the Homer picture is that vBulletin trims multiple spacing to a single space so that even with a fixed-width font homer would have issues outside of a code block.

Regarding the original Swiss Perfect to Word question the following might be some sort of an option as well...

When exporting the view from SP perform a text export and use a separator character of "|". Then open the text file, cut and paste into Word. Then elect the pasted block and choose Table -> Convert -> Text to table at the bottom of the dialogue box there is a spot to enter the separation character where you enter "|". Voila! You have a Word table which you can format to your hearts desire.

themovingman
14-02-2010, 07:39 PM
Kev, [code]-to-WORD problems will magically disappear if you use (in WORD) one of the <momentarily forgotten the name of the group> fonts such as Courier.

So ...
1. Copy your [code] text to the computer's memory.
2. Paste into WORD doc
3. Select pasted text and change font to Courier.

Carry on!

some others msword 2007 for win has :

Lucida Console
Lucida Sans Typewriter
Bitstream Vere Sans Mono
Consolas
DejeVu Sans Mono
MS gothic
MS mincho