How can I keep the formatting that exists in the form? Furthermore, I want to copy this information into Calc, save it as a CSV file and import the information into Greenstone.
I regret Greenstone is way above my pay grade, and my tests using MS XP may not apply to Apple. I offer, however, some results when copying from Base to Calc and CSV. You have formatted the text box to permit multiple lines. As you will have seen the lines are displayed as you require in the form but as a single line unless using a Memo Data Type with increased row height when its data source Table is opened.
The line returns should have been recorded in the Table. I copy below a couple of lines from an SQL Script dump of a test that I ran:
INSERT INTO "MemoTable" VALUES(0,'This is a test\u000d\u000aI have added a second line')
INSERT INTO "MemoTable" VALUES(4,'This is the second\u000aPart of the test\u000aNo formatting is ever required\u000a')
You will see that data for the first record was written with CR/LF as the line delimiter and the second merely with the Unix LF. My aim was to test what would be the impact of the different delimiters. Strangely it would not appear to be material.
I then copied the Table from Base into a new Calc spreadsheet using the f4
Beamer route and saved that Calc file AS .csv using a comma as the field and double quotes as the text delimiters respectively. A Hex dump of the resulting CSV file shows the two types of line delimiters do copy without change. The CSV file, however, happily opens in WordPad as shown below:
"ID","Memo"
0,"This is a test
I have added a second line"
4,"This is the second
Part of the test
No formatting is ever required
"
It does appear with MS Windows that you should be able to maintain your line breaks through into CSV and that it is not necessarily material which line delimiter you use. I wish you luck with your experiments.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB