[Libreoffice-bugs] [Bug 133677] importing/inserting data from a file into the current sheet EDITING, FILEOPEN

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133677

--- Comment #3 from OldSurferDude <bugzilla at greggferry.com> ---
Created attachment 161623
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161623&action=edit
CALC file used to analyze data file

With this spread sheet I can determine the length of time a sensor is on or
off.

To get the data into the spreadsheet:
1. open up data in a text document
2. select all and copy date.
3. in the CALC document, move to cell A1
4. paste
5. change the first column type to Date(YMD)
6. OK
7. sort the five columns by location(C), sensor(D), time(B)
8. go to the first entry in seconds on(F) column
9. Select that entry and the one in secondsoff(G)
10. Copy
11. Select all the cells in (F) that have data data location 1, and sensor 2
12. paste

the pasted cells now show how many seconds the sensor was on in column (F) and
hours off in column (G)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200604/b53f2aca/attachment.htm>