|
Number
|
Question
|
Date
(dd/mm/yy)
|
Length
|
|
|
|
|
|
|
1645
|
This information was located on the OpenOffice.org users mailing list. There are apparently two games built into the Calc application.
|
08/12/06
|
316
|
|
1470
|
I have a pipe delimited text file which I want to edit to remove some columns. Using Excel I can open the file using the pipe as the delimiter but I can't save it again using the pipe as the delimiter. It becomes a tab delimited file which is not what I want. Any suggestions?
|
29/10/05
|
1211
|
|
1300
|
I have to create a Calc spreadsheet with the first column being the date Friday each for fortnight. Is there an easy way to enter the dates rather than typing them all in?
|
30/05/05
|
463
|
|
1011
|
I enter a series of numbers into a column in Calc. How do I get the moving average for the last ten days?
|
09/06/04
|
4328
|
|
997
|
I have formulas in my Calc spreadsheet. I would like to copy and paste these formulas as the values. How do I do this?
|
07/05/04
|
1244
|
|
986
|
I have a budget which has months at the left and categories across the top for the columns. In the categories column sometimes I would like to enter the same value in all cells and sometimes the same formula. Other times I just want to enter a value in a cell. How do I do this easily?
|
13/04/04
|
4169
|
|
966
|
How do I move columns or rows in Calc?
|
26/03/04
|
779
|
|
942
|
I have a blue page break line in the middle of a Calc spreadsheet. How do I remove it?
|
14/03/04
|
236
|
|
941
|
I have a multi sheet spreadsheet in Calc and I am getting blank pages, but I can't seem to find where they are coming from.
|
14/03/04
|
344
|
|
825
|
When I type in Calc it tries to autocomplete the cell based on an earlier entry in the column. How do I stop this?
|
02/01/04
|
59
|
|
815
|
How do I protect just a few cells in a Calc spreadsheet?
|
01/01/04
|
1473
|
|
814
|
How do I have the column headers print out at the top of each page?
|
31/12/03
|
853
|
|
813
|
How do I keep the column headers display when I scroll down the Calc spreadsheet?
|
31/12/03
|
260
|
|
812
|
How can I easily check which cells are protected in a Calc spreadsheet?
|
31/12/03
|
243
|
|
811
|
How do I suppress displaying zeros in a Calc spreadsheet?
|
31/12/03
|
629
|
|
810
|
How do I enter times into a Calc spreadsheet?
|
31/12/03
|
736
|
|
809
|
In Calc how do I convert a Time 12:30 into a decimal number?
|
31/12/03
|
284
|
|
607
|
I have email addresses in a column. I would like to split this into the user and domain so that I can sort by the domain. How can I split the string.
|
15/08/03
|
1063
|
|
574
|
Calc in OpenOffice.org 1.0.3.1 does not show formulas when spreadsheet opened.
|
21/07/03
|
147
|
|
568
|
When I delete something in Calc a dialogue always appears. Is there some way to delete without the dialogue showing?
|
19/07/03
|
212
|
|
564
|
How do I split merged cells in Calc?
|
19/07/03
|
75
|
|
563
|
How do I merge cells in Calc to become one cell?
|
19/07/03
|
122
|
|
562
|
How do I modify the default template for Calc so that I have my own defaults?
|
18/07/03
|
1449
|
|
554
|
When entering months in uppercase in Calc these are converted to proper case. How can I stop this?
|
18/07/03
|
1095
|
|
550
|
I like to have numbers most times with two decimal places. How can I do this more easily than formatting the cell each time.
|
10/07/03
|
923
|
|
505
|
If have a column of data in Calc. I want to see how many times a number occurs in this data. How do I do this?
|
02/06/03
|
576
|
|
500
|
How do I only preview or print just one sheet in Calc?
|
29/05/03
|
659
|
|
497
|
How do I quickly jump from the first sheet to the last sheet in a spreadsheet? I have lots of sheets and so clicking on the tabs is a bit slow.
|
26/05/03
|
568
|
|
493
|
Can I copy a spreadsheet into Writer as a table?
|
17/05/03
|
1211
|
|
481
|
In Calc I've sent a graphic image to the background. Now I can do anything with it. How to I get to change it.
|
07/05/03
|
785
|
|
476
|
How do I make Notes stay visible in Calc?
|
06/05/03
|
75
|
|
462
|
How do I enter the same data into cells at the same time in Calc?
|
02/05/03
|
214
|
|
458
|
How do I move rows or columns in Calc?
|
01/05/03
|
384
|
|
450
|
I want to find all cells which have the same value in them. How do I do this?
|
29/04/03
|
336
|
|
449
|
I would like to make the date format YYYY/MM/DD the default in my spreadsheet.
|
29/04/03
|
1037
|
|
448
|
I would like to use the date format of YYYY/MM/DD in my spreadsheet but it is not available.
|
29/04/03
|
297
|
|
441
|
Can I enter and use fractions in Calc?
|
28/04/03
|
1298
|
|
439
|
How to select all sheets in Calc so that what is done in one sheet is performed on all sheets.
|
18/04/03
|
1004
|
|
430
|
How do I select multiple cells on a Calc spreadsheet?
|
12/04/03
|
633
|
|
423
|
How do you print just the Active sheet in Calc. Currently all sheets are printed.
|
10/04/03
|
218
|
|
416
|
I have text which consists of names which are all in lowercase. I would like to show their names with a capital letter at the start of each of the first and last names. How can I do this?
|
09/04/03
|
1080
|
|
411
|
How can I put a text box in Calc with a black line around it?
|
09/04/03
|
466
|
|
386
|
How do I convert the column of cells which contain the text values of 1, 10, 2, 20 into numbers so that I can sort them correctly?
|
31/03/03
|
1116
|
|
385
|
I am trying to sort a column with numbers and it sorts them in the sequence of 1, 10, 2, 20. What is going on?
|
31/03/03
|
295
|
|
377
|
In Calc when I enter a number in a cell, drag the handle right it fills each cells with the number increased by one. When I use Edit -> Fill -> Right it keeps the same number. Should these be the same?
|
28/03/03
|
953
|
|
376
|
How do I find the number of days between two dates in Calc?
|
27/03/03
|
224
|
|
365
|
How do I centre a heading I have over a number of columns in Calc?
|
26/03/03
|
372
|
|
362
|
I want to create a tab separated file from Calc but I don't want any text delimiter. It is not giving me this option.
|
26/03/03
|
189
|
|
353
|
There are not any icons for Merge and Split cells in Calc. Where do I find these icons?
|
24/03/03
|
737
|
|
348
|
I'm trying to select a non continuous range of cells in calc but it keeps forgetting about the first single cell when I do it. What is going on?
|
22/03/03
|
696
|
|
344
|
I've got a document which uses fields from a Calc spreadsheet as the data source. I am having problems showing seeing any of the changes in the spreadsheet show up in the data source for merging. Any suggestions?
|
20/01/04
|
3197
|
|
343
|
I have a spreadsheet with formulas and I wish to copy of paste the resultant values and not the formulas. How do I do this in Calc?
|
21/03/03
|
350
|
|
341
|
I have followed the DCOUNT example in the help screens to the letter but all I can get is an error 504. What am I missing?
|
20/03/03
|
1201
|
|
335
|
Can two people edit different sheets in a spreadsheet at the same time?
|
17/03/03
|
423
|
|
334
|
Is there a way to have multiple users simultaneous edit the same spreadsheet without being able to destroy each other's work?
|
17/03/03
|
622
|
|
314
|
How do I move rows in a Calc spreadsheet? I don't want to copy and paste them. I want to just move them.
|
10/03/03
|
323
|
|
313
|
Calc keeps suggesting entries as I type in a cell which appear in earlier cells in the same column. This is quite annoying sometimes. How do I turn this off.
|
10/03/03
|
287
|
|
312
|
In Calc when entering a cell it always capitalises the first letter of the cell which is not what I want
|
10/03/03
|
465
|
|
299
|
How do I open a delimited text file in Calc called filename.asc? Every time I try to open this it opens in Writer.
|
06/03/03
|
161
|
|
298
|
I have data in two columns. Column A is 1, 2 3, 4. Column B is 2, 4, 6, 8. But I would like to get a running sum of the data of the column B and then graph the first column and the running sum?
|
06/03/03
|
548
|
|
261
|
How do I create a continuous line of equals across a column in a spreadsheet?
|
25/02/03
|
368
|
|
244
|
I am trying to create a database from a Calc spreadsheet but using copy the field formats do not come across very well. Any suggestions?
|
20/02/03
|
440
|
|
236
|
I am trying to insert a text file into Calc. There is no import function so I am trying to use Insert, External Data. It allows me to specify the file but then does not allow me to press OK. What should I do?
|
19/02/03
|
392
|
|
234
|
How do I get the text in a Calc cell to wrap to the next line?
|
19/02/03
|
154
|
|
220
|
I have a three columns of data. They are Date, Category and Quantity. I want to summarise this into a table which shows Months across the top, a row for each Category and the Quantities totalled. How do I do this?
|
14/02/03
|
966
|
|
202
|
I have a data in a spreadsheet which is a straight list with the columns Date, Type and Count. I would like to create a chart showing each type as a separate column with the Date as the X-axis and Count as the Y-axis. Is there any easy way to do this?
|
12/02/03
|
492
|
|
166
|
How do I set the default font in Calc?
|
09/02/03
|
910
|
|
163
|
How do I copy the rows of a table in an external data source to a spreadsheet?
|
09/02/03
|
952
|
|
161
|
In my spreadsheet I have database formulas which use named ranges. How can I change easily all the formulas that refer to a named range to another named range?
|
09/02/03
|
54
|
|
160
|
I have a Calc spreadsheet and I have a series of tables. I would like to add up only certain rows based on the value in a cell in that row. Any suggestions?
|
09/02/03
|
149
|
|
131
|
I have a spreadsheet with a wide cell which goes over the page. When I print the entire cell moves to a new page and not just the part that would go off the page. Is there anyway around this?
|
26/01/03
|
264
|
|
130
|
How do I import a text file into Calc?
|
25/01/03
|
652
|
|
99
|
I typed the letters A.G.L. in the cell in OpenOffice.org Calc and they turned blue with a grey background. What is going on?
|
13/01/03
|
915
|
|
98
|
When I type into a cell in OpenOffice.org Calc the first letter always goes to lowercase when I press Enter. How do I get around this?
|
07/04/04
|
1786
|
|
9
|
How do I change the case of the contents of the cell in OpenOffice.org Calc.
|
19/08/02
|
226
|
|
8
|
How do I edit the contents of a cell directly in OpenOffice.org Calc?
|
22/08/05
|
535
|
