https://bugs.freedesktop.org/show_bug.cgi?id=45370

Rainer Bielefeld <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         OS/Version|All                         |Windows (All)
           Severity|normal                      |major
         AssignedTo|[email protected] |[email protected]
                   |desktop.org                 |
                 CC|                            |LibreOffice@bielefeldundbus
                   |                            |s.de
            Summary|EDITING: some formulae fail |EDITING: Calculated cell
                   |to update when data is      |contents not updated after
                   |deleted                     |copy - paste - delete of
                   |                            |source values
            Version|LibO 3.5.0 RC2              |LibO Master

--- Comment #3 from Rainer Bielefeld <[email protected]> 
2012-01-29 11:05:17 PST ---
[Reproducible] with "LibreOffice 3.5.0 RC2 German UI/Locale [Build-ID:
e371a95-bf68a13-5a1aa2b-d3c1ae9-b938258] on German WIN7 Home Premium (64bit)  

Very old problem, I also see it in a Master from July 2011

But woks fine with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1
(Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit) 

Problem is not limited to particular formulas, I also see it in a new Document
"mysample10.ods" with simple "=A11+B11". The only condition is order of actions
'Copy -> Paste to empty cells -> Delete'

Steps how to reproduce with "mysample10.ods":
1) open document
2) Highlight cells A1:B10 and copy
3) Place cursor on A11 and paste
   > C11 ... C20 shows values
4) Press <Del> to delete still highlighted A11:B20
   Expected: values C11:C20 become 0
   Actual: values stay

Menu 'Options -> Cell Contents -> Update' will not work
Toggling any checkbox in menu 'Tools -> Options -> Calc -> Calculate -> Input
Settings' will make the values change, after a new paste - delete a new
checkbox toggle will be necessary to update calculated values.

Step 4 works as expected if A11:B20 were not empty before you start the test (I
checked with all "1").

That's serious.

I am pretty sure that this one has the same roots like "Bug 44143 - formula's
that use data from pivot table don't update with the pivot table"

@john.pratt
Good shot!
What's your OS?

@Kohei:
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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to