Ask Your Question

Hello, how can I format part of a string returned by a function as subscript?

asked 2016-06-06 19:00:23 +0200

2trax gravatar image

I need to concatenate several cells in calc. The contents of one of the cells must appear in subscript in the final output (the resulting string is engineering notation). Is there a way of specifying formatting for parts of a string?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-07 08:22:55 +0200

JohnSUN gravatar image

Unfortunately, the return value of a user defined function - a string, just a string without any formatting options. However, you can create value in a cell by the procedure. In this case you can processing cell with property Text - including formatting arbitrary part thereof.

edit flag offensive delete link more


Related question with answer:

LeroyG gravatar imageLeroyG ( 2020-07-30 20:35:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-06 19:00:23 +0200

Seen: 135 times

Last updated: Jun 07 '16