i am trying to use Calc for simple calculations. How can i do so that a whole column uses a number from previous row? for example i want D2=B2+C2+D1 and the next row to be D3=B3+C3+D2?
View 5 Replies
I'm having some troubles with my backup script, i want to delete the folder that is 2 weeks old. The problem is that when is use the folowing code:
YEAR=(date +%Y)
Code:
#Remove old directories
TWOWEEKSAGO=$(date +%U)-2|bc
echo $TWOWEEKSAGO
#rm -r /home/[my home directory]/Backups/$YEAR/$TWOWEEKSAGO/
The $TWOWEEKSAGO variable is [empty] and not 14, but when I remove the -2|bc and I use:
Code:
echo $TWOWEEKSAGO-2|bc
It echo's 14.the weeknumber at this moment minus 2, I have to fix it when the weeknumber is 1 or 2 so the directory of the last year will be deleted, but I will fix that later if you don't know that.
Code:
#Remove old directories
TWOWEEKSAGO=$(date +%U --date='2 weeks ago')
rm -r /home/[my home directory]/Backups/$YEAR/$TWOWEEKSAGO/
After 30 minutes with some help I coded the following to delete the folders of last year:
Code:
#Remove old directories
TWOWEEKSAGO=$(date +%U --date='2 weeks ago')
if [ $TWOWEEKSAGO -eq 51 ]; then
[code]....
I have several videos (around 50) of varying resolutions aspect and varying aspect ratios that all need to be down converted to be playable on iOS and Android. Some videos are 4x3 some are 16x9 and some are 2.35x1. I want to write a script to convert all of these to a 360P version in one go. That means the 4x3 will be 480x360 the 16x9 will be 640x360 and the 2.35 will be 640x272.Is there a feature in FFMPEG that will automatically do the calculations for me?
View 9 Replies View RelatedInstall GSL for scientific calculations. When you try to. / Configure appears Permishn denaynd. As I understand it because I have a file system in properties has Read-Only flag. An attempt to change it to read and write an error - saying that this can not be done. All this is done under Root. But nothing came of it, and very much need to put this library.
View 13 Replies View RelatedI am piecing a Mandelbrot generator up, I have one working to produce a 1,500 x 1,500 picture (which is fairly accurate).
I would like to increase the resolution over 100,000 x 100,000 + (into the millions x millions).
How I can achieve this? What kind of buffer sizes do I need?
(note this code doesnt have any memory allocations yet)
Here is my code so far:
The program outputs the Mandelbrot as a .tga file. I calculated the image on fixed axis of -2 to 2 (on the x and y axis). Image produced: [url]
i'm a college student studying pc programing, and i was given today a special work and i have to program using miranda... which i've never used it >.< can anyone give me a hand to where to download, how to compile, and a simple tutorial for making a simple program or something?
View 3 Replies View RelatedI frequently (i.e. after 10-20 minutes of use) get a complete system freeze when using LibreOffice Calc 3.3.3, on Ubuntu 11.04. At the time, I have an *.ods file open, and the freeze happens at various times, for example just after pressing the Page Up button. After the freeze occurs, nothing responds, not even Ctrl+Alt+F1, and I have to force power off my laptop.
how to debug this problem, as there's no error message, no error log (that I know of??)..
I have been trying to repeat the first two rows in a Calc document but I keep getting an error.
Here are the instructions that I used.
Printing Rows or Columns on Every Page If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page. As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
1.Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
2.Click the icon at the far right of the Rows to repeat area. The dialog shrinks so that you can see more of the sheet.
3.Select the first two rows and, for this example, click cell A1 and drag to A2.
In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
4.Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
5.If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
6.Click column A (not in the column header).
7.Click the icon again at the far right of the Columns to repeat area.
Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.
And here is the error.
"invalid sheet reference"
ClamAV tells me that three of my OpenOffice.org Calc spreadsheets may be infected (status "MBL_144360.UNOFFICIAL", if that means anything). This seems not entirely implausible, since yesterday I used a USB stick to transfer files from a Windows system. Anyway, I'd really like to keep these spreadsheets. Can I disinfect them somehow?
View 2 Replies View RelatedI'm looking for a Linux Open Office Calc Spreadsheet template to replace Intuit's Quicken. I prefer a spreadsheet over a stand alone. Anyone?
View 1 Replies View RelatedOne of my friend ask me a favour. He asked me to download stock exchange's one year equity shares data and transfer into sql. So i downloaded all csv file saved in a calc file after done all most I saved it and closed calc. After that I found openoffic.bin was using my 50$ memory and cpu so I manually ended the process now when I open the file I get shocked I lost all most all data of 9 months have only 2 month's data but in file's properties it's still showing last modified time and size.
View 2 Replies View RelatedMy low-down lousy computer crashed while I had two spreadsheets (Libre Calc) open. When I re-booted the 'tater, then clicked on the launchers for my spreadsheets, Libre Calc opened new, blank documents.
Is there a way to find the lost spreadsheets? If I can't have the whole things, then just the data would be OK.
Okay so I have a file that I always save and close properly and get in my Ubuntu One folder for backup that will not open. Its called "Income.ods" and is quite important and I cannot seem to recover it. When I double click it, it shows the Libre Office Calc splash screen shows up then goes away and the nothing, no error messages, no nothing. I tried to open it on my Windows Vista machine and it said it was corrupted and could not open in Office Word. I tried a few recovery tools but to no avail.
View 9 Replies View RelatedI have a Calc spreadsheet that has 3 sheets. The first page is set for Portrait and the remaining pages are Landscape. Currently I am printing each page as a separate print job.I would like to print the entire Calc pages as one job where the printer prints the first page as portrait and the remaining pages as landscape without user intervention.
I do not see any command in the print dialog or in open office dialogs that tell the printer to change orientation. It seems that OpenOffice fails to tell the printer the page orientation. Is there any way to accomplish this. If a macro is required how do you write it and how is it executed?
I don't know if such a thing exists but I would like to do convertion a PDF file to a spreadsheet. Do You know of any application to do this ?
View 2 Replies View RelatedWhat is the macro command (in OpenOffice Basic) to select an entire Row or Column? I tried to "Record Macro", then click on the Row/Column header, which would then select the entire row/column. But "Record Macro" failed to capture this action.
View 1 Replies View RelatedI'm using OpenOffice from repo. In Calc I want to fill in 2 cells under eachother, consisting of a name, space and a digit. Then, after selecting both cells, drag them down to get a list of this name, with only the digits being different. When using OpenOffice from original download, this gave no problem. Now however, I'm presented with a Fill Series window that gives me some options like Direction, Series type, etc. And whatever I fill in, it says �nvald value. How can I get rid of this Fill Series window. The Help function in OpenOffice doesn't give a clue on Fill Series.
View 4 Replies View RelatedI must say I am newby using Fedora, but cannot find solution how to define print range in calc. I am using oo for almost ten years in windoze, but this is first time I have this problem. I'm using Fedora 14 L, on my lap compaq 6715b. During install, everything went just fine, only problem in last month, since I install F14 L I have find, was using oo calc. I need that rather quickly because I need to apply my tax income until end february,
View 3 Replies View RelatedIn OpenOffice spreadsheet, using the Page break preview you should be able to move the thick lines that indicate the separation between pages. Some versions ago you could do it normally. But now it's impossible. You can just move the thick line that indicates the limit of the print area.Has anybody noticed this? Is there any solution? In Ooo for Windoze it's possible, but I prefer not to use it unless is absolutely necessary.
View 4 Replies View RelatedHow can I delete empty lines in OpenOffice Calc?
View 2 Replies View RelatedImported an Excel file into OO.o Calc. EVerything is fine except the comments are all blank. It knows that comments should be there, but they're all empty. how to recover the contents?
View 2 Replies View RelatedIs it possible to filter data using color in Open Office Calc?? It's very easy to use this function in MS Excel.
View 1 Replies View RelatedI prepare an MS Excel 2007 spreadsheet which includes macros and user defined functions on a Windows machine. I transfer that file to a Mandriva 2010 machine and I load the file with OpenOffice Calc 3.2.0 and it runs the macros properly. I transfer the file to a Fedora 13 machine and I load the file with OpenOffice Calc 3.2.0 but it doesn't run the macros. I set "Tools/Options/Security - Macro Security" to Low in both cases.I am very new to OpenOffice - is there any other setting of which I am not aware?
View 4 Replies View RelatedI've got a CD which does the monthly compounding on the last day of every month instead of every 30 days. The bank gave me a print-out (of course), but I'd like to make my own Calc spreadsheet too. My question is: How do I check whether a certain day is the last day of the month? In other words, I'm looking for something that returns TRUE if it's the last day of the month and FALSE if it isn't. I'm using OpenOffice.org 2.4.1 on Ubuntu 8.10.
View 1 Replies View RelatedThis is supposed to be possible right and better than naming each single cell?How do you do it?Also, maybe my approach is wrong as it's going to lead to a very big nested IF statement.There is a list of numbers which are price ceilings and another list of numbers containing the fees applied to these. I want to a formula that checks the item price against the ceilings and if it's less than or equal to that ceiling uses the fee in the adjacent row (which is the other data range).The only way I know how to do this is a big nested IF statement but does anyone know better?
View 5 Replies View Relatedyou are using Calc to hold data, and you have a column of surnames. You enter True and it turns into TRUE: OO has decided you wanted a Boolean. Similarly, you enter a date as 12 Jan 09: it may appear in that format, but you can't search for Jan 09, only for 01/09. Is there any way one can set the data type of a cell as text, or prevent OO from carrying out unwanted type conversions? I suspect the answer will be no; I can't find anything in the pages, and I suspect the developers would say I should be using Base. Well, I don't want to use Base: I want my data displayed spread-sheet style There is a solution: to insert non-breaking spaces in dates and after words like "true", but it would be nice if the problem could be fixed just once.
View 5 Replies View RelatedI am trying enter a VLOOKUP formula in Sheet1, where the array is in Sheet2. For both the items, I have used mouse to enter cell references, which I always do.
1. Search criterion has been entered as a range, which is different from previous versions and not a very comfortable situation.
2. array reference completely missed entering Sheet2! in front of A1:C13. Only way out of this is manually entering the sheet name, which is not only cumbersome but also ludicrous. Moreover, we never had to do it like this in the past. I am using OpenOffice.org 3.2.1 in Ubuntu 10.10.
I highlight a column by selecting "D" > format cells > background > I select a color and press OK. But the color on the document remains the same.
View 3 Replies View RelatedI need to make a function combination to get for: If cell A1 then for B1 as:
A1 B1
--- ---
abc abc
hello hello
empty empty
0 0
-3 -3
5 5
and like wise
I have 2 versions of the same spreadsheet. Each spreadsheet is divided into many different workbooks.
I have googled this without success. I want to automatically find any lines in spreadsheet 1 which are not in spreadsheet 2 or vice versa.
