LibreOffice Calc used all the memory with CPU overloaded when import a txt file into Calc

[Chia-Hao Hsu]

The situation found when I try to covert a txt file into Calc file by libreoffice. The preview looks all fine, all the tabs and texts were well arranged in the preview. However, when the button "ok" was pressed, libreoffice use all the memory and CPU, even the txt file only has 4.7 kB with only 74 rows and 7 columns. It use all memory (10 GB) in the conversion.

ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: libreoffice-core 1:6.0.7-0ubuntu0.18.04.10
ProcVersionSignature: Ubuntu 4.15.0-72.81-generic 4.15.18
Uname: Linux 4.15.0-72-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.20.9-0ubuntu7.9
Architecture: amd64
CurrentDesktop: GNOME
Date: Mon Jan 6 13:41:32 2020
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2018-04-29 (616 days ago)
InstallationMedia: Ubuntu 16.04.4 LTS "Xenial Xerus" - Release amd64 (20180228)
SourcePackage: libreoffice
UpgradeStatus: Upgraded to bionic on 2019-12-20 (16 days ago)

[Chia-Hao Hsu (hsusonic)]

Additional Notes:

The bug may related to the bug report:
https://bugs.documentfoundation.org/show_bug.cgi?id=120796

Everything goes fine after it was changed from .txt to .csv.