OpenOffice calc

Paraply · 01-27-2011, 07:18 AM

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

Paraply · 01-29-2011, 08:22 AM

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.

GlennsPref · 01-29-2011, 05:42 PM

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

Paraply · 01-31-2011, 12:58 AM

Quote:

Originally Posted by GlennsPref

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?

GlennsPref · 01-31-2011, 01:58 AM

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

Paraply · 02-01-2011, 06:41 AM

Quote:

Originally Posted by GlennsPref

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.

GlennsPref · 02-01-2011, 07:26 PM

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

Paraply · 02-02-2011, 06:31 AM

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?