I need to convert 4 different formulae, but all are very similar and all are giving the same error in excel. This is one:
Code: Select all
=IF(SUM(J5:J64)=1;"Behind"&T(STYLE("yellowhl"));""&T(STYLE("default")))
Any help would be appreciated!
Code: Select all
=IF(SUM(J5:J64)=1;"Behind"&T(STYLE("yellowhl"));""&T(STYLE("default")))
I was afraid of that. I wasnt finding anything on websearches which made me think there wasnt a comparable function.Villeroy wrote:Excel has stlyes (which nobody uses) but it does not have any STYLE function. Conditional formatting should work though.
Unfortunately opening the file as ODS produces the exact same problem. But its good to know excel will open ODS files.RusselB wrote:You could save yourself a lot of time and trouble by finding out what version of Excel they are using.
If it is 2000 or later (if memory serves), then you could just save the file(s) is Open Document Format (.ods for spreadsheets) and Excel will open the files.
The the only time you'd need to worry is if Excel didn't have an equivalent function, irrelevant as to the name.
I think thats the best bet at this moment. No one uses excel for any feature other than very basic text based cell edits (no formulae, reference links, etc) except me and I prefer AOO anyway.RusselB wrote:Or, imo better yet, convince them to switch to Open/LibreOffice from Calc (maybe point out that they'd be saving money, as Open/LibreOffice is free, and Excel is not).
Yes. LO has more function, better interfaces to MS function and to MS file formats and is under active development. Stick to the stable, older version and even so, expect annoying bugs. LO release testing doesn't seem to be as good as it could be.ba301 wrote:Do you mean LO is just better than AOO?
IIRC, that is a known AOO bug when working with large files. Search on bad allocation errorba301 wrote:... crashing on "bad allocation" whenever I do any heavy (or even minor) reference link work.