Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Hello everyone. In an excel file I have two rows of texts. In first row, I used local language font and the second row I used superscript to show degree Celsius. Both the texts are displayed correctly in cell but different in formula bar. I want vmix to display the data shown in the cell not the formula bar. Thanks. 22.jpg (91kb) downloaded 1 time(s).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/6/2013(UTC) Posts: 89
Thanks: 20 times Was thanked: 10 time(s) in 10 post(s)
|
vMix always reads the raw data without formatting. You'd have to use the correct symbol for degree and not a 0 which has been formatted. You'll find the degree-symbol if you click on the Tab Insert and the symbol.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Originally Posted by: fenki86 vMix always reads the raw data without formatting. You'd have to use the correct symbol for degree and not a 0 which has been formatted. You'll find the degree-symbol if you click on the Tab Insert and the symbol. Thank you for your reply. What about the font? Any solution please.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/6/2013(UTC) Posts: 89
Thanks: 20 times Was thanked: 10 time(s) in 10 post(s)
|
the font wouldn't matter - but you can try Arial for example. Or just hold down your ALT-key on the Keyboard and while holding the button down press 0176 on the numpad. If you release the ALT-Button it'll insert the degree-symbol.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,188 Location: Belgium Thanks: 288 times Was thanked: 947 time(s) in 782 post(s)
|
can always just use the value in your datasource (omit the °C) and format the ddatasource connection in the title Screenshot 2023-07-26 120833.jpg (32kb) downloaded 1 time(s).
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Originally Posted by: fenki86 the font wouldn't matter - but you can try Arial for example. Or just hold down your ALT-key on the Keyboard and while holding the button down press 0176 on the numpad. If you release the ALT-Button it'll insert the degree-symbol. Thank you. I mean the font/language I used in the first row. I used local language font that shows correctly in the cell but not in the raw(formula bar). vMix display the formula bar value. please!
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Originally Posted by: Maku Originally Posted by: fenki86 the font wouldn't matter - but you can try Arial for example. Or just hold down your ALT-key on the Keyboard and while holding the button down press 0176 on the numpad. If you release the ALT-Button it'll insert the degree-symbol. Thank you, I got one answer. Second one is the font/language I used in the first row. I used local language font that shows correctly in the cell but not in the raw(formula bar). vMix display the formula bar value. please!
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Originally Posted by: doggy can always just use the value in your datasource (omit the °C) and format the ddatasource connection in the title Screenshot 2023-07-26 120833.jpg (32kb) downloaded 1 time(s). Thank you doggy. First row problem please?
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,188 Location: Belgium Thanks: 288 times Was thanked: 947 time(s) in 782 post(s)
|
Originally Posted by: Maku
Thank you doggy. First row problem please?
Have you tried using same font in vMix (title) itself ?
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 3/6/2013(UTC) Posts: 89
Thanks: 20 times Was thanked: 10 time(s) in 10 post(s)
|
as doggy mentioned you'd have to use this font in vmix as well. If it's on another computer you might have to install the font there first.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/24/2023(UTC) Posts: 8
|
Originally Posted by: doggy Originally Posted by: Maku
Thank you doggy. First row problem please?
Have you tried using same font in vMix (title) itself ? Yes. I used in GT title there It worked perfectly.
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close