Ask Your Question
0

how to fix spreadsheet

asked 2021-02-17 12:32:31 +0200

DannyR gravatar image

updated 2021-02-17 22:18:20 +0200

LeroyG gravatar image

some of the commas have disappeared

Edit1: The comma that was inserted as a decimal point (for example 123,87 is now showing as 12387

Edit2: Hi Leroy, the operating system is Windows 10 and the LibreOffice version is 7.0.

ps. I do not see the paper clip to attach the file. Please advise where I can find it to attach the file

Edit3: Herewith the file with two spreadsheets - one showing the old correct version and the later corrupter version. Please see for example cell B8 in the old correct version and Cell B8 in the later version. The comma that was serving as decimal has disappeared. Similarly for Cell B9. C:\fakepath\old correct version and new corrupted file.ods

Any suggestions how to get back the missing commas in the later version would be most appreciated.

Edit4: I have used , as the decimal point. If I use . as a decimal point, it is not recognised as a number. The intention of the formula is to multiply cell B5 by zero point zero 8. If you look at another example where there is no formula for example cell C9, the value of 2289,18 has changed to 228 918,00

Edited by LeroyG to join data.

edit retag flag offensive close merge delete

Comments

1

More info needed. There is no way to guess what you want.

Przemo gravatar imagePrzemo ( 2021-02-17 13:11:37 +0200 )edit
1

Please test with a clean profile Menu/Help/Restart in Safe Mode

m.a.riosv gravatar imagem.a.riosv ( 2021-02-17 14:13:38 +0200 )edit

Comma as thousand separator?

LeroyG gravatar imageLeroyG ( 2021-02-17 14:32:06 +0200 )edit

Edit your question, and use the paper clip to attach a sample file.

Also share operating system and LibreOffice version (see menu Help - About LibreOffice).

LeroyG gravatar imageLeroyG ( 2021-02-17 14:45:28 +0200 )edit

The paper clip appears between the image and the numbered list icons; but only when you edit your question.

LeroyG gravatar imageLeroyG ( 2021-02-17 15:51:42 +0200 )edit

I see nothing unusual in your "corrupted" spreadsheet: 12878 has been entered as an integer (no decimal digits nor decimal "point"). If I enter a decimal "point" (dot or comma depending on locale), I get a number with a fractional part.

I question your formula in B8: =B5*8+(B5*8*15). It will inevitably compute a large number. Have you forgotten a % operator? Also, why parentheses around (B5*8*15)? Did you intend to divide by some number?

ajlittoz gravatar imageajlittoz ( 2021-02-17 16:00:56 +0200 )edit

Hi Ajlittoz, if you compare the original worksheet, the formula in cell B8 was input as =B5*0,08+(B5*0,08*0,15). I am not sure why all the decimal points have recently disappeared from the spreadsheet and trying to find out if the spreadsheet can be corrected to have the original decimals re-instated somehow

Edited by LeroyG to add Ctrl+K (AKA: preformated text) to the formula (otherwise asterisk are meant for italics).

DannyR gravatar imageDannyR ( 2021-02-17 16:45:35 +0200 )edit

=B5*0.08, or =B5*0,08?

Sorry, had typed 05 instead of 08.

LeroyG gravatar imageLeroyG ( 2021-02-17 16:53:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2021-02-17 15:41:10 +0200

DannyR gravatar image

Hi All, Herewith the file with two spreadsheets - one showing the old correct version and the later corrupter version. Please see for example cell B8 in the old correct version and Cell B8 in the later version. The comma that was serving as decimal has disappeared. Similarly for Cell B9.C:\fakepath\old correct version and new corrupted file.ods

Any suggestions how to get back the missing commas in the later version would be most appreciated.

edit flag offensive delete link more

Comments

Do not answer your own question unless it is a real answer. Modify or comment the original one.

gabix gravatar imagegabix ( 2021-02-17 15:47:22 +0200 )edit

@DannyR, Thanks for the new information. As it is not an answer to your question, repost it as a comment. To do that, hover on "more" (just above these comments), and press "repost as a question comment". Thanks again.

LeroyG gravatar imageLeroyG ( 2021-02-17 15:48:30 +0200 )edit

It seem to be a corruption in the user profile. I see both versions well.

Take a look at the guidelines at https://wiki.documentfoundation.org/U....

LeroyG gravatar imageLeroyG ( 2021-02-17 15:53:18 +0200 )edit

Sorry Leroy, I could not attach the explanatory file to the comments. therefore pasted it in the answer section

DannyR gravatar imageDannyR ( 2021-02-17 15:54:41 +0200 )edit

You cannot attach files to comments. You need to edit your question, and there use the paper clip.

And tell us what do you do between correct and corrupted versions.

LeroyG gravatar imageLeroyG ( 2021-02-17 22:12:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-02-17 12:32:31 +0200

Seen: 59 times

Last updated: Feb 17