Bug 59719 - EDITING: FOGLIO COPIA/MUOVI
Summary: EDITING: FOGLIO COPIA/MUOVI
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: Other Linux (All)
: medium major
Assignee: Not Assigned
URL: http://contabilmenteag.wix.com/contab...
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-22 16:29 UTC by Michele Ras
Modified: 2013-07-02 21:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michele Ras 2013-01-22 16:29:25 UTC
S.O.: UBUNTU 
system: DELL LAPTOP INSPIRON 6400
DRIVE SYSTEM: EXTERNAL HD MAXTOR 170GB
LIBREOFFICE CALC VERS.:LibreOffice 3.5.4.2 
Numero di build: 350m1(Build:2

PROBLEM (Very important): Sheet copy/Move not executing command and crashed 
all activity of LibreOffice. 
After employ the command and crash, the system call the entire rebuild two spreadshet interested.
If launch 2nd the command for Copy/Move the sheet, after rebuilding the two files,  same problem existing.

Problem description: 

Steps to reproduce:
1. Copy/Move sheet from Sheet at File A
2. Enable immediatly all activity in two spreadsheet
3. LiberOffice skip the two files
4. LiberOffice call for rebuild & correct the two files
5. After rebuilding: sam problem.

Thank's you 

Michele Ras
Genova (Italy)

              
Operating System: Ubuntu
Version: 3.5.4 release
Comment 1 Julien Nabet 2013-01-22 19:13:16 UTC
Several things which could help:
1) Indicate your Ubuntu version and tell if you use Gnome or Kde (you could have tested Kde with Ubuntu instead of using Kubuntu)

2) last LO version is 3.6.4. So even if 3.6.4 isn't proposed on Ubuntu repo or ppa Libreoffice, it could interesting you give a try to a 3.6 LO version.

3) Could you try to retrieve a backtrace (see https://wiki.documentfoundation.org/BugReport#How_to_get_a_backtrace_.28on_Linux.29)?
Comment 2 Michele Ras 2013-01-22 19:52:29 UTC
Dear sir,

Tank's for your help.
My Ubuntu version is: 12.04.1 LTS precise pangolin  Italian language
I have installed LibrOffice 3.6 (Eng Version)

Other Specification for the bug:

The problem is in only one file; the file .ods is created originally in
Microsoft Office Excel 2000Eng and i work it
in my Ubuntu pc by LibrOffice Calc.
The file content >15 sheets and in his existing linkages in Dbase (various
Pivot reports and absolutes refereces) with crossings data's by differents
sheets.
And in his sheet exist one Data filter permanent and various Hidden Columns.

I have improved another sheet (simple compilation example, single sheet),
and with command Move/Copy  the operation is perfectly enable and don't
have this problem.

I think several reasons probably for the bug:
1) Original structure file compiled in MO Excel2000 and not perfectly
correspondant work in the LibrOffice;
    (This same problem is verified in Sun OpenOffice Calc);

2) Data Base & Filter, and/or Hidden Columns presents in the interested
sheet;

I temporary solved these problem whit copy/Paste & re-scription entire
sheet.

Sorry, excuse me for my terrific english language,  because i not study
his, but french.

Best Regards

Michele Ras






2013/1/22 <bugzilla-daemon@freedesktop.org>

>  Julien Nabet <serval2412@yahoo.fr> changed bug 59719<https://bugs.freedesktop.org/show_bug.cgi?id=59719>
>  What Removed Added  Status UNCONFIRMED NEEDINFO  CC   serval2412@yahoo.fr  Ever
> confirmed   1
>
>  *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=59719#c1> on bug
> 59719 <https://bugs.freedesktop.org/show_bug.cgi?id=59719> from Julien
> Nabet <serval2412@yahoo.fr> *
>
> Several things which could help:
> 1) Indicate your Ubuntu version and tell if you use Gnome or Kde (you could
> have tested Kde with Ubuntu instead of using Kubuntu)
>
> 2) last LO version is 3.6.4. So even if 3.6.4 isn't proposed on Ubuntu repo or
> ppa Libreoffice, it could interesting you give a try to a 3.6 LO version.
>
> 3) Could you try to retrieve a backtrace (seehttps://wiki.documentfoundation.org/BugReport#How_to_get_a_backtrace_.28on_Linux.29)?
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 3 Julien Nabet 2013-01-22 20:32:42 UTC
Precision: please do not answer directly from the email automatically sent by Bugzilla but by putting a comment here:
https://bugs.freedesktop.org/show_bug.cgi?id=59719#add_comment

Would it be possible you attach the file to the bugtracker and indicate how to reproduce the crash by giving precise step by step?

(PS: I'm French so if you're stuck because of English, you can write in French and I'll try to translate for others)
Comment 4 Michele Ras 2013-01-23 11:27:31 UTC
Bonjour Mr. Nabet,
je Vous remercie beaucoup pour l'assistance du bug que j'ai relevé dans 
le fichier du LibreOffice calc.
Desolé, mais je ne peux pas envoyer Vous le fichier qui a produit le bug, car il contient
des informations "sensibles" et soumises à les dispositions de la loi italienne pour la "privacy" et la preservation en matière fiscale.
Comme j'ai dit dans mon e-mail, en mauvais anglais, je pense que la problème soit que LibreOffice n'accepte pas la présence des zone avec des filtres Dbase et/ou des functions de rècherche dbase sur des "pivot tables", dans le tableau electronique (sheet) qui doit etre doublé dans un autre fichier similaire.
Dans MO Excel ce probléme n'existe pas, et on peut effectuer l'opération analogue parfaitement,  avec succés, probablement pour des motifs  du compilation interne du programme.
Ou bien, peut etre que le bug depend de la géstion de la mémoire temporelle du systeme.
Dans prochaines jour, avec du temps,  je vais à préparer des fichier, sans informations sensibles, pour vous les envoyer.

Détails:
LibreOffice ver. Versions 3.4 et àpres 3.6.0.4 (Build ID: 932b512) anglais Us 
Gnome: installé

Details des opérations sur le fichier nommé Minicontabilité:
1) Fichier d'origine (conténent n.18 sheet)- sheet nommé Bilan_CEE:
1.1 Filtre Data-Filter-Auto_Filter on sur Ligne 2
1.1.1 Filtre Data-Filter-Auto Filter-Custom: position 0=All ; position 1= <> 0
1.2 Zones des celles -coulonne- avec function GETPIVOTDATA (hidden column)
1.2.1 la Pivot Table liée est dans un différent sheet (nommé Codes_de_Compte) dans le meme fichier
1.3 Zones des celles -coulonne- avec function ISERROR (hidden column)
1.4 Zones des celles -coulonne- avec function IF (hidden column)

2) Command sur sheet nommé Bilan:
2.1 Copy/Move Sheet = Move Sheet
2.2 To document = choisir un autre fichier égual de formules, différent le nom du fichier (Minicontabilité_XX)
2.3 Insert before = Move end position
2.4 New name = est exacte (different name - marquée avec n.ro _2)
2.5 Ok

3) Effect:
3.1 En cliquant su Ok le video sur toutes led deux fichier dévient obscure.
3.2 LibreOffice est bloqué et n'accepte des commands
3.3 LibreOffice n'accepte des commands sur son menu principal (inactif)
3.4 LibreOffice se casse définitivement apres 2-3 sec. et est disparu du desktop

4) Re-ouverture du LibreOffice
4.1 LibreOffice invoque le rebuilding des 2 fichiers qui ètaient ouverts.
4.2 En répondant Oui, il effectue la réprise des 2 fichiers
4.3 Les fichiers sont agibles comme à l'origine
4.4 Si on repete le command du point 2 tiut ça va recommençer. 


Toutes mes salutations les plus distinguées.

Michele Ras
Comment 5 Julien Nabet 2013-01-24 22:01:02 UTC
Michele: I read your last comment, in bug reproduction, you gave a detailed step by step but mixed English and French + other than French or English.
Since you use English words from the interface, it's better you explain in English.
Moreover, try to summarize and give the minimum of steps to reproduce the problem.
Anyway, I'll wait for your attach the file on the bugtracker to give it a try.
Comment 6 Julien Nabet 2013-07-02 21:03:26 UTC
Michele: Following different private mails we had sent each other, I put it as WFM.

For the record, I unzipped the file of Michele and reformat content.xml then had:
line 2 column 26186437 - Warning: <table:table-cell> dropping value "'Complesse|Ratei & Risconti'.BA1" for repeated attribute "table:end-cell-address"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "4.284cm" for repeated attribute "table:end-x"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "0.59cm" for repeated attribute "table:end-y"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "8" for repeated attribute "draw:z-index"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "'Complesse|Ratei & Risconti'.BA2" for repeated attribute "table:end-cell-address"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "4.284cm" for repeated attribute "table:end-x"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "0.294cm" for repeated attribute "table:end-y"
line 2 column 26186437 - Warning: <table:table-cell> dropping value "9" for repeated attribute "draw:z-index"
After fixing these errors, it was possible to open the file.