LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 01-27-2011, 08:18 AM   #1
Paraply
Member
 
Registered: Jun 2007
Posts: 53

Rep: Reputation: 15
Thumbs down OpenOffice calc - sticky selections in "Paste Special"?


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. If anyone has experiences with LibreOffice, I'm all ears
 
Old 01-29-2011, 09:22 AM   #2
Paraply
Member
 
Registered: Jun 2007
Posts: 53

Original Poster
Rep: Reputation: 15
Thanks for the feedback. Meanwhile I've tried LibreOffice. It suffers from the same regressions as OpenOffice, but worse: it does'nt even handle OpenOffice documents correctly. Draw your own conclusions.
 
Old 01-29-2011, 06:42 PM   #3
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Distribution: Mageia Studio-13.37 Kubuntu.
Posts: 3,325
Blog Entries: 33

Rep: Reputation: 199Reputation: 199
Hi, I wonder if you could hack these files, particular

/home/glenn/.ooo3/user/registry/data/org/openoffice/Office/calc.xcu

Code:
<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlns:oor="http://openoffice.org/2001/registry" xmlns:xs="http://www.w3.org/2001/XMLSchema" oor:name="Calc" oor:package="org.openoffice.Office">
 <node oor:name="Dialogs">
  <node oor:name="CSVImport">
   <prop oor:name="CharSet" oor:type="xs:int">
    <value>64</value>
   </prop>
   <prop oor:name="DetectSpecialNumbers" oor:type="xs:boolean">
    <value>false</value>
   </prop>
   <prop oor:name="Separators" oor:type="xs:string">
    <value>,</value>
   </prop>
  </node>
 </node>
</oor:component-data>
Just a guess, regards Glenn
 
Old 01-31-2011, 01:58 AM   #4
Paraply
Member
 
Registered: Jun 2007
Posts: 53

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by GlennsPref View Post
Just a guess, regards Glenn
Thanks a lot for the constructive proposal!
I appended your code to Calc.xcu as follows:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<oor:component-data xmlns:oor="http://openoffice.org/2001/registry" xmlns:xs="http://www.w3.org/2001/XMLSchema" oor:name="Calc" oor:package="org.openoffice.Office">
 <node oor:name="Input">
  <prop oor:name="AutoInput" oor:type="xs:boolean">
   <value>false</value>
  </prop>
  <prop oor:name="LastFunctions" oor:type="oor:int-list">
   <value>6 224 327 223 286 287 285 283 213 334</value>
  </prop>
 </node>
 <node oor:name="SortList">
  <prop oor:name="List" oor:type="oor:string-list">
   <value>ma.,ti.,on.,to.,fr.,lø.,sø. mandag,tirsdag,onsdag,torsdag,fredag,lørdag,søndag jan.,feb.,mars,april,mai,juni,juli,aug.,sep.,okt.,nov.,des. januar,februar,mars,april,mai,juni,juli,august,september,oktober,november,desember</value>
  </prop>
 </node>
 <node oor:name="Content">
  <node oor:name="Display">
   <prop oor:name="Anchor" oor:type="xs:boolean">
    <value>false</value>
   </prop>
  </node>
 </node>
 <node oor:name="Dialogs">
  <node oor:name="CSVImport">
   <prop oor:name="CharSet" oor:type="xs:int">
    <value>64</value>
   </prop>
   <prop oor:name="DetectSpecialNumbers" oor:type="xs:boolean">
    <value>false</value>
   </prop>
   <prop oor:name="Separators" oor:type="xs:string">
    <value>,</value>
   </prop>
  </node>
 </node>
</oor:component-data>
I have noticed no change in behaviour. Does it work on your system? If so, what am I doing wrong?
 
Old 01-31-2011, 02:58 AM   #5
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Distribution: Mageia Studio-13.37 Kubuntu.
Posts: 3,325
Blog Entries: 33

Rep: Reputation: 199Reputation: 199
Hi,

N0, it was just a guess,

the files may also be configured from a primary system file at program initialisation,

I have 2 here as well...
Code:
/usr/lib64/ooo/basis3.2/share/registry/data/org/openoffice/Office/Calc.xcu
/usr/lib64/ooo/basis3.2/share/registry/schema/org/openoffice/Office/Calc.xcs
It's possible that it has nothing to do with it.

Regards Glenn
 
Old 02-01-2011, 07:41 AM   #6
Paraply
Member
 
Registered: Jun 2007
Posts: 53

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by GlennsPref View Post
Hi,

N0, it was just a guess,
(...)
It's possible that it has nothing to do with it.

Regards Glenn
Thank you for your efforts!
As noted above, I've found several regressions in v3.3.0. The real show-stopper was when I discovered this morning that a certain combination of formatting/function no longer worked as expected/before. Makes me wonder if the developers ever try their products at all. So I have gone back to v3.2.1. It meets my humble requirements

Thanks again, Glenn.
 
Old 02-01-2011, 08:26 PM   #7
GlennsPref
Senior Member
 
Registered: Apr 2004
Location: Brisbane, Australia
Distribution: Mageia Studio-13.37 Kubuntu.
Posts: 3,325
Blog Entries: 33

Rep: Reputation: 199Reputation: 199
I'm still wondering if it is an omission, in the new version.

Have you been able to compare (kdiff, kdiff3) the files I mentioned before. edit, I mean between the different ooo vers. ;-)

kdiff has a merge function... But I haven't tried it.

Are the files in your ~/.ooo folder write-able by the program as well as the user, check your groups.


My situation was different.
I had a huge problem for almost a year with disappearing menu and icon buttons.

I ended up writing a script to do the one simple but time consuming task I needed to get done, usually with ooo calc.

I didn't find a solution for that, either. But they all work fine on my latest update (3.2.0).

If it ain't broke....don't try to fix it.

Regards Glenn
 
Old 02-02-2011, 07:31 AM   #8
Paraply
Member
 
Registered: Jun 2007
Posts: 53

Original Poster
Rep: Reputation: 15
Good ideas and advice. I will keep this thread for when I have more time, inclination, not to mention Linux skill, to have a closer look. Then again, perhaps I'm simply being stung by my splendid Arch Linux rolling/early adoption policy?
 
  


Reply

Tags
openoffice.org


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is "sticky bit mode" , "SUID" , "SGID" augustus123 Linux - General 10 08-03-2012 05:40 AM
[SOLVED] OpenOffice Calc question - copy and paste an image filename only BobNutfield Linux - General 2 09-20-2010 05:46 PM
"substraction" and "division" function in OpenOffice Calc mac1234mac Linux - Software 7 12-03-2009 07:36 AM
Set the status of "purge" packages - dpkg --get-selections kushalkoolwal Debian 7 01-09-2009 12:48 PM
How do i "copy" one bios and "paste" it onto another identical machine Yerp Linux - Hardware 2 01-10-2007 09:31 PM


All times are GMT -5. The time now is 12:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration