Period in cell being interpreted as "0"

[devon_fritz]

Hey all,

I have a CSV file that I need to save as .ods so that I can upload it somewhere. Some cells just contain a “.” (period) without the quotes, and it is being interpreted as a decimal by Libreoffice. I try to change the cell type to “Text”, but to no avail - it still shows a 0. When I save out to .ods it becomes a 0, which is incorrect. How can I correct for this and just show a period, which is the actual content? Thanks.

Code Sample - Notice right at the end the ‘|.|’ . This is being changed to a 0 in Calc.

ROC|c49db624-6d1d-4425-9cf1-20abf9a1e5f5|/resources/master/parsed_sentences/parsed_sentences_roc//story_6429.dat|Little Billy hated going to the doctor, but he had a sore throat. His mother told him that they must go to the doctor. At the doctor, Billy was worried he'd have to get a shot. The doctor told him he had strep throat, and could take medicine. Billy left the doctor with his medicine and knew he would feel better.|The Doctor|0|Little Billy hated going to the doctor, but he had a sore throat.|amod|sore|throat|Little Billy hated going to the doctor, but he had a|sore|throat.|12|12|14
ROC|c49db624-6d1d-4425-9cf1-20abf9a1e5f5|/resources/master/parsed_sentences/parsed_sentences_roc//story_6429.dat|Little Billy hated going to the doctor, but he had a sore throat. His mother told him that they must go to the doctor. At the doctor, Billy was worried he'd have to get a shot. The doctor told him he had strep throat, and could take medicine. Billy left the doctor with his medicine and knew he would feel better.|The Doctor|3|The doctor told him he had strep throat, and could take medicine.|amod|strep|throat|The doctor told him he had|strep|throat, and could take medicine.|7|7|8
ROC|c49db624-6d1d-4425-9cf1-20abf9a1e5f5|/resources/master/parsed_sentences/parsed_sentences_roc//story_6429.dat|Little Billy hated going to the doctor, but he had a sore throat. His mother told him that they must go to the doctor. At the doctor, Billy was worried he'd have to get a shot. The doctor told him he had strep throat, and could take medicine. Billy left the doctor with his medicine and knew he would feel better.|The Doctor|4|Billy left the doctor with his medicine and knew he would feel better.|advmod|better|feel|Billy left the doctor with his medicine and knew he would feel|better|.|13|13|12

[Lupp]

Would you mind to append a few lines from your csv demonstrating the issue to your question?
(Use the ‘Code’ tool, please.)
Are there actually cells in Calc already just containing the point (full stop)? Or are you talking of content of the csv you would expect to go to a cell? In what way do you notice that “it” is interpreted as a number. Expressly: What is the “it”? A bit later another “it” becomes a 0. What was this “it” before it became 0?

[devon_fritz]

I’ve added the edit code. There are cells just containing the full stop, yes, but they should all be treated as text cells and not as a number. When I open the file in Calc, the cell with the period shows a zero, both in the cell itself as well as in the formula bar above.

[Lupp]

Editing: Please read the bug thread linked in below and in specific my two recent comments there in reply to the comment by Eike Rathke. In consequence I set the bug to RESOLVED - NOTABUG.
It was a user profile issue, at least on my system. With a new UP I could no longer verify the bug.

You surely are on V5.2.y?
After some testing it seems to me that there is is a “regression” bug introduced with V5.2.? I tested with 5.2.2 rc. (I could not do the true lot of testing.)
Please note: I also tested with LibO Calc V5.1.4(32-bit portable) and it did not show the bug.

The bad “recognition” wasn’t even suppressed by using the " as text delimiter and setting the dialogue respectively.
A workaround would be to set all the columns probably having to accept a dot as text to ‘Text’ instead of ‘Standard’ in the csv import dialogue. Preparing the cells with format code “@” doesn’t remedy in the case.
I would suggest you file a bug report to bugs@documentfoundation.org .
You may comment on this bug report: tdf#103043.

[paul1149]

In 5.2.2.2, when opening the .csv file, if I check “Detect special numbers”, the lone “.” is preserved.

[devon_fritz]

This worked for me in 5.1.4.2, thanks!