Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 12 Dec 2018 16:03:53 +0100enter a number series in spreadsheethttps://ask.libreoffice.org/en/question/176014/enter-a-number-series-in-spreadsheet/ I need to fill a column from 1 to end (140) with sereal numbers I cannot find the functionjtwrightWed, 12 Dec 2018 16:03:53 +0100https://ask.libreoffice.org/en/question/176014/How to print ole object on all series correspondence list pageshttps://ask.libreoffice.org/en/question/168168/how-to-print-ole-object-on-all-series-correspondence-list-pages/I am trying to print absence list using the series corespondence but ole object (table with days in month with free days market on it automaticly) is printing only on the last page. In the serial correspondence wizard i see all i need, but when i print it or trying to correct some page, the ole table is missing.
Tell me please how can i print it on all pages.
Document i am trying to print
[Lista_obecnosci.odt](/upfiles/15391115523696598.odt)
Worker list in Calc
[Lista_Pracownikow.ods](/upfiles/15391116579576033.ods)MariuszMon, 08 Oct 2018 23:23:57 +0200https://ask.libreoffice.org/en/question/168168/Adding Blank Rows for Sequential Missing Numbershttps://ask.libreoffice.org/en/question/167356/adding-blank-rows-for-sequential-missing-numbers/ I have a large database import I am working with that is several tables of data that have to be combined into one master spreadsheet(csv) for import.
There is a primary key with both tables but both tables are missing numbers say the order is 11-83529 but neither table is completely sequential.
The only solution I have found the works on that column is to fill - series choosing linear and using the line numbers.
However I need to act that way on the whole , adding a row each time it finds a missing number and adding the number to the first column? Does anyone know how to do this?
chrchcolTue, 02 Oct 2018 04:37:42 +0200https://ask.libreoffice.org/en/question/167356/serie envelope printing, back to vertical after 1st envelopehttps://ask.libreoffice.org/en/question/133767/serie-envelope-printing-back-to-vertical-after-1st-envelope/ I am using .odb database as source and Insert->Envelope Wizard
my table has around 90 contacts and after I set it all up, send to print a series of 2/3/whatever>1 and then the first envelope goes out fine, but the rest of them get printed VERTICALLY.
I saw some answer in this site saying to add manual line breaks to set "horizontal" orientation but it didn't work, I've also tried setting horizontal as default in the printer but it didn't work.
Any other way I can get the series printing working for envelopes?gattyttoWed, 04 Oct 2017 16:20:39 +0200https://ask.libreoffice.org/en/question/133767/Impress: Animating individual series in a charthttps://ask.libreoffice.org/en/question/100064/impress-animating-individual-series-in-a-chart/Dear all,
Is it possible to animate individual series in a line chart? I have several curves/lines in a chart. I want them to appear one by one in a sequence. Just for the information, such a feature is available in both keynote and powerpoint.
Thanks,
HNGhngnetWed, 14 Jun 2017 18:03:00 +0200https://ask.libreoffice.org/en/question/100064/Formatting cells in a series in Google Docs/Excelhttps://ask.libreoffice.org/en/question/96770/formatting-cells-in-a-series-in-google-docsexcel/I don't know how to phrase this so here is what I'm trying to do: I have a series of cells that I need to increase by 50 every two cells.
So here is my data: Cell 1: 0, Cell 2: 50 (+50), Cell 3: 100 (+50), Cell 4: 200 (+100), Cell 5: 300 (+100), Cell 6: 450 (+150), Cell 7: 600 (+150), etc.
So is there a way to format the cell allowing the sequential increase to be every two cells instead of after every one? Sorry if this is confusing or not phrased well I wasn't very sure on how to explain this. Also to anyone who takes a look at this question, thanks for your time.GrimmjaxxTue, 23 May 2017 08:42:33 +0200https://ask.libreoffice.org/en/question/96770/Increment by 6 when I pull down cell?https://ask.libreoffice.org/en/question/89841/increment-by-6-when-i-pull-down-cell/ When I pull a cell down the cells are usually filled with a series of numbers that increase by 1.
1, 2, 3, 4, 5 etc.
I want to pull a cell and get all the other cells filled by an increment of 6
1,7,13 etc.
How do I go about doing so?
In excel I just have to fill the first three cells with the series I want and it fills automatically. Is there any way I can do something like this in Librecalc?
Also, I would like for this to apply to formulas as well.medicengonzoThu, 09 Mar 2017 18:47:14 +0100https://ask.libreoffice.org/en/question/89841/Calc: how to chart series "slices"?https://ask.libreoffice.org/en/question/89423/calc-how-to-chart-series-slices/This is my challenge: I have several very long time-series in a sheet. Column A is date and columns B-... are samples from sensors. Of course, I can display the raw time-series under various formats and styles.
However, I'd like to see "de-seasonalised" trends in these data. By "de-seasonalised" I mean, e.g., all samples taken at 8:00, 9:00, 10:00 ... as 24 independent series for hourly samples, or all samples for January, ... as 12 independent series for monthly samples.
AFAIK, there is no way to select a range of cells with a step to say "take every other n cells". All I can do is chart B1:B999 and any fancy addition like A1:B999:12 is immediately flagged as an error.
I looked at pivot tables but they can't spread a 1080-element vector into a 12x90-matrix, which would do the trick.
The nearest I got is to manually enumerate which cells are in the series as B1;B13;B25 ... However this is impractical when the series contains more than, say, 10 elements. As I mentionned, I have many series and they are very long.
I'd prefer not to dump the series into a text file and use *awk*, *perl* or other macro processor to group the samples differently. I'd like to do it all from inside LO.
**Is there a way to define a subset of regularly spaced cells within a range like B1:B10, taking 1 every other n cells, so that this reference can be directly input into the "data range" for a chart?**
EDIT: Following @karolus question, my problem is akin to **subsampling**.
EDIT 2017-03-07: [Lupp's updated.ods](/upfiles/14888706958342334.ods) for @Lupp examinationajlittozSun, 05 Mar 2017 17:43:06 +0100https://ask.libreoffice.org/en/question/89423/How can I create a chart with dynamic data series?https://ask.libreoffice.org/en/question/3567/how-can-i-create-a-chart-with-dynamic-data-series/I am looking for a way to create a dynamic chart in Calc, so that it automatically increases or decreases the rows evaluated depending on the number of rows populated in my source data sheet. This source data sheet may change regularly - i.e. one week it may contain 50 rows; the next week 125 rows and so on.
I've tried:
- Define a Name with a range. The range can be changed with a macro, but i've not found the way for call that name inside the chart.
- Modify with a macro the range of the series but i only can change the range of one of the series.
Anyone can help me please?
{UPDATE}
OK, now I have a chart that automatically increases or decreases the rows evaluated depending on the number of rows populated in a pivot table. Now the problem is that some data in the pivot table isn't show because is repeated. Is there any way to show repeated data in a pivot table?
Thank you
ManelWed, 27 Jun 2012 14:05:21 +0200https://ask.libreoffice.org/en/question/3567/Compute an arithmetic series in calc?https://ask.libreoffice.org/en/question/33583/compute-an-arithmetic-series-in-calc/If I want to compute the value of a series, how would I do that?
Specifically, I'd like to calculate the sum x*2^(x-1) where x goes from 1 to n (incrementing by 1). Is there a way to do this without having a column or row that just tracks each term in the series?PinyakaWed, 07 May 2014 17:18:09 +0200https://ask.libreoffice.org/en/question/33583/Several data series with different categories/labels in one charthttps://ask.libreoffice.org/en/question/24735/several-data-series-with-different-categorieslabels-in-one-chart/Hi there.
*After having checked that no similar issue were reported, I dare putting mine.*
I'm struggling putting in a unique scattered diagram/graph data with adequate labels.
This is kind of reccurent problem for risk analysis.
Consider that we have n categories, for each category we have 4 sets of data:
column 1: label
column 2: x
column 3:y
column 4:z
and consider that you need a bubble plot where (x,y) are the coordinates and z the size of the bullet.
What I need to do is to put the label appearing.
It works very fine if you have a unique category.
It's another story if you need to deal with several categories.
**Example**
assuming category 1=T, category 2 is F
T1 0.1 0.5 0.05
T2 0.2 0.1 0.02
T3 0.15 0.1 0.015
T4 0.25 0.2 0.05
F1 0.2 0.6 0.12
F2 0.1 0.3 0.03
F3 0.9 0.2 0.18
F4 0.2 0.5 0.1
and you need the bubbles to show T1... T4 and F1... F4 as labels where appropriate.
*any kind of help will be appreciated.*
Best
Moon
moonSat, 02 Nov 2013 22:50:14 +0100https://ask.libreoffice.org/en/question/24735/Possible to set Chart's Data Series name to constant?https://ask.libreoffice.org/en/question/19997/possible-to-set-charts-data-series-name-to-constant/While creating XY (Scatter) charts in Excel 2000, I've become accustomed to setting the "Name" of Data Series to appear in the legend in a way I can't seem to do in LibreOffice 4.0.4.2.
Sometimes I set names of a Data Series to a constant that is more meaningful (and less concise) than in the source sheet (or that would fit in the title bar of the source sheet or that is needed there since there is a different context on the source sheet). For example, I may enter:
="Inflation Adjusted Value"
into the Name field of a Data Series entry.
When I try this in LO, it appears to work (the legend is updated) *BUT* when I save the .ods document, exit, and reopen it, the change is lost and the series is now named 'Column X'. [This is actually annoying -- it shouldn't be accepted if it won't be saved, indeed NOTHING should be accepted that can't be saved in native format or, at least, the save operation should warn it will be lost].
The question is: **Is there some form of syntax in LO that will allow me to do this without putting the desired series name in cells somewhere (such as a "constants and values" sheet) and referencing them -- thereby creating a bunch of artifacts that are unnecessary and confusing to future maintainers (including me in two months)?**YALOUMon, 08 Jul 2013 15:00:53 +0200https://ask.libreoffice.org/en/question/19997/