Update to 7.5.9.2 [since update I have these problems]

English
#1

W10pro / version 7.5.9.2 (X86_64) dutch/nederlands / system with 2 monitors

Since update to 7.5.9.2 I have these problems:

  • toolbars keep on disappearing upon restart
  • window keeps on opening on the wrong monitor (Calc / writer / …)
  • in formulas like this
    =SOM(Data.BM13:BM100000)+STIJL(ALS(HUIDIG()>=$K6;"Excel_CondFormat_1_4_1";""))
    the Exel_CondFormat_1_4_1 sometimes works, sometimes it doesn’t. Can’t figure out why.
  • when closing a worksheet the one letter shortcuts for ‘save-discard-cancel’ don’t work any more

EDIT: upgrade to 7.6.4 same problems // downgrade back to 7.3.7.2 solves all of the above

#2

Please upload an ODF format sample file here.

#3

sorry, I can’t upload the actual file, it contains confidential info and it’s linked to multiple other files on my fileserver. Time permitting I’ll try to make a dummy file for testing in a few days.

#4

Can LibreOffice write to disk? You might need to add soffice.bin , C:\Program Files\LibreOffice\program\soffice.bin , to the allowed list in your anti-ransome software

#5

Then - at least - use English function names in the English part of this Ask site.

STIJL(ALS(HUIDIG()>=$K6;“Excel_CondFormat_1_4_1”;"")

I suppose that not exist any Cell Style with name “” (empty string) in your file. Use the “Default” or other Style in the case “False”.

#6

Any hint how I can find the correct translation? (I hate using an other version than the english one but I’m not alone at the office so not really my choice)

#7

You can switch to English function names temporarly (the language of the user interface will not be changed):
Tools - Options - LibreOffice Calc - Formula - Use English function names (Check in this option)

1 Like
#8

OK thanks, will stick to the English function names, translating them to my own language seems unnatural anyway.
This is the formula that doesn’t always work:

=SUM(Data.IR13:IR100000)+STYLE(IF(CURRENT()>=$K4;“Excel_CondFormat_1_4_1”;""))

#9

Specify the other cell style to be applied when the if-condition is False.
=SUM(Data.IR13:IR100000) +STYLE(IF(CURRENT()>=$K4;"Excel_CondFormat_1_4_1";"Default"))

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.