Bug 149881 - Spreadsheet bug tabs inside cell is not saved and are replaced by spaces
Summary: Spreadsheet bug tabs inside cell is not saved and are replaced by spaces
Status: RESOLVED DUPLICATE of bug 125248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: x86 (IA32) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-07-06 10:50 UTC by hans
Modified: 2024-08-13 16:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
csv file with preserved tabs inside cell (1.68 KB, text/csv)
2022-07-06 10:54 UTC, hans
Details

Note You need to log in before you can comment on or make changes to this bug.
Description hans 2022-07-06 10:50:46 UTC
Description:
In Libre Office version 7.3.2.2 tabs inside cell are not supported and not saved.
In case inserting text with tabs inside one cell. After saving in .odf file format the tabs are changed to space. 

Steps to Reproduce:
1. .csv file support tabs inside quotes
2. Other editor like Open Office handle tabs inside cell correct
3. In Libre Office all tabs are replaced by spaces when importing correct .csv data. 

Actual Results:
Tabs are replaced by space when storing in ods. 
Exporting to .csv file the result is not the same as original .csv (tabs are prelaced by spaces)

Expected Results:
Libre Office should support tabs in cell and export correct to .csv including correct storing the tabs in the .ods file format.


Reproducible: Always


User Profile Reset: No



Additional Info:
Correct handling of tabs inside a cell.
Comment 1 hans 2022-07-06 10:54:40 UTC
Created attachment 181136 [details]
csv file with preserved tabs inside cell

csv file with preserved tabs inside cell
Libre Office does not support tabs inside a cell. Tabs are replaced by spaces
Comment 2 m_a_riosv 2022-07-07 09:26:18 UTC

*** This bug has been marked as a duplicate of bug 125248 ***
Comment 3 Little Girl 2024-08-13 01:18:26 UTC
This bug has not yet been resolved. Please see the most recent comment in bug number 125248 on the https://bugs.documentfoundation.org/show_bug.cgi?id=125248 page.

In my case, tabs are completely stripped from the cell and this has been going on for several versions now. Here's the information from the Help -> About LibreOffice menu:

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 6; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.5
Calc: threaded
Comment 4 ady 2024-08-13 16:01:37 UTC

*** This bug has been marked as a duplicate of bug 125248 ***