Wednesday

LibreOffice Writer: How to convert text to table

Highlight the comma separated text
LibreOffice Writer Menu > Table > Convert > Text to Table
Select the radio button: Other: type comma (,)
Tick the box Heading, tick the box “Repeat heading”, set “The first” to 1 row only
Click the button OK

From text, example for you to try

Location, Price, Rooms, Bathrooms, Car Parks,Property Type, Size
Kuala Lumpur City,RM 1250000, 3, 3, 2,Serviced Residence,1335 sq. ft.
Damansara,RM 6800000, 6, 7, 4,Bungalow,6900 sq. ft.
Dutamas,RM 1030000, 3, 4, 2,Condominium,1875 sq. ft.
Bukit Jalil,RM 900000, 5, 3, 2,Condominium,1513 sq. ft.
Taman Tun Dr Ismail,RM 5350000, 6, 5, 4,Bungalow,7200 sq. ft.

To table

+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Location            | Price      | Rooms | Bathrooms | Car Parks | Property Type      | Size         |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Kuala Lumpur City   | RM 1250000 | 3     | 3         | 2         | Serviced Residence | 1335 sq. ft. |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Damansara           | RM 6800000 | 6     | 7         | 4         | Bungalow           | 6900 sq. ft. |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Dutamas             | RM 1030000 | 3     | 4         | 2         | Condominium        | 1875 sq. ft. |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Bukit Jalil         | RM 900000  | 5     | 3         | 2         | Condominium        | 1513 sq. ft. |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+
| Taman Tun Dr Ismail | RM 5350000 | 6     | 5         | 4         | Bungalow           | 7200 sq. ft. |
+---------------------+------------+-------+-----------+-----------+--------------------+--------------+

No comments:

Fire survival tips

1 Stop, drop, cover and roll  If your clothes catch fire stop, drop, cover your face with your hands and roll to smother the flames. 2 Get d...