Apparently, some people love spreadsheets. Is that really true?
Why am I asking?
Well, my wife is currently undergoing chemotherapy, so her blood values have to be checked weekly. I thought I’d create a spreadsheet for our own use. I’ll skip the part about creating the framework, choosing different fonts, adding borders and background colours.
As soon as a value is outside the norm, it should appear in bold. However, some values are integers and some have one or two decimal places. To keep things simple, you could format the entire data range with two decimal places, but I don’t like that approach. I to do it either properly or not at all. So I formatted 51 rows with the respective number format.
Up to this point, it was just annoying work but easy. Now, however, I want to create a line chart showing the weekly results for the most important values. After doing some research, I thought I had figured out how to set it up. But there is one small error driving me crazy. The test chart displays its own dates. This is despite me having a timeline in row 1 that advances seven days in each column.
But this stupid LO Calc doesn’t care whether I entered 10/15/25, 10/22/25, 10/29/25, etc. In the chart, it simply turns it into a 5-day cycle. I’ve already spent nearly two hours searching and reading about why this happens and how I can fix it, but no luck, I just can’t find the solution that surely exists.
Now back to the original question. Really? Are there people who love spreadsheets? I hate them. Yes, they are rich in features, there is virtually nothing you can’t do with them, but why do they have to be so cumbersome and so unintuitive?
Have you asked on the LO forum yet? If it turns out to be a bug, check the bug list to see if there is already a matching entry. And if it turns out to be a new bug, it would be useful to submit a bug report.
I don’t think it’s a bug. I now have a vague idea why LO handles it this way, but I’ve put it on hold for the time being because I have more important things to take care of at the moment, and I don’t have time to indulge my personal whims. I’ll probably ask on the LO forum in the next few days how it can be solved.
@JeanDupleix
You don’t have to feel sorry. Thank you very much for your good wishes!
EDIT:
Of course, I’m a complete novice when it comes to Calc. So far, I’ve only created very rudimentary tables.
In any case, I didn’t post with the intention of getting specific help with this. I just wanted to vent my frustration again
I realized relatively quickly that a simple line graph wouldn’t work, So I switched to a scatter plot. The solution is more complex. It´s how LO formats the distance between the vertical grid lines that aren’t (and shall not) be visible in the graph but are still there.
But thank you very much for trying to help anyway.
Sorry to hear about your wife. Western medicine is not for healing just so you know. I felt I had to leave you this message for you and your wife. (And whoever else reads this) If you want to try to actually heal your wife, you should take her to a real Chinese medicine doctor. (Not modern acupuncturists) Cancer is usually caused by an unbalance in the body between multiple organs which could include kidney weakness which can be rebalanced and strengthened through tcm. Chinese medicine has been reversing these things for 7000 years. Modern medicine separate these connections our organs because it is complex, and they want doctors just to sell drugs and expensive procedures, not heal people or teach people to heal themselves.
Good luck to you and your wife, I hope she gets better.
