DataSource superscript - Excel superscript Options  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

Maku		#1 Posted : Wednesday, July 26, 2023 5:56:29 AM(UTC)
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).
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.

fenki86		#2 Posted : Wednesday, July 26, 2023 4:55:17 PM(UTC)
Rank: Advanced Member Groups: Registered Joined: 3/6/2013(UTC) Posts: 91 Thanks: 21 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.
User Profile View All Posts by User View Thanks

Maku		#3 Posted : Wednesday, July 26, 2023 7:20:07 PM(UTC)
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.
User Profile View All Posts by User View Thanks

fenki86		#4 Posted : Wednesday, July 26, 2023 7:44:56 PM(UTC)
Rank: Advanced Member Groups: Registered Joined: 3/6/2013(UTC) Posts: 91 Thanks: 21 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.
User Profile View All Posts by User View Thanks

doggy		#5 Posted : Wednesday, July 26, 2023 8:10:49 PM(UTC)
Rank: Advanced Member Groups: Registered Joined: 12/27/2012(UTC) Posts: 5,216 Location: Belgium Thanks: 291 times Was thanked: 955 time(s) in 790 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).
User Profile View All Posts by User View Thanks

Maku		#6 Posted : Wednesday, July 26, 2023 8:28:44 PM(UTC)
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!
User Profile View All Posts by User View Thanks

Maku		#7 Posted : Wednesday, July 26, 2023 8:34:46 PM(UTC)
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!
User Profile View All Posts by User View Thanks

Maku		#8 Posted : Wednesday, July 26, 2023 8:39:56 PM(UTC)
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?
User Profile View All Posts by User View Thanks

doggy		#9 Posted : Wednesday, July 26, 2023 9:50:22 PM(UTC)
Rank: Advanced Member Groups: Registered Joined: 12/27/2012(UTC) Posts: 5,216 Location: Belgium Thanks: 291 times Was thanked: 955 time(s) in 790 post(s)		Originally Posted by: Maku Thank you doggy. First row problem please? Have you tried using same font in vMix (title) itself ?
User Profile View All Posts by User View Thanks

fenki86		#10 Posted : Wednesday, July 26, 2023 11:38:04 PM(UTC)
Rank: Advanced Member Groups: Registered Joined: 3/6/2013(UTC) Posts: 91 Thanks: 21 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.
User Profile View All Posts by User View Thanks

Maku		#11 Posted : Friday, July 28, 2023 2:45:14 PM(UTC)
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.
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (3)