Software :: OpenOffice Calc - Sticky Selections In "Paste Special"?
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
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
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
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 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
Sep 4, 2010
I am trying to copy content from firefox, which has images on it, to Openoffice writer. However, the image does not seems to get copied. It shows only some link. Is there a way to copy everything including images?
View 2 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
Feb 21, 2011
Situation is that there are two users on a Linux server- say A and B.A has been operating a shell script that in turn makes use of and exe file.The script and exe both are owned by user A.My problem is that I want user B to make use of the script and exe in exactly the same way user A does.So I have set suid bit of the script, exe and all the library files that the exe uses.But the exe is still not executing from user B.I did a man of chmod on Linux server and it gave an indication that SUID is disabled on new Linux servers.Now the question is, is there any other command that can perform the same task as SUID did on Unix.
View 4 Replies
View Related
Mar 18, 2010
i have two scripts called: type & selecttype. In type i have only the name of the products ex.: product1 & product2. Now, i am going to ADD product3 which includes productA, productB, productC, productD, productE, productF. so my new type script (menu) looks as below:
1) product1
2) product2
3) product3
and my current selectype looks as below ( which is set only for product1 & product2)my question is how can include the new product3 with all other multiple selections (productA, productB, productC, productD, productE, productF) into my current selectype as below:
#!/bin/sh
echo SELECTTYPE
export -n selecttypechoice
[code].........
View 5 Replies
View Related
Jan 19, 2010
I've tried this with 4.0r3 and 4.0r7 CDs, using two different networks to access repositories, and the same result each time: install goes fine until the "OK" for the "Desktop/Web Server/Mail Server/etc." selections, it brings up the "Select and install software" page and then it freezes, showing "5%" and "Please wait..." under the progress bar.
If I hadn't built 20+ servers this way I'd think it was me, but it's not... I think. What's going on?
(No, we're not upgrading to 5.0. Reference above mention of lots o' servers! )
View 3 Replies
View Related
Apr 24, 2010
The "Quit" and "Show" selections are way too close. Big breaking of Fitt's Law.
View 9 Replies
View Related
Oct 10, 2010
I'm trying to install wine1.3 but I don't want the (recommended) package ttf-mscorefonts-installer.In previous releases, I can run this to 'hold' the package and prevent it's installation:
Code:
echo ttf-mscorefonts-installer hold | sudo dpkg --set-selections.However, this command doesn't prevent ttf-mscorefonts-installer from being installed along with wine1.3 in maverick.[code]....
it's just that dpkg isn't picking it up.What is going on here, and how can I place a package on permanent hold?
Note: I ended up installing wine1.3 by running:
Code:
sudo aptitude install wine1.3 ttf-mscorefonts-installer= but I don't believe that the package is actually on permanent hold.
View 2 Replies
View Related
Apr 5, 2010
how would i highlight multiple selections in a graphical text editor such as gedit, kwrite, kate, leafpad, etc. is it possible? for example; if i wanted to redact a document by removing several different words throughout the document.
i could probably learn vim or nano and regular expressions without too much trouble if those would work better.
View 2 Replies
View Related
Mar 19, 2010
i have two scripts called:
"type" & "selecttype".
In "type" i have only the name of the products ex.: product1 & product2. Now, i have to ADD product3 which includes sub categories: productA, productB, productC, productD, productE, productF. so my New type script (menu) looks as below:
1) product1
2) product2
3) product3
and my current selectype looks how can I add the new product3 argument with all other multiple selections (productA, productB, productC, productD, productE, productF) into my current selectype (as below which is set only for product1 & product2), so when a user select: 3) product3 from "type" would get a new menu of all the sub categories, and the script would process the new additional arguments.
Here is the copy of my selectype script:
#!/bin/sh
echo SELECTTYPE
export -n selecttypechoice
if [ "${upgrade}" == "yes" ] ; then
[code]....
View 5 Replies
View Related
Jan 14, 2010
Finally got a dual boot on this laptop the way I liked it (LOVE my Win7, really like UBUNTU for certain things like getting booted and on the net fast...great). As I was editing and rebooting the GRUB settings UBUNTU got it's updates and installed (including one on GRUB that I hadn't seen before - WITH WARNINGS). Now I can't seem to get this last entry out of the boot menu: vmlinuz-2.6.31-14-generic. It has all this listed now (had dual entries for everything like mem test before):
vmlinuz-2.6.31-17-generic
vmlinuz-2.6.31-14-generic
Windows 7
I got rid of the extra entries like memtest and all using: sudo chmod -x /etc/grub.d/20_memtest86+ and such variations..still though I got one stuck in the boot selections. It won't remove the old linux vmlinuz-2.6.31-14-generic build entry from GRUB (and they both point to the same place). It has a -14 and -17 entry in it now. Like I said both load to the same mount point.
I mean I removed like five extra entries from GRUB using that command after the update (and had done it before about two months ago) but the linux vmlinuz-2.6.31-14-generic selection won't leave the GRUB selections now. I really thought I had it figured out to the bomb having my laptop dual booting before, just didn't like how UBUNTU used my disk space by default last time so I decided to rebuild the laptop.
View 8 Replies
View Related
Apr 12, 2010
I had a dual boot umbutu 9.04 & xp Toshiba laptop satellite A15-S1292, (old bad battery). I use it mostly in linux but had been working in Windows, it may have hibernated and the next boot may have been to Linux. Now it boots straight into Ubuntu login screen that looks like it is may be returning from hibernate (don't use it normally). On boot don't see the normal BIOS announcement or screen allowing the selection of boot device. Doesn't boot Live CD from CD Rom or Suber Grub CD. When I examined the Windows mount receive warning that it could not be mounted as it was hibernated. I followed the suggested mount -t -ntfs -3g -o remove_hyberfile /dev/sda1 and can now access the windows partition. Boots still return to the same linux login screen. Don't seem to be able to boot from anything else.
View 1 Replies
View Related
Nov 25, 2010
How would I remove a package in the selections listing in synaptic. Like remove it so no one will see it to install or remove it. Of make a custom filter be what it displayed by default in the selections list. Or set user privelages to not be able to install anything.? But still able to read and write to the hard drive.
View 2 Replies
View Related
Aug 3, 2010
I am running KDE 4.4.4 Stable from the openSuSE Repository for KDE 4.4.4 stable as included with 11.3.At first after initial installation Kontact worked and I could access Email, Address Book, Calendar, etc. from the icon bar. Now, Kontact starts, opens the Summary page, but no selections respond, only the Kwin responds to terminate the application, it just seems to hang and has to be killed to terminate. Anyone have similar issue or ideas on what may be causing it? I can start KMail, Kaddressbook, as separate applications and all respond as normal.
View 4 Replies
View Related
Sep 12, 2010
I'm using zenity 2.28.0 in a bash script (under kde4) to select multiple files in a directory. It works fine, but always defaults to showing hidden files. How can I get it to hide hidden files by default?
I know about toggling them on and off with Ctrl-H, but I would prefer not to have to use that. I have my options set so that dolphin and konqueror do not show hidden files by default. I even tried adding shopt -u dotglob to my script. zenity invocation (extracted from a more complex statement): zenity --title "Select Print Files to Delete" --file-selection --multiple
View 5 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
Nov 24, 2010
I have installed in squeeze following some directions the nvidia restricted driver from the unstable repos.
everything worked fine, except that the applied resolution is not kept after every restart or login
View 10 Replies
View Related
Aug 7, 2010
Does anyone else have a resource monitor appearing on their KDE desktop? My is in the upper-right corner, and lies on top of all other windows. I can work with windows beneath it alright, but it is always showing.
The resource monitor is always translucent, and appears to have some sort of vertical "thermometer"-style usage scale on its left side. Beside that are two scrolling graphs. The only text/label appears to be a percentage that matches the thermometer bar, but there is nothing to tell me what resources are being monitored. Regardless, I use other resource monitoring software and I do not want this one on my desktop.
View 8 Replies
View Related
Oct 7, 2010
I just installed F13, and many things have changed (was using FC4!). When I restart my network, my NIC card does not come back up with the correct info, and for the life of me, I can't figure out why. Here is the NIC info for eth2 when things are correct [Replaced the MAC address due to paranoia, but it's correct on my machine]:
Code:
eth2 Link encap:Ethernet HWaddr 00:00:00:00:00:00
inet addr:192.168.2.1 Bcast:192.168.2.255 Mask:255.255.255.0
inet6 addr: fe80::baac:6fff:fe8e:57d2/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
[code]....
Here is the cfg file:
Code:
# Broadcom Corporation NetXtreme BCM5722 Gigabit Ethernet PCI Express
DEVICE=eth2
NAME="System eth2"
[code]....
View 2 Replies
View Related
Feb 24, 2011
I have created a user smith by
Code:
[root@localhost ~]#useradd smith
and then create a group marketing
Code:
[root@localhost ~]#useradd marketing
I want that even if the root will crtae a file or directory it will fall into group marketing.For that purpose I use sticky bit.
Code:
[root@localhost ~]#chmod g+s marketing
cmod:failed to get attributes of marketing' :No such file or directory
View 6 Replies
View Related
