I have some multi-line problems to solve in order to use Calc as a code
generator tool. It boils down to solving the following example...
In cell A1 type (using CTRL-ENTER to enter the carriage returns / new
lines):
class A {
int x;
};
The row resizes beautifully showing all 3 lines in the cell. Then in
cell B1 type:
=A1
Whereas in cell A1 the text is formatted correctly with multiple lines,
cell B1 shows the text all on one line:
class A { int x; };
Each carriage return has been replaced by a space. I can't find any
formatting options to get the display the same as A1. Can the correct
formatting be achieved somehow? I managed to get this to display as
expected in Excel 2003, but as the generator tool is for an open source
project developed mainly on Linux, that just isn't isn't going to cut it!
A second issue is when using Basic to read the contents of the cell, the
carriage return has been filtered away again when using a 'String' as
the type passed to the function. How does one get the carriage return
from Basic, or even one of the other macro languages: Python, Beanshell
or Javascript? Again I can obtain the carriage return using VBA and
'String' in Excel.
William
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
