The problem with vars used inside functions are they exist only in the function.
To solve this, you can use a function definition in this way:
(1)
This definition is describen in this post:
Arial matrix
How was able Oscar to get this matrix in ?
For this use teh function \[REGION[52ca5f2af1cb4cde87579f79793539f9]]\ which creates
an array containing a greyscale representation of your BMP.
So you can do this:
1) Define a variable to capture the output of the function \[REGION[60124f242cfe4ecf971fb12e032ae24c]]\
2) Read the content of that variable, which is a matrix.
in the Arial (or any other font ) array shown in the above collapsed Area there are:
- 6 rows of 20 pixel each + one row of 1 pixel I guess at the bottom of the area/picture
- 16 columns (Character) of 14 pixel each + one row of 1 pixel I guess at the extreme right of the area/picture
Character size is - 14 width x 20 height (in pixel)
3) Copy all the files and rows of that matrix via Ctrl+C (be careful, sometimes
this matrix could be huge!), then paste the copied contents into the definition
of another variable:
16 Columns x 6 Rows picture
Attention!! some Character are not properly positioned in the Array so it is required a refinement of this aspect (for instance the Character "W"
4) Now you can delete the first variable and save only this last one. In my case
that last variable was the "Arial Matrix"
I have added at the beginning of C$ the space Char
Conversion of a Text String in a bitmap string built with a monospaced (bitmap) font
Scalable monospaced bitmapped fonts in XYPlot
Load from an Excel file a matrix of data, each row is related to a Character in the string C$, indeed the 5 columns have the following meaning:
Column1: is the position of a character in C$ ( for instance the number 4 corresponds to the character "#", space " " is the 1st character of the string )
Columns from 2 to 5 are the rows and columns index for the extraction of a submatrix from the Arial matrix corresponding to the character whose position is specified to the first column of this matrix , in details they are:
Column2: is the index of the row start range
Column3: is the index of the row end range
Column4: is the index of the column start range
Column5: is the index of the column end range
NO MORE USED - JUST AEFERENCE FOR THE GENERAL FORMULAS
Matrix that stores the coordinates of the starting vertical positions of the row(s) of the callout text, defined according to the specs stated previously. I have decided to develop general formulas for these position and don't pick up the specific formulas from this matrix
Word Wrapping routine
Purpose of the user defined function : split an input text string in rows of a defined length
Inputs: ts - string of text to wrap
tw - maximum length of each row of wrapped text
Output: an array of row(s) of text wrapped/split at the maximum length tw
\
| Variables Inizialization
|
|
|
/
StrPos is the starting position of a character in the Input text string of the text row to wrap
EndPos is the last position of a character in the Input text string of the text row to wrap
this is the total length of the Input Text String
i_row is the index of the Array that stores the wrapped rows of text
While the position of the cursor/character EndPos is less then the length of the Input Text String executes the line istructions
check if the character at EndPos (so at the end of a substring of tw characters) is not a space
if this is true check if at the next character position there isn't a space
if this is true this means that we will split a word if we break the text string at StrPos
so we need to find the position of the last word in the TextRow string and update accordingly the positions/values of the variables StrPos and EndPos and extracts a substring and store it in the array TextWrapped , is length is less then tw
otherwise
extracts a substring of tw characters and store it in the array TextWrapped
and updates the starting and ending position to use on the next substring in the while loop
to avoid that that this substring start with a space it is added a + 2 and not a +1
in the StrtPos expression
otherwise
(extracts a substring of tw characters and store it in the array TextWrapped
(subtracting -1 from TextWidth avoids that the rows of wrapped text end with a space)
and update accordingly the positions/values of the variables StrPos and EndPos
increment the i_row index
when the while do loop ends we must manage the extraction of the last part of
TextString so assign to the variable LastRowLength the width of the last substring to extract starting at the position StrPos
Some details about the arguments of the CalloutArrow function.
pp - defines (in this order only and using stack function ) the coordinates of the eteremes of the arrow part of the callout, STARTING with the position of the Arrow Head and then with the position of the Arrow End that we refer as the "central" point of the callout.
H_Length - is the length of the horizontal part of the callout can be positive or negative if positive it is drawn on the right side with respect to the "central" point of the callout.
The remaining arguments have already been covered in the collapsed area titled "Shape Specs" (in another worksheet )so check there for further details
L_arrow
is the length of the segment that defines the Arrow Head
α_arrow
is the angle (acute ) that the L_arrow segment forms with the arrow central line
the values of the 2 above defined parameters can be modified to address particular graphical needs
Text to BMP conversion function
Purpose of the user defined function : converts each character of a text string in a string of BMP characters taken from a
specified font family stored in a matrix (Monospaced)
Input : TextMatrix = matrix with in each rows a text string to convert in BMP,
FontFamily = matrix that stores BMP repesentation of each char in C$
Output:Text_BMP = matrix that strores in each row the result of the conversion of
the corresponding Input row (of the matrix TextMatrix) in a BMP array
CharH is the Height of each Char in the matrix FontFamily
N_Rows is the number of rows in the Input matrix TextMatrix
External Loop on each row of the Input matrix TextMatrix
Define a storage matrix τ for the resulting converted text string in BMP
Internal Loop on each character present in the previous selected row of TextMatrix
extracts a character and stores it in the var Char
find its position (if exists ) in C$, if
doesn't
exists place in Char_Index 0
so if CharIndex is 0
replaces the searched character with a space " " and place the extracted submatrix it in the matrix τ
otherwise
extracts from the FontFamily matrix the corresponding char in BMP and places it in the matrix τ
at the End of the Internal Loop strores the content of the matrix τ , so a text string as BMP in the matrix Text_BMP
that is devoted to the storage of each converted text string
this is another function that is used to position a string of text in BMP form at a certain point, scaling it by a factor k
Word Wrapping example(s) of usage
how many rows of text are available in the Output matrix
Text to BMP example(s) of usage
result of the search of a character in the string C$, if it is NOT found the result is 0
I need to specify the index 1 because the output from the
txt2BMP function is a (1 level) nested matrix and the pos function requires just the internal level
XYLabel'XLabel:"", XYLabel'YLabel:""
An attempt to define the size of a character of the selected Bitmap Monospaced font (Arial)
in the pos function there is a scale factor k that changes the size of the character drawn , have drawn a character with different scale factor to understand the relationship of the character size with the scale factor
From the tests done have seen that :
Character height = 1.43 ( 20 Pixel) for a scale factor k of 1
Character width = 0.70 ( 14 Pixel ) both are rough evaluations
reducing the scale factor of \[REGION[d58722133bde44708d6153e958289e52]]\ or \[REGION[002a1b3f6a8b471e8d9fb69f4d01af94]]\ reduces the dimensions of the character matrix of the same quantity in proportion
So to position vertically the rows of bitmap converted text we need to define a line spacing that is related to the size (height) of the character ( based on the k factor) .
Assumptions: We define for now that :
- the line spacing is \[REGION[c655f0ecbf614166b18926a965e70aa6]]\ of the character height (I have seen that 1/10 is too much because the font includes a lot of space at the bottom part )
- the maximum number of text rows to display in a Callout will be 8 ( even if I guess that we will not exeed the 4 ones, the hypotesis is of Callout not too verbose )
If the number of rows is 1 this row is positioned in 2nd position
2 these rows are positioned in 2nd and 3rd position
3 these rows are positioned in 1st,2nd and 3rd position see picture on the right for row positioning
4 these rows are positioned in 1st,2nd,3rd and 4th position
Size in pixel of drawn Character = 66 x 99 k = 1 -
33 x 49 k = 2 -
22 x 34 k = 3 evaluated using a pixel ruler
the coordinates of the segments have been found by trial and error
we see that the "W" is not printed correctly need to find with Oscar how he produced the Arial mono and try to correct this or other similar errors in the future
Herewith I have tried to develop a procedure (CreateCallout) that put together all the user functions developed previously trying to minimize the data necessary to obtain the final result .....
In the following function, the variable TextCallout is created inside, so you need to save it to an external file, then define the function in the form showed on (1)
Tests for the positioning of the bitmaped text on the Callout changing the input Text length
Coordinates of the Callout arrowhead and arrow end (don't change these names)
Wrapping length in characters
with a blue background are the Input data
for k_ equal 1
with a green background are Parameters
the orizontal part before the callout text is in relation with the Text wrapping length as the Golden Ratio , moreover to change/reduce this part I have introduced a k_horiz scale factor
Coordinates of the Callout arrowhead and arrow end (don't change these names)
Callout Arrow drawing
doing in the previous way both the geometric and textual part of the callout are drawn in the XY plot area correctly