Software :: Setting Data Types In OpenOffice Calc?
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
ADVERTISEMENT
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
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
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
May 24, 2010
Im currently using OpenOffice.org Writer to write a hand in document for my course. I've come to the point where I want to create a graphical tree in Draw to present an idea and then add this document into writer. I've tried to use Insert -> Object -> OLE Object, and add the document as an inline frame. This looked pretty ugly though, either it's too small or there seems to be no way to just resize the frame without stretching the whole document into unreadability.
View 2 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
Jun 17, 2010
This 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 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 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
View Related
Jun 9, 2011
i am searching for a table that gives info about the result of operations (+ , - , * , /) on data types
i mean if we * int by another int, the result should be assign in long so no overflow happens.
something like that.
like what will be the result of mult unsigned int by signed it , is there tables for such operations.
View 6 Replies
View Related
Apr 9, 2011
I would like port 80 to have a small daemon running on it that detects HTTP traffic and sends a small redirect response, and any other traffic begins streaming data from my VPN daemon. I was wondering if this has already been made, or any kind of technology for detecting types of traffic and allowing you to run multiple types of servers on the same port.
View 4 Replies
View Related
Sep 12, 2010
I'm trying to use "netlink" to get ip address of a Linux box. But the linux/types.h included from "linux/rtnetlink.h" introduced many conflicting type declarations with "sys/types.h".
#include <rtnetlink.h>
#include <sys/types.h>
#include <sys/socket.h>
int main (int argc, char *argv[])
{
return 0;
}
The program will demonstrate such type conflicts.
View 3 Replies
View Related
Jul 16, 2010
I need to have a global variable PHP Code: volatile sig_atomic_t int Terminazione=0; but I get the error error: two or more data types in declaration specifier even if I have included signal.h.
View 2 Replies
View Related
Sep 13, 2010
I installed google-chrome and configured it as my default browser in my desktop "Preferred applications" configuration app, and in update-alternatives --config x-www-browser. I also exported the BROWSER variable to be = /opt/google/chrome/google-chrome (logged out and then logged in again). Although, If I open a XLS file with some links inside (OpenOffice 3.2.0) it opens links in firefox instead of google chrome. I surfed across all options in Tools->Options and there is nothing to set or change the default browser.
View 2 Replies
View Related
Oct 14, 2010
Elsewhere is my question about 11.3. I have had to abandon that and 11.3 as my RAM is too small. Now, for the first time in many years, I find it necessary to extract specific data from received .pdf files. According to OpenOffice, editing of these files is only possible from version 3.2. My concern is whether this later vesion will be compatible with 11.2.OpenOffice installed is 3.1.1.4-1.1.4-i586. The same question has been directed to their Forum.
View 9 Replies
View Related
Jul 8, 2010
I've a big issue using unoconv to convert Office docs in PDF format from a PHP script.It works perfectly when I run the script or the unoconv commands as root, but it fails the second I do the same from web (through apache and www-data user) I have installed Ubuntu 10.04 Server 64bits, openoffice.org and unoconv packages have been installed via apt-get (re-installed today). I think openoffice is version 3.2. Here is a command line that is called by exec() PHP command :
Code:
/usr/bin/unoconv -f pdf /home/www/framework/files/volume_0/document/original/1278613446MWEwwT4k.ppt
[code]...
View 2 Replies
View Related
Sep 1, 2011
I'm using Grsync and I want to be able to plug in any drive into my laptop and run rsync on it to back up all the user documents on there to another external hdd and to exclude everything else. Working on the principle that user documents don't always appear where we'd expect I want rsync to look through the whole drive and filter what it backs up by file type. I am only having partial success, however.
I am using the 'filter' option in the 'additional options' box. I am using the command
Code:
filter='merge /home/tim/Desktop/filter'
and I am attaching the filter file I have written. (I have added the .txt extention to upload it).
I have tested this script on my home folder and here's what's going wrong. Rsync will copy the entire directory structure regardless of whether there are any files to be copied over in those directories. I am also getting only some file types getting included and not others. .odt and .ods files are copied, for instance, but not .doc or .rtf.
View 3 Replies
View Related
Nov 16, 2010
In my hard disk I have win xp, opensuse 11.1 and ubuntu 10.4. I'd like to replace 11.1 version of opensuse with the last one 11.3 without losing data and setting in other partitions. this is my hd:
[Code]....
I think (but I'm not totally sure) I installed opensuse in dev/sda6 and dev/sda7...what is the right thing to do?? should I have to delete /dev/sda5 /dev/sda6 and /dev/sda7 partitions and then install opensuse 11.3 in the new free space??
View 9 Replies
View Related
Sep 2, 2010
I recently made a script to automatically download a directory from my webserver using ftps (required by hosting company). It seems policy has changed again or something, because trying to download files gets the following error:
mirror: Access failed: 521 Data connection cannot be opened with this PROT setting.I can access the files just fine with Filezilla, but not lftp. I didn't change the code, but here it as anyway:
lftp -f ~/the/file/below
Quote:
open -u USERNAME,PASSWORD DOMAIN
lcd /local/place/to/put/files
mirror
quit
I tried manually, login works fine, but nothing can be done after that.until this works again I've broken a backup system of mine.
View 6 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
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
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
