Ask Your Question

Multiline text fields in database table

asked 2019-01-18 18:22:34 +0100

Pavel_47 gravatar image

Hello, Does LibreOffice base allow putting multiple lines in cells. If YES, which properties such column must have. Thanks.

edit retag flag offensive close merge delete


Which OS and LO-Version do you use? Which Database do you use, HSQLDB or Firebird or others?

ebot gravatar imageebot ( 2019-01-18 19:11:27 +0100 )edit

Windows-10, HSQLDB

Pavel_47 gravatar imagePavel_47 ( 2019-01-18 19:14:31 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-01-18 22:18:39 +0100

Ratslinger gravatar image


There are multiple places in which to view data. Two of these are a table view and a form. For multiple line VIEW, each is different. Please see my answer in this post -> How can I wrap text at table database?. Be sure to also look at the comments under the answer as it corrects an error in the answer.

edit flag offensive delete link more


Thanks. Works for Form. Concerning Table, I didn't find Memo [TEXT] option. One more question: is it possible to format several lines as bulleted list, e.g.

  • aaaa
  • bbbb
  • cccc
  • dddd

link text

Pavel_47 gravatar imagePavel_47 ( 2019-01-31 12:00:55 +0100 )edit

Sorry - Memo[Text] is from MySQL.

Don't know of method for bullet items.

Ratslinger gravatar imageRatslinger ( 2019-01-31 18:38:30 +0100 )edit
Login/Signup to Answer

Question Tools



Asked: 2019-01-18 18:22:34 +0100

Seen: 461 times

Last updated: Jan 18 '19