Bug 135756

Summary: CSV file opening error of version 7
Product: LibreOffice Reporter: Kouichi Nakamura <kouichi.c.nakamura>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: 79045_79045, ming.v.hua
Priority: medium    
Version: 6.4.5.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 109236    
Attachments: A CSV file for testing.

Description Kouichi Nakamura 2020-08-14 11:34:17 UTC
Created attachment 164309 [details]
A CSV file for testing.

When I tried to open a CSV file with version 7.0.0.3, Libre Office repeatedly crashed, and I could not open the file.

While the same CSV file can be readily opened with version 6.4.6.2.

Excel can open the same file successfully.


Unicode (UTF-8)
Separated by Comma
Format quoted field as text
Comment 1 Ming Hua 2020-08-14 14:11:43 UTC
Can not reproduce with 7.0.0 on Windows 10:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU 线程: 2; 操作系统: Windows 10.0 Build 18363; 界面渲染: Skia/点阵; VCL: win
Locale: zh-CN (zh_CN); 界面: zh-CN
Calc: threaded

Attached example file opens and displays fine for me (with the specified UTF-8 encoding, comma as separater, and formatting quoted field as text).

@Kouichi Nakamura, maybe it's related to user profile, have you tried safe mode with version 7.0?
Comment 2 V Stuart Foote 2020-08-14 14:21:52 UTC
Can not confirm.
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Clean opening with or without making changes to default configuration Text Import... dialog, e.g. character set (UTF-8, system, or Windows 1252) or the separator options.

Perhaps a LO Help -> Safe mode restart
Comment 3 Kouichi Nakamura 2020-08-14 14:47:21 UTC
Thanks for testing.
I have downgraded LibreOffice to 6.4.6.2, but will try 7 again.
Comment 4 Roman Kuznetsov 2020-08-14 20:19:05 UTC
Try disable Skia before open your CSV (Tools-Options-LibreOffice-View dialog)

I'll set it as NEEDINFO
Comment 5 Kouichi Nakamura 2020-08-14 22:26:18 UTC
Safe mode worked.
There is a possibilty that it had something to do with Tab view. But once I cleaned the profile, it's OK now.
Thank you.