Created attachment 54818 [details]
odt-sheet with embedded calc
open the appended writer-sheet.
click into the embedded calc-sheet.
try to input an number in one of the cells.
Normally the input is accepted, in this case no change.
tested with version 3.5 beta from daily 2011-12-25-20-32-07
win win7 64
seems to depend upon formatting:
format all to number: the input appears.
perhaps "standard" input is undefined??
Happening in LODev 3.5.0 beta2. However, if I do ctrl-A, right click to format, and format all as any number format, it works.
I see this also on Linux with 3.5.0-beta2-x86_64 build.
To be more precise. I could write a text into a cell but when I press enter, the text disappear.
I am not sure of the bug is in Writer or Calc => I rather add both experts into CC. Also I am going to add this to most annoying bugs.
[Reproducible] with reporter's sample and own sample documents and Parallel Dev-Installation of "LibreOffice 3.5.0 Beta2- WIN7 Home Premium (64bit) German UI [Build-ID : 8589e48-760cc4d-f39cf3d-1b2857e-60db978].
Even a CALC object created in WRITER by 'copy/paste special - calc' from a CALC will loose it's contents integrity when you try to edit it.
I can confirm observation that changing cell format from "Standard" to something explicit seems to heal the problem.
There are lots of strange effects trying to edit CALC OLE objects, because it's easy to reproduce I will not repeat all observations.
I also tested WRITER and DRAW OLE objects in CALC, no problem.
Problem also visible with CALC objects in DRAW, currently I see this as a CALC problem (further investigations might lead to a different result).
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
[Reproducible] with Server installation of MSVC Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 485138f-e92bf75-4c1bcb5]" Win-x86@6 – 2011-12-06_21:37:02)
Ir seems prolbem began somehwere between 11-11-28 and 2011-12-06
Worked fine with Server installation of MSVC Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: a653e50-1f92ab1-3bd0388]" Win-x86@6 - 111128)
I'll take a look.
I got it. Fixing the pagination in print preview and syncing selected sheets before and after the print preview ended up affecting this functionality. Very interesting.
Fixed on libreoffice-3-5 and master.
The fix will be in RC1.
Version LOdev 3.5 beta3
S.O. Ubuntu 10.04 and Debian Testing.
Leaflet 'writer' with inserted OLE object (Calc).
Opens the object Calc to modify the cells.
No change is possible because the sheet Calc is protected.
Even if 'format cells' eliminates the tick on 'protection' remains the fact
that it is impossible to modify any cell. In my similar models very old (made
with OOo 2.x in years 2003, 2004 or 2005) the elimination of protection works
very well and the cells are modified and saved correctly.
@Felice: please, read more carefully what it written at the end of comment #8. The fix will be in RC1, it is not in beta-3.
I tested on my own build of LO 3.5.0 beta3+ and it works as expected.
Setting to fixed back.
Best regards. JBF
(In reply to comment #10)
> @Felice: please, read more carefully what it written at the end of comment #8.
> The fix will be in RC1, it is not in beta-3.
> I tested on my own build of LO 3.5.0 beta3+ and it works as expected.
> Setting to fixed back.
> Best regards. JBF
thanks and sorry for the distraction, greetings ... Felice