Ask Your Question

Vigilance's profile - activity

2021-03-04 01:31:06 +0200 marked best answer How to do a Fast Fourier transform in Calc

I've seen older posts from 2010 saying that adding this was on the todo list for the devs, I was wondering if it was added yet, and if so how do I do it?

2021-03-04 01:29:07 +0200 received badge  Notable Question (source)
2021-03-04 01:29:07 +0200 received badge  Popular Question (source)
2021-03-04 01:28:58 +0200 marked best answer Drag cells down but auto fill across

I would like to have my spread sheet increment across (So using the letters) instead of down. To clarify, I need it such that, as I drag down to have calc auto fill in cells, I need it to increment across the cells in the formula.

So if I have a cell at A1 and it has =2*B2 I want to drag the cell down all the way to A26, and have each cell say =2*C2 =2*D2 =2*E2

I've tried putting a $ in front of the number when I drag the column down, but that doesn't do it. Being able to have it auto increment across while I drag down wouldnot only save me a LOT of time for my current project, but would also help to make my project readable and user friendly.

2021-03-04 01:28:58 +0200 received badge  Scholar (source)
2021-03-03 19:33:33 +0200 commented answer Drag cells down but auto fill across

Oh wow, thank you for that really indepth edit! I really appreciate all the extra info!

2021-03-03 08:29:56 +0200 received badge  Notable Question (source)
2021-03-02 18:23:00 +0200 commented answer Drag cells down but auto fill across

Understood. I guess I'm a bit surprised there is no clean way to do this. I'm not sure if excel has what I want or not,

2021-03-02 18:22:19 +0200 commented answer Drag cells down but auto fill across

Understood. I guess I'm a bit surprised there is no clean way to do this. I'm not sure if excel has what I want or not,

2021-03-02 09:37:45 +0200 received badge  Popular Question (source)
2021-03-02 03:14:04 +0200 commented question Drag cells down but auto fill across

Oh my gosh, yeah I'm so sorry. I meant to have it say t*B2, but it looks like the site ate the asterisk and used it for

2021-03-02 01:49:51 +0200 asked a question Drag cells down but auto fill across

Drag cells down but auto fill across I would like to have my spread sheet increment across (So using the letters) instea

2020-10-16 00:20:37 +0200 marked best answer How can I reduce the number of cell in a sheet by taking the average of a set number of cells

I have a spreadsheet with about half a million rows in it. For the sake of having the data t calculate Min, max, and average, this is helpful. However this is really hard to read. I want to know how I can take the average of like, a thousand cells at a time and output that to another page. Here is a screenshot of my data.

In the screenshot data is logged multiple times a second, I'd like to reduce that to maybe, 50 times a second. Any help is greatly appreciated!

(edit: activated screenshot)

2020-10-16 00:19:21 +0200 received badge  Famous Question (source)
2020-03-22 17:48:58 +0200 edited question Change data label to be date instead of sequential numbering

Change data label to be date instead of sequential numbering I'm trying to make a special spreadsheet, where I need data

2020-03-22 17:48:58 +0200 received badge  Editor (source)
2020-03-22 17:48:16 +0200 edited question Change data label to be date instead of sequential numbering

Change data label to be date instead of sequential numbering I'm trying to make a special spreadsheet, where I need data

2018-08-07 13:19:27 +0200 received badge  Famous Question (source)
2017-10-20 14:55:07 +0200 received badge  Notable Question (source)
2017-10-01 19:52:38 +0200 received badge  Enthusiast
2017-09-30 13:12:26 +0200 received badge  Notable Question (source)
2017-09-30 09:38:43 +0200 received badge  Popular Question (source)
2017-09-29 18:40:31 +0200 asked a question How to do a Fast Fourier transform in Calc

How to do a Fast Fourier transform in Calc I've seen older posts from 2010 saying that adding this was on the todo list

2017-09-29 17:20:13 +0200 commented answer How can I reduce the number of cell in a sheet by taking the average of a set number of cells

I know it's been awhile since I commented, but I was hoping you could help me one last time. Here is a link to my calc s

2017-09-23 04:16:31 +0200 received badge  Popular Question (source)
2017-09-22 21:52:14 +0200 commented answer How can I reduce the number of cell in a sheet by taking the average of a set number of cells

Sorry to bother you again. I really appreciate you answering my question, but I'm trying to figure out exactly how you d

2017-09-22 19:01:49 +0200 answered a question How do I connect to printer?

This sounds more like a Linux question than a libre office question. I'd recommend checking the resources available for

2017-09-22 18:46:56 +0200 asked a question How can I reduce the number of cell in a sheet by taking the average of a set number of cells

How can I reduce the number of cell in a sheet by taking the average of a set number of cells I have a spreadsheet with