Software :: "link" One Column To Another In OpenOffice Calc?
Jul 28, 2011
If I have say, a column of Months, eg. "January", "February" etc., with a "income" column to the right of it, for say, 6 months - eg. "423", "2342", if I highlight some or all of the months and Sort it, I would like the "income" column values to move up and down as well- eg. if the months become "February", then "January", I would like to see the corresponding change in the "income" column as well, eg. first "2342", THEN "423". I would like this even if I say, Manually move the "months" column data around, eg. put "February" at the bottom.
View 2 Replies
ADVERTISEMENT
Feb 4, 2010
What 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 Related
Dec 10, 2009
I'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 Related
Oct 30, 2010
In 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 Related
Jun 17, 2011
How can I delete empty lines in OpenOffice Calc?
View 2 Replies
View Related
Jul 11, 2009
I'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 Related
Oct 18, 2010
I 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 Related
Jan 19, 2009
I'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 Related
Mar 3, 2010
you 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 Related
Nov 1, 2010
I 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.
View 2 Replies
View Related
Jan 27, 2011
I just upgraded to OOo v3.3.0, but it feels more like a downgrade; a real disappointment. In my previous version, I could choose 'Tab' in the 'Paste special' dialog and the choice would stick between pastings as well as between sessions. No longer so. In v3.3.0 I have to tick 'Tab' and 'Detect special numbers' each and every time I paste something. I am working with OOo all day and this regression is tiresome, to say the least. So, I am wondering whether there is a way to make the choices sticky? If not, I shall have to go back to the previous version, or perhaps try out LibreOffice.
View 7 Replies
View Related
May 11, 2011
I have a Canon iR3570/iR4570 PXL, and installed the driver CQue 1.0 TCP/IP Queue from Canon webpage.
The problem:
- if i try to print an OpenOffice or LibreOffice Calc with an image and text, the image is not printed (the space is blank).
- if i try to print an OpenOffice or LibreOffice Calc with just an image, it's printed great.
- if i try to print an OpenOffice or LibreOffice Impress, the images are not printed but the text is printed great.
[Code]..
View 3 Replies
View Related
Jul 19, 2010
How would i calculate following values.Initial file
10 3
20 4
How would i calculate 3rd column which should be addition of value in 1 and 2nd column.File after calculation
10 3 13
20 4 24
View 14 Replies
View Related
Jul 15, 2010
I have a multicolumn datas, like
a1 b1 ... f1
a2 b2 ... f2
. . ... .
[code]...
I would like to make a file with all these data in one column, like
a1
a2
.
.
[code]....
Can it be done with awk or some other command? Also, is it possible then do add another column in front of this one with numbers of the lines (for every previous column), like
1 a1
2 a2
. .
. .
[code].....
View 14 Replies
View Related
Mar 7, 2010
i use this script to get the time and date of back and fourth transactions for a particular execution id. I use a substr command on the 5th column to to cut the milli seconds off the time value. - otherwise the times would look like 08:30:04.235
grep <executionID> <auditfile> | awk '{ print $1, $2, $3, $4, substr($5,1,8}
FIX -> Mon 3/1/2010 08:30:04
FIX <- Mon 3/1/2010 08:32:36
FIX <- Mon 3/1/2010 08:35:08
[code].....
anyhow - i append two sed commands to further clarify the direction of the message.
awk '{ print $1, $2, $3, $4, substr($5,1,8} | sed -e 's/->/ ->IN/g' | sed -e 's/<-/<-OUT/g'
FIX -> IN Mon 3/1/2010 08:30:04
FIX <- OUT Mon 3/1/2010 08:32:36
[code]....
I tried using an awk gsub () command within the string instead of the two seds, but it did not work:
awk '{ print gsub(/<regex>/, <replace with>,$1), $2, $3, $4, substr($5,1,8}
the sed works ok, but it would be cooler to make the replacement within the awk command:
gsub(/->/,-> IN, $1)
Is there a way where i could replace the value of the $1 column in the awk print string?
View 1 Replies
View Related
Dec 14, 2009
I'm trying to install a language-pack for my OpenOffice, but there seems to be a dependency-problem. Maybe someone has a suggestion. FC12, x64 OOo.x64 3.1.1
Code:
[root@sarah yum.repos.d]# yum install openoffice.org-langpack-de
Loaded plugins: fastestmirror, presto, refresh-packagekit, remove-with-leaves
Loading mirror speeds from cached hostfile
* fedora: ftp.astral.ro
* livna: rpm.livna.org
[Code]...
View 6 Replies
View Related
Apr 28, 2010
i only need localhost for testing some phpnow i get[Wed Apr 28 18:44:57 2010] [error] [client ::1] Symbolic link not allowed or link target not accessible: /srv/www/htdocs
View 9 Replies
View Related
Sep 6, 2010
In the ordering of files I keep I need links to directories. Sometimes I even need to move directories to new locations. I have tried using symlinks, but they become dead when I move the directory they point to. I have tried hard links, but I haven't found any Linux file system that would support hard linked directories. How can I achieve that a complex structure of directories (currently with symlinks for directories and hard links for files) keep symlinks live when directories are moved?
- is there any utility that updates symlinks when a directory is moved?
- is there any Linux filesystem that supports hard linked directories?
- is there any good Linux interface to the new NTFS (the only file system I know to support automatically updating directory links, called directory junctions)?
View 9 Replies
View Related
Jun 5, 2010
I have an nfs share that mounts automatically when kde starts.
Code:
wendy@DellNB:~$ cat .kde/Autostart/mountNAS.sh
#!/bin/bash
mount ~/TestShare
#echo "NAS Mounted"
[code]...
Gimp works fine editing and saving photos from/to the nfs share. kWrite can do its thing and read/create files on the NAS. Files I create with vim are visible and editable under windows. OpenOffice however, when I try an open a file I get "file is locked by unknown user." I open as copy and try saving to the share with a different name... No Dice, error saving to share the file is created on the share but it is empty. I did some reading and found a post that said to comment a line from a file called soffice, which I cannot find.
View 2 Replies
View Related
Aug 16, 2011
I was looking for live link to download ubuntu mobile but unfortunately I don't find anything... Can someone send me a link for download and a link with the installation instructions ?? All the links that I found are dead.
View 9 Replies
View Related
Jun 8, 2010
Whenever we insert CD,it creates a shortcut link in desktop.Can we list this link name by using any command? I am using Oracle Enterprise Linux 5.0.
View 10 Replies
View Related
Sep 8, 2010
how can we create soft link and hard link in RHEL5 when am using in command it is giving format error
View 6 Replies
View Related
Apr 26, 2010
I have a problem where I'm using Ubuntu linux to mount a Windows Vista machine's USB drive and access it on the web using Apache. I did have the USB drive plugged into the Linux machine directly and that was working via the web. FollowSymLinks is on in httpd.conf
[Code]....
The mount works and I can see the files (see above) from my regular linux user account. If I make a test file in /mnt and soft link to that, I can see it on the web. So it's just the mount to the vista machine that seems to be a problem. It's supposed to be a simple read-only mount and the apache login should (I think) be able to see the same generic root access permissions.
log from apache: [Mon Apr 26 20:39:42 2010] [error] [client 99.99.99.99] Symbolic link not allowed or link target not accessible: /home/user1/pub_html/Music, referer: https://xx.xx.xx/~user1/music.html
The credentials have a login and password that matches a special read-only account on Vista. I can see the files on the system from Linux, but not via the web. As mentioned above, a different link to the same /mnt area works fine via the web. I've tried several different mount options with no success.
View 3 Replies
View Related
Jun 20, 2011
I have searched around and am trying to understand the difference between a hard link and symbolic link (soft link). I found this link is quite useful. But I am still not very clear. I understand soft link is not a copy of original file, but is a hard link a copy or not?
View 4 Replies
View Related
Dec 6, 2010
One 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 Related
May 25, 2010
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
View Related
Jan 24, 2011
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 Related
Jul 29, 2011
I 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??)..
View 5 Replies
View Related
Feb 23, 2011
I 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 Related
Oct 28, 2010
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"
View 1 Replies
View Related
