special characters in Spread Sheet Reports

[orlando Teixeira]

Hello PPl, everythings fine ?

well, i am trying to put an m? on my spread sheet reports.

I tryied diferent codes (i am on windows - vista by the way) like alt+253 or alt + 0178 (arial font) that works in basic text.

The curious thing is that inside spreadsheet it look fine but after leaving it and returning to vectorworks it allways shows an square root symbol .... can anyone help me with this ?

I took print screen's and added an image so you can easily understand what i mean.

Thx in Advanced

[orlando Teixeira]

no one knows why it does this ? ... . is it a BUG ?

[_c_]

Orlando, how are you exporting this worksheet? On WinXP if I use altGr+253 it works, since "superscript two" is the character for the IBM PC table.

ASCII PC table

Whereby I saw this failing, don't remember when and how. I can imagine some conditions where this cannot work, can you tell more about it?

orso

[orlando Teixeira]

well orso, i do not use altGR but simple alt. I cannot insert characters with altGR.

Anyway perhaps i didnt made myself clear :

Its Not an Spreadsheet but an worksheet Data that i am using on my project. I normally use "m2" when i can not do otherwise. In VW till now the only "spot" that doesnt accept alt+253 or alt+0178 is the worksheet data layout.

In text (normal text) it works like a charm, even in unit setting it works perfectly so i do not know why it doesn work here.

Here i leave an swf little movie showing what i mean. As you probably notice on the begining of the movie a piece of text is on top of worksheet data and the ascii character worked fine.

(Please rename .jpg to swf because forum file manager didnt not let me upload swf files)

[orlando Teixeira]

no help ?

why cant anybody help me ?

i dont understand why only orso answered . . .

please , please help me . . .

Thx in Advanced

[Pat Stanford]

You have gotten no answers because no one has an answer to give you.

The worksheets in VW 2009 (and 2010) do not appear to be fully unicode aware, so you can not enter all of the available characters. And you can only format cells, not parts of data inside a cell.

You will have to live with m2 without the superscript in the worksheet.

[orlando Teixeira]

Hello Pat,

Ok, i suspected that but why the heck when i am inside worksheet the character apears but when i close to return it changes to square root ? supousely it should not work inside worksheet eider!!!!

Am i rigth or wrong?

ps. sorry for puxing but it is a really nice tool and i wanted to give it the same look as i give to the rest of the document ... is there a way to hack this ?

Thx in Advanced

[Pat Stanford]

Check and see if you have GDI+ rendering turned on in the VW Prefs.

I saw something similar with Hebrew a few years ago. You could enter text correctly, but when you exited the text edit box it messed up. GDI (Win) or Quartz (Mac) solved the problem. I don't remember which.

[Kool Aid]

Did it? I'd rather believe that the issue is about Unicode vs. ASCII.

[Pat Stanford]

Did it? I'd rather believe that the issue is about Unicode vs. ASCII.

I think it is both. I think Unicode support requires that GDI/Quartz be turned on. You decide if that means a graphic system or a unicode/ascii issue.

[orlando Teixeira]

Well Pat

THX YOU, THX YOU, THX YOU

VERY MUCH IT WORKED PERFECTLY

Gdi was was turned on.

Thx Again Pat

ps. well , sometimes the answers appear when you least expected

[starling75]

Sometimes it works contrariwise check the Czech ...

http://techboard.nemetschek.net/ubbthreads/ubbthreads.php?ubb=showflat&Main=26207&Number=125908#Post125908

[_c_]

Dear me, Pat. I didn't know that. One never ends learning.

Sorry for delaying in the answer. I couldn't download the swf on the Mac (where superscript cannot work for sure) and on Win in the office I could never remember while working.

GDI? mmmmm.....

orso