[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

cmfe...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

cmfe...@gmail.com changed:

   What|Removed |Added

 OS|Windows (All)   |Linux (All)

--- Comment #8 from cmfe...@gmail.com ---
Hi 
I use LibreOffice 5.2.6.2 on Debian Linux. 
When i try make a calculation like an sum, the cell with the total showed only
the formula.

Anybody know if there are the patch to resolved this error?.
Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

--- Comment #7 from Gerrit  ---
Jacques,

Thanks for your explanation about procedures here. I am new to it.

If you think it is useful, I will file a new report. Personally I think either
the omission of a shortcutkey or the accidental placing of Ctrl in the menu
after Show formulas is a very minor issue.

I use Windows 10 Home, version 1607, build 14393.693

Let me know what you prefer...

Sincerely,

Gerrit

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

Jacques Guilleron  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #6 from Jacques Guilleron  ---
Thanks Gerrit,

Which precise Windows OS are you using? This would be useful to mention it.
Usage here is:
one issue per report.
So a separate report is needful for the shortcut.

On French lists, no user confirmed this issue, under Windows 7 or Windows 10.
But for the shortcut Key:
On Linux, shortcut "Ctrl+`",available by "Ctrl+AltGr+7" is visible and works.
On all Windows Os, only "Ctrl" is visible, and shortcut isn't available into
Tools > Custumize... > Keyboard at Category Fonctions: View
and Function: Show Formula.
Ctrl+Alt+7 is not set as Shortcut Key, nor "Show Formula".

Do you write the new report?

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

--- Comment #5 from Gerrit  ---
Bonjour Jacques! / m.a.riosv

Je vous remercie beaucoup!
Je m'excuse parce que je ne parle pas Francais tres bien... 
Alors... En Anglais:

I can confirm that your solution works. 

Still open: no shortcutkey mentioned in the View-menu after 'Show formula'.
Only mentioned: 'Ctrl'.  Maybe something for the next update.

As far as I am concerned the case is closed.

Thank you!

Gerrit

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

Jacques Guilleron  changed:

   What|Removed |Added

 CC||guillero...@aol.com

--- Comment #4 from Jacques Guilleron  ---
Hi Gerrit, m.a.riosv,

With:
A1, “1”. 
A2, “2”. 
A3: “= A1+A2”

and also with your Test file, I reproduce.
LO 5.3.0.3 Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur
de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: CL
doesn’t display result by default and keeps formula displaying.

Untick Show Formula in View menu changes this behaviour only during the
cession.
To get the right behavior, ie result displaying, open:
Tools > Options > LibreOffice > Advanced 
Open Expert Configuration

Open org.openoffice.Office.Calc
Content
Display
And into:

Preference NameProperty   TypeValue
DisplayFormulaboolean true

Change Value to false.

If Show Formula was unticked, you will find the usual behaviour after restart.
Do you confirm it ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

--- Comment #3 from Gerrit  ---
Created attachment 131038
  --> https://bugs.documentfoundation.org/attachment.cgi?id=131038=edit
Please find a zip file attached containing screendumps showing the problem,
version info plus a Test file.ods.

Thank you for responding so quickly!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

--- Comment #2 from m.a.riosv  ---
Please @Gerrit, answer and attach the document here, not by mail to me, thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105861] Formulas shown in cells instead of results of formulas

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105861

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv  ---
Can you attach a sample file here?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs