logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Maku  
#1 Posted : Wednesday, July 26, 2023 5:56:29 AM(UTC)
Maku

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).
fenki86  
#2 Posted : Wednesday, July 26, 2023 4:55:17 PM(UTC)
fenki86

Rank: Advanced Member

Groups: Registered
Joined: 3/6/2013(UTC)
Posts: 87

Thanks: 20 times
Was thanked: 9 time(s) in 9 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.
Maku  
#3 Posted : Wednesday, July 26, 2023 7:20:07 PM(UTC)
Maku

Rank: Newbie

Groups: Registered
Joined: 4/24/2023(UTC)
Posts: 8

Originally Posted by: fenki86 Go to Quoted Post
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.

fenki86  
#4 Posted : Wednesday, July 26, 2023 7:44:56 PM(UTC)
fenki86

Rank: Advanced Member

Groups: Registered
Joined: 3/6/2013(UTC)
Posts: 87

Thanks: 20 times
Was thanked: 9 time(s) in 9 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.
doggy  
#5 Posted : Wednesday, July 26, 2023 8:10:49 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,075
Belgium
Location: Belgium

Thanks: 284 times
Was thanked: 920 time(s) in 759 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).
Maku  
#6 Posted : Wednesday, July 26, 2023 8:28:44 PM(UTC)
Maku

Rank: Newbie

Groups: Registered
Joined: 4/24/2023(UTC)
Posts: 8

Originally Posted by: fenki86 Go to Quoted Post
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!
Maku  
#7 Posted : Wednesday, July 26, 2023 8:34:46 PM(UTC)
Maku

Rank: Newbie

Groups: Registered
Joined: 4/24/2023(UTC)
Posts: 8

Originally Posted by: Maku Go to Quoted Post
Originally Posted by: fenki86 Go to Quoted Post
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!


Maku  
#8 Posted : Wednesday, July 26, 2023 8:39:56 PM(UTC)
Maku

Rank: Newbie

Groups: Registered
Joined: 4/24/2023(UTC)
Posts: 8

Originally Posted by: doggy Go to Quoted Post
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?
doggy  
#9 Posted : Wednesday, July 26, 2023 9:50:22 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,075
Belgium
Location: Belgium

Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
Originally Posted by: Maku Go to Quoted Post


Thank you doggy. First row problem please?


Have you tried using same font in vMix (title) itself ?
fenki86  
#10 Posted : Wednesday, July 26, 2023 11:38:04 PM(UTC)
fenki86

Rank: Advanced Member

Groups: Registered
Joined: 3/6/2013(UTC)
Posts: 87

Thanks: 20 times
Was thanked: 9 time(s) in 9 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.
Maku  
#11 Posted : Friday, July 28, 2023 2:45:14 PM(UTC)
Maku

Rank: Newbie

Groups: Registered
Joined: 4/24/2023(UTC)
Posts: 8

Originally Posted by: doggy Go to Quoted Post
Originally Posted by: Maku Go to Quoted Post


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.
Users browsing this topic
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.