[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #28 from Robert Großkopf --- (In reply to Silvain Dupertuis from comment #27) > > This is what I tested : > the example calc document has fields with line-breaks > I created a fresh database connected at this calc document as it's database > source and examined the table corresponding to the test sheet > As the line-fields were lost in this database, I did not even try to copy > the data into another database. The linefeed weren't shown in the database, which is linked to Calc. The last step (copy to a new HSQLDB or Firebird database with fields, which could show the linefeed) is missed here. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #27 from Silvain Dupertuis --- (In reply to Robert Großkopf from comment #25) > (In reply to Silvain Dupertuis from comment #22) > > (In reply to Robert Großkopf from comment #19) > > > And a second very simple solution: > > > Set the Calc file as datasource of a new *.odb-file. > > > Copy the content from the Calc-database-file to your database. > > > Linebreaks will be imported to the internal database. > > > > I tested this and it does not work. > > Line-breaks are lost if I create a fresh database and connect to the example > > calc file as datasource > > This isn't what I described: > 1. You need a Calc document with fields, which may have also linebreaks. > 2. You need a first database, which only connects to Calc. > 3. You need a second database, to which you will copy the content with the > linebreaks. The fields for the table must be datatype Memo (LONGVARCHAR in > HSQLDB, BLOB in Firebird). The linebreaks will be shown in the second > database. This is what I tested : the example calc document has fields with line-breaks I created a fresh database connected at this calc document as it's database source and examined the table corresponding to the test sheet As the line-fields were lost in this database, I did not even try to copy the data into another database. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #26 from Timur --- (In reply to Timur from comment #23) > I duplicated this under the assumption that culprit is source Calc and not > destination Base. Please confirm by testing version up to 5.4.7 (In reply to Silvain Dupertuis from comment #24) > Sorry I only have the latest versions of LibreOffice In Windows, there's only one regular installation and master version can be installed separately, keeping regular installation. In order to test older version, one can use http://tdf.io/siguiexe to download and "install" any version, which is really not installed but extracted and run via shortcut. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #25 from Robert Großkopf --- (In reply to Silvain Dupertuis from comment #22) > (In reply to Robert Großkopf from comment #19) > > And a second very simple solution: > > Set the Calc file as datasource of a new *.odb-file. > > Copy the content from the Calc-database-file to your database. > > Linebreaks will be imported to the internal database. > > I tested this and it does not work. > Line-breaks are lost if I create a fresh database and connect to the example > calc file as datasource This isn't what I described: 1. You need a Calc document with fields, which may have also linebreaks. 2. You need a first database, which only connects to Calc. 3. You need a second database, to which you will copy the content with the linebreaks. The fields for the table must be datatype Memo (LONGVARCHAR in HSQLDB, BLOB in Firebird). The linebreaks will be shown in the second database. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #24 from Silvain Dupertuis --- Sorry I only have the latest versions of LibreOffice What I tested : - Having a calc file with multiline cells - Creating a fresh database with the option «connect to an existing database» - Chose the calc file as this existing database. - The sheets appear as tables, but the line-breaks are lost. What I would expect is having linebreaks preserved in both directions when exchanging data between calc and base. One thing I am doing on a regular bases is updating a mysql database for a web-based application from my local Base file. I use a Calc file, connect it with my registered database, copy the desired tables and/or querys, then copy the whole calc file into the mysql database. It works fine and fast, except for line-breaks in some multiline fields... Sorry if the terminology is not exact, I speak French and use a French interface in my installation. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #23 from Timur --- I duplicated this under the assumption that culprit is source Calc and not destination Base. Please confirm by testing version up to 5.4.7 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #22 from Silvain Dupertuis --- (In reply to Robert Großkopf from comment #19) > And a second very simple solution: > Set the Calc file as datasource of a new *.odb-file. > Copy the content from the Calc-database-file to your database. > Linebreaks will be imported to the internal database. I tested this and it does not work. Line-breaks are lost if I create a fresh database and connect to the example calc file as datasource -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Timur changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #21 from Timur --- This seems like a duplicate of bug 119928. Please verify with testing LO 5.4.7 which didn't have it. *** This bug has been marked as a duplicate of bug 119928 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Timur changed: What|Removed |Added CC||silvain-dupertuis@bluewin.c ||h --- Comment #20 from Timur --- *** Bug 143005 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Patch changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||2561 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #19 from Robert Großkopf --- And a second very simple solution: Set the Calc file as datasource of a new *.odb-file. Copy the content from the Calc-database-file to your database. Linebreaks will be imported to the internal database. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #18 from Robert Großkopf --- Created attachment 163814 --> https://bugs.documentfoundation.org/attachment.cgi?id=163814=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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Robert Großkopf changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #17 from Robert Großkopf --- With the attached database and Calc-file I could reproduce the behavior. Tested with OpenSUSE 15.1 64bit rpm Linux and different LO-Versions (LO 6.4.4.2, also LO 6.1.5.2 ...) I don't know why it worked here before. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #16 from rac...@megabit.net --- (In reply to Robert Großkopf from comment #14) > > This bug is unconfirmed from any other person. So nobody, who could resolve > bugs, has a chance to find the buggy behavior. So the bug will still be there in a few years because only a few users use LibreOffice Base? Please look at my video so you can confirm this behaviour. > Firebird is set back to "experimental", because there are too many things, > which will work better with internal HSQLDB. Please test the behavior with > internal HSQLDB and upload an example as attachment here. This will be the > best possibility to see the problem for other people. HSQLDB has the same problem. Example is attached... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #15 from rac...@megabit.net --- Created attachment 161505 --> https://bugs.documentfoundation.org/attachment.cgi?id=161505=edit simple table and database file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #14 from Robert Großkopf --- (In reply to racoon from comment #13) > Will LibreOffice Base be further developed? > > Version 6.4.4.2 and 7.0.0.0-alpha1 still have the bug... This bug is unconfirmed from any other person. So nobody, who could resolve bugs, has a chance to find the buggy behavior. Firebird is set back to "experimental", because there are too many things, which will work better with internal HSQLDB. Please test the behavior with internal HSQLDB and upload an example as attachment here. This will be the best possibility to see the problem for other people. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #13 from rac...@megabit.net --- Will LibreOffice Base be further developed? Version 6.4.4.2 and 7.0.0.0-alpha1 still have the bug... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 rac...@megabit.net changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #12 from rac...@megabit.net --- Windows: Version: 6.4.3.2 (x64) Build-ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: GL; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: CL Linux: Version: 6.4.3.2 Build ID: 1:6.4.3-0ubuntu0.20.04.1 CPU threads: 2; BS: Linux 5.4; UI-Render: Standard; VCL: kf5; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded I reset the profile, but the line feeds imported from Calc are still dropped - both Windows and Linux. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #11 from Xisco Faulí --- (In reply to racoon from comment #10) > Still exists in 6.4.3... > > The problem will probably not solve itself. Could you please paste the info from Help - about LibreOffice ? OTOH, to be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 rac...@megabit.net changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #10 from rac...@megabit.net --- Still exists in 6.4.3... The problem will probably not solve itself. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org --- Comment #9 from Xisco Faulí --- Hello, A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #8 from rac...@megabit.net --- This is very strange. For me it does not work with Windows 10 (version 1903) and Kubuntu (version 19.10,). I have now made a sample video. https://youtu.be/Ev4T3ef_jEc In the meantime, I have found a workaround by inserting the Calc table as HTML in Writer and then transfering it with copy and paste to Base. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #7 from Alex Thurgood --- (In reply to Alex Thurgood from comment #6) > Works for me too with : > > > In the table definition, provide a CLOB field. > Copy the multiline data from a Calc sheet. > Firebird was used as the db engine. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #6 from Alex Thurgood --- Works for me too with : Version: 6.3.1.2 Build ID: b79626edf0065ac373bd1df5c28bd630b4424273 Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded In the table definition, provide a CLOB field. Copy the multiline data from a Calc sheet. Save the record. In the table edit mode, the multiline data is stored with line feeds included. Create a form based on the table, e.g. using the wizard. Save the form, then re-open for editing. Change the default properties of the Text control by choosing "Text type : Multiline" - save the changes Re-open form in data entry mode - form displays multiline feed text. WFM -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #5 from rac...@megabit.net --- (In reply to Robert Großkopf from comment #4) > So it seems to be a special Windows-bug ... Meanwhile I have also tested it on my Kubuntu 19.10 (amd64) Linux system and have the same issue. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Robert Großkopf changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #4 from Robert Großkopf --- (In reply to racoon from comment #3) > I have now used a CLOB [BLOB]. But linefeeds are still removed when > importing or appending data by using copy rows from a Calc table. > Because I'm using Windows 10, there may seem to be a problem with Unix (LF) > and Windows (CR/LF)? Have tested the same now: CLOB and LO 6.3.2.2, but OpenSUSE 15 Linux 64bit rpm. I copy content of Calc to a Base form. Linefeeds appear as expected. There is no difference when setting the properties of the formcontrol to CR+LF(Windows) or LF(Unix). Both will work here. So it seems to be a special Windows-bug ... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #3 from rac...@megabit.net --- I have now used a CLOB [BLOB]. But linefeeds are still removed when importing or appending data by using copy rows from a Calc table. Because I'm using Windows 10, there may seem to be a problem with Unix (LF) and Windows (CR/LF)? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 --- Comment #2 from rac...@megabit.net --- I use varchar[8000] in Firebird. I know it shows no LF directly in the table view, but in a text box in a form object. Please notice that it works, when I import from another Base table. I'm sorry I did not mention it. I've been using the database for several years, originally in HSQLDB format, then converted to Fireboard. LF also converted. ;) So I should use BLOB instead? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text
https://bugs.documentfoundation.org/show_bug.cgi?id=128513 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Robert Großkopf --- I have tested it - and doesn't found any problem. Do you use the datatype Memo (LONGVARCHAR in HSQLDB, BLOB in Firebird)? Only this datatype will show returns. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs