Ask Your Question

What Again??? Copy down a simple formula to provide a cumulative value of a list of numbers than the formula stops working because a decimal is introduced into the list of numbers

asked 2019-03-06 19:19:31 +0200

Peter Connacher gravatar image

I have pics of problem and can send them on whatsapp

edit retag flag offensive close merge delete


I Cant believe this happens in a new spreadsheet.I started afresh because I thought the old one was corrupted

Peter Connacher gravatar imagePeter Connacher ( 2019-03-06 19:25:19 +0200 )edit

I'm sorry, but could you please describe to others, what is that thing that made you to express your emotions here, instead of putting a clear and neutral description of the problem, with your end goal, formulas, and error messages, along with sample spreadsheets, screenshots, application version information, used OS, etc.?

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-06 19:48:28 +0200 )edit

I thought there'd be a quick solution to such an obvious defect. I think Ill try Apache tomorrow. I have wasted enough time on Libre

Peter Connacher gravatar imagePeter Connacher ( 2019-03-06 20:31:50 +0200 )edit

Heh :-) You come to a user-to-user help site; ask some other users for help - but only give emotions, not data; and when you are asked to tell more about the problem itself, taking into account that the other person doesn't stand behind your shoulder to see your screen, and probably what seems obvious to you is not that obvious to others, - you get upset. Sigh :-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-06 21:24:26 +0200 )edit

And what have we here?

  • Emotionally loaded posting with little material content.
  • Unsubstantiated claims
  • Request for detail gets evasive response.
  • Attempting to offend (stirring emotion by implying that "your stuff is inferior").

Is this not the definition of trolling?

@Peter Connacher You could of course prove me wrong. Nobody would be happier than me if you do.

And no, assuming that I were holding a WhatsApp account, I would not connect to a random netizen (yourself) using that. The security and privacy concerns surrounding FB activity in general and WhatsApp in particular makes even your suggestion to use it look suspicious. This place allows image upload, you may have noticed.

keme gravatar imagekeme ( 2020-07-16 00:26:38 +0200 )edit


'what is that thing that made you to express your emotions here?'

'his emotions'? consider him shocked by a spreadsheet not working as expected, or different to other sheets, his emotions are real and valid, for him, not for you, but try to empathize with an irritated user, his situation and experience is different than yours,

@peter: the people here are often a bit sensitive about criticism of 'their product', they are - rightly so - quite proud of the successes so far, and prefer to work constructively rather than 'just complaining',

on the other hand, they themselves fall into the same trap and 'hold against' instead of 'picking up' the user where he is :-(

and don't understand that criticism is not a condemnation but help for improvement,

you probably won't have much luck with Apache, many bugs of both programs are 'inherited from OOo', and therefore present in ...(more)

newbie-02 gravatar imagenewbie-02 ( 2020-07-19 02:29:21 +0200 )edit

for the matter itself: i assume the OP tried something similar to 'downfilling' an area with integers and got values like 6.00000000000001 inbetween, and i remember @mike shortly fixed such an issue, see tdf #129606,

@peter: some more details would make it easier to help ... or look around yourself 'here', in 'bugs' and on the web for 'floating point problems', 'floating point rounding errors', one try for explanation is there: fp-error-wiki

newbie-02 gravatar imagenewbie-02 ( 2020-07-19 03:05:35 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-07-15 23:46:52 +0200

LeroyG gravatar image

¿Comma or dot as decimal separator?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-06 19:19:31 +0200

Seen: 65 times

Last updated: Jul 15