[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128513

--- Comment #18 from Robert Großkopf <robert at familiegrosskopf.de> ---
Created attachment 163814
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163814&action=edit
Solution import from Calc with linebreak by macro

I have tried it again for another user. Then In remembered I had written a
macro for this. Is all in German, but it works.

See the attached *.zip-folder. There is a database and a Calc file.
The Calc file must have this name for the macro - or must be renamed in the
macro. The Calc file must be in the same folder as the Base file.

Activate macros for the database.
Open the form.
Press the button.
Content of the textboxes will be imported with linebreaks.

The macro is set to read all data except data for the field "ID".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200731/cb72698e/attachment.htm>