List Info

Thread: How to simulate Ctrl-Enter while inserting data into spreadsheet cells




How to simulate Ctrl-Enter while inserting data into spreadsheet cells
user name
2007-08-30 05:20:20
Hi everybody,

i'm parsing data from a csv-file and insert this data into a
spreadsheet using 
the uno-api.
The data values which are parsed consist of one or several
numbers, e.g.
123;456;789 463. The value 123 is inserted into cell1, the
value 456 into 
cell2. The values 789 and 463 shall be inserted into cell3,
namely not side 
by side but one below the other in two rows.
The attempt to insert ascii 13 (CR) between the last two
values was 
unsuccessful. Does somebody know if the api provides a
special control 
character which can be used to simulate a line break within
a spreadsheet 
cell (or perhaps someone knows if an ascii code for
Ctrl-Enter exists)?

Best regards,
Reinhold

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org


Re: How to simulate Ctrl-Enter while inserting data into spreadsheet cells
user name
2007-08-30 06:34:39
Reinhold Merk wrote:

halo,

i used

    
oLogText.insertControlCharacter(oLogCursor,com.sun.star.text
.ControlCharacter.PARAGRAPH_BREAK,False)

so i supose there must be a similar
"ControlCharacte"  to meet your needs

hop it helps a bit
Fernad
> Hi everybody,
>
> i'm parsing data from a csv-file and insert this data
into a spreadsheet using 
> the uno-api.
> The data values which are parsed consist of one or
several numbers, e.g.
> 123;456;789 463. The value 123 is inserted into cell1,
the value 456 into 
> cell2. The values 789 and 463 shall be inserted into
cell3, namely not side 
> by side but one below the other in two rows.
> The attempt to insert ascii 13 (CR) between the last
two values was 
> unsuccessful. Does somebody know if the api provides a
special control 
> character which can be used to simulate a line break
within a spreadsheet 
> cell (or perhaps someone knows if an ascii code for
Ctrl-Enter exists)?
>
> Best regards,
> Reinhold
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>   

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org


[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )