LinuxQuestions.org - OpenOffice calc - sticky selections in "Paste Special"?

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - OpenOffice calc - sticky selections in "Paste Special"? (https://www.linuxquestions.org/questions/linux-software-2/openoffice-calc-sticky-selections-in-paste-special-859005/)

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 ;)

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.

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

Quote:

Originally Posted by GlennsPref (Post 4241865)

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? :)

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

Quote:

Originally Posted by GlennsPref (Post 4243124)

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.

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

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? :)