LibreOffice

389 readers
1 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 1 year ago
MODERATORS
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
 

I have a csv file of orders from a business I run the web shop for, around 30 thousand entries total. I would like to FIND all entries which have a duplicate in the base: same customer, same total due amount and placed on the same day (some customers make repeating orders but over longer timeframe).

I found a help article regarding removing duplicate values, but it doesn't really apply to my situation, because I want to remove UNIQUE values.

How would I go about that?

46
 
 

[Solved] Use date format for the dates and use the xy scatter plot

I have the dates and weights for the times I was weighed at my doctor's office. I would like to plot those so that the actual slopes are visualized.

I tried just putting the numbers in two columns and plotting them with a line plot but the days between the dates are irregular, sometimes 3 or more months elapse, sometimes only a week or two, but the dates on the graph are evenly spaced.

Is there a setting that will space the dates out to account for the number of days between dates, so I can see how well my diet is working?

47
48
49
50
1
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 
 

Our (thb and me) talk "How to survive being sold to Oracle" at Chaos Communication Camp 2023 is now online in the final cut.

The first part is a bit of history on the OpenOffice org to LibreOffice fork -- the second is a selection of a lessons learned about the importance of a shared understanding between all contributors of an #opensource project, agreeing on the fundamentals while staying adaptive as the environment changes.

view more: ‹ prev next ›