https://bugs.documentfoundation.org/show_bug.cgi?id=159964
Bug ID: 159964
Summary: If open docs without Function in Module or Open MS
office docs
Product: LibreOffice
Version: 7.6.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have User Function "FUN" with in cell sintax "=FUN(celladdress)". (VBA)
I spend some times to find many troubles when integrated it.
This function is not available in MS and Libre Offices.
____________
Instruction:
Make a library, make a module, put code in module. - Drivel!
************
I put code to Standard library and miracle!
But troubles are coming next...
original file in .xlsx
When open original file without function code in Standard Module, all function
names in used cells, LO changed from "FUN" to "[1]!FUN"
and all formulas with FUN function has crashed.
If u thought everything was fine with the .ods, u are mistaken!
When open .ods file without function code in Standard Module (first user
reaction - clik and open), all function names in used cells, LO changed from
"FUN" to "fun"
and all formulas with FUN function has crashed.
OK! Maybe copy-paste none formulas with FUN function Data make my day?
"OK?-OK..." - say LO and crash autoformatting rules...
***LO crash formatting options when load xlsx file and seve it to ods, but work
true and put correct colour to cells without big changes. If New Data dropdown
out of old Data range. Colour schema has change to crashed state rules. And
don't logic! some cells in red, some cells in yellow, but original rules put it
in one colour - hilight green!
And last... U are understood. All users if they need to open my file for
reading are fall down to hell.
* First circle in hell like MS. Find option "add" in menu and +2 trouble from
LO-hell (open second window one on one like previous, WHY?! and dont have
stendard folder for library(!)) and finish like MS - select the file +trouble
from LO-hell (2 files in target folder, WHY?!) //Add-in's different song/
* Next level in hell (MS finished this procedure with three mouse clicks.
Select, ok, ok.). Move Module from User library to Standard library. Small,
light break before the next hell lap.
* And Final lap. I have already written it. Briefly: "FUN to fun" or "FUN" to
"[1]!FUN" reverse changing.
That's all folks!
Steps to Reproduce:
1.make a function in MS excel, worked like formulas ("=function(celladdress)")
2.make a list with some thouthend working formulas witn this function and add
some autoformatting rules
3.save this file
4.open this file in LO
5.follow previous instruction in Description to add function and repeat all
troubles
Actual Results:
instruction in Description
Expected Results:
Results in Description
Reproducible: Always
User Profile Reset: Yes
Additional Info:
in Description
It is fresh profile, first start. Don't need reset.
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
