[Solved] Viewing data in input line

[foxfour2002]

Hi
I have spreadsheets with lengthy strings of data in many cells. I prefer to not use text wrapping. To view the data in the input line I have to scroll. Is there any way to preview the entire string as you can in Excel?
Thanks

[acknak]

Greetings and welcome to the community forum!

I don't know any way to manage this in Apache OO. I believe LibreOffice (an independent branch off of AOO) has implemented a multi-line input area; you may want to give that a try.

Personally, if I'm working with long text strings, I avoid Calc. There are too many problems. As long as you don't need to do any calculations, a table in OO Writer works better.

[foxfour2002]

Many thanks for that.
I'm really using them as databases updating from downloaded Excel files. Anyway if you don't ask...

[MrProgrammer]

Hi, and welcome to the forum.

Is there any way to preview the entire string as you can in Excel?

You should be able to view all of the data in the cell if you "open" it by pressing F2 unless the data will fill the entire screen. Close it with ESC. I don't use Excel.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[foxfour2002]

Hi
that's useful to know and something I shall use in the future.
Going back to my original question, it may just be that it is something that is not possible in Calc. No big deal.
Regards