Apache OpenOffice Community Forum

I'm just try to avoid some problems with converting from xls to pdf by preprocessing document.

Zizi64 wrote: ↑Wed Aug 03, 2022 3:52 pm Then use Excel.

But am I asking for something impossible?

Zizi64 wrote: ↑Wed Aug 03, 2022 6:09 pmAbsolutely not,

Sub Main
 Dim myCell As Object, myCursor As Object
 Dim myBreak As String

   myCell = thisComponent.Sheets.getByName("Feuille1").getCellRangeByName("A1")
 myCursor = myCell.createTextCursor

  myBreak = chr(10)               ' Unix       :-)
  myBreak = chr(13) & chr(10)     ' M$-Window$ :-(

 myCursor.gotoEnd(false)
 myCursor.goLeft(1, true)

 While myCursor.string = myBreak
  myCursor.string = ""
  myCursor.gotoEnd(false)
  myCursor.goLeft(1, true)
 Wend
End Sub

Sébastien C wrote: ↑Wed Aug 03, 2022 6:59 pm here are still write cursors that allow you to work on the text IN the cell, just like in Writer.

           
final XTextCursor textCursor = xText.createTextCursor();
textCursor.gotoEnd(false);
textCursor.goLeft((short) 1, true);
while (textCursor.getString().isBlank()) {
   textCursor.setString("");
   textCursor.goLeft((short) 1, true);
}

Bernard Marcelly wrote:
Move the write cursor
The cursor object has several methods for moving it. Some return a result:

• True if the action could be performed;
• False otherwise.

In practice, we rarely use the result of these functions and we use them as methods of type Sub.
The moving functions all have a boolean argument, which we will denote by SEL, which has the following effect:

• SEL = False: the cursor moves (like the vertical cursor visible bar when you edit text in a cell).
• SEL = True: the cursor moves by extending the selection (this is the same effect as a progressive selection of the cursor visible by dragging the mouse).

And here is a small example:

Code: Select all

Dim myDocument As Object
Dim theSheets As Object, mySheet As Object
Dim myCell As Object, myCursor As Object
myDocument = ThisComponent
theSheets = myDocument.Sheets
mySheet = theSheets.getByName("Writing")
myCell = mySheet.getCellRangeByName("C2")
myCursor = myCell.createTextCursor
' here the cursor is at the end of the text
myCursor.gotoStart(False)
' here the cursor is at the beginning of the text

Table 9-16 lists the cursor movement functions.

Code: Select all

Table 9-16 Moving the Write Cursor
 
 ╔════════════════╤════════════════════════════════════════════════════════════════════╗
 ║ METHOD         │ Effect on the Cursor                                               ║
 ╠════════════════╪════════════════════════════════════════════════════════════════════╣
 ║ goRight(n,SEL) │ Move n characters right. Returns True if the action was performed. ║
 ╟────────────────┼────────────────────────────────────────────────────────────────────╢
 ║ goLeft(n,SEL)  │ Move n characters left. Returns True if the action was performed.  ║
 ╟────────────────┼────────────────────────────────────────────────────────────────────╢
 ║ gotoStart(SEL) │ Move to beginning of cell text.                                    ║
 ╟────────────────┼────────────────────────────────────────────────────────────────────╢
 ║ gotoEnd(SEL)   │ Move to end of cell text.                                          ║
 ╚════════════════╧════════════════════════════════════════════════════════════════════╝

We reported that the write cursor can select an area. After performing an action on this area, there are two methods of the cursor to bring it back to an insertion point, located at the beginning or at the end of the area.

Code: Select all

myCursor.collapseToStart ' Start of the zone
myCursor.collapseToEnd   ' End of the zone

The cell cursor object also provides a Boolean function isCollapsed, which returns False if the cursor is expanded for a selection and True if it is pointwise.

Code: Select all

if myCursor.isCollapsed then
' here the cursor is pointwise
end if

Sébastien C wrote: ↑Fri Aug 05, 2022 7:00 pm But you have to know how my translation is undoubtedly very bad...

Sébastien C wrote: ↑Fri Aug 05, 2022 7:00 pm The code proposed by him still suggests that he makes the difference between API, Basic and Java...