[Feature] More Engineering Formulas

[wpxp123456]

Initial checklist

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Problem

How to contribute formulas

Solution

Engineering formulas

• BESSELI
• BESSELJ
• BESSELK
• BESSELY
• BIN2DEC
• BIN2HEX
• BIN2OCT
• BITAND
• BITLSHIFT
• BITOR
• BITRSHIFT
• BITXOR
• COMPLEX
• CONVERT
• DEC2BIN
• DEC2HEX
• DEC2OCT
• DELTA
• ERF
• ERF.PRECISE
• ERFC
• ERFC.PRECISE
• HEX2BIN
• HEX2DEC
• HEX2OCT
• OCT2BIN
• OCT2DEC
• OCT2HEX

[zhaolixin7]

@wpxp123456 贝塞尔函数2、引用单元格为空时结果和excel不一样等于#num

2、besselj参数为0、true

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

@wpxp123456 Bessel function 2. When the referenced cell is empty, the result is different from excel and is equal to #num

2. The besselj parameter is 0, true

[zhaolixin7]

BIN2HEX 1、参数为（1000000，100000）时表格白屏
2024_8_10 14_54_26 commands.json
2024_8_10 14_54_26 video.webm
2、参数为（10000,10000）时结果计算错误
2024_8_10 15_45_51 commands.json
2024_8_10 15_45_51 video.webm

3、空参数报#num

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

BIN2HEX 1. The table displays a white screen when the parameters are (1000000, 100000).
2024_8_10 14_54_26 commands.json
2024_8_10 14_54_26 video.webm
2. The result calculation is wrong when the parameter is (10000,10000)
2024_8_10 15_45_51 commands.json
2024_8_10 15_45_51 video.webm

3. Empty parameters report #num

[zhaolixin7]

BIN2OCT 1、直接输入=INDIRECT(1000000,12312123)表格卡死
2024_8_10 16_28_06 video.webm
2、空参数报#num

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

BIN2OCT 1. Direct input =INDIRECT(1000000,12312123) form is stuck
2024_8_10 16_28_06 video.webm
2. Empty parameters report #num

[zhaolixin7]

BITLSHIFT 1、引用单元格，单元格数字都大于26时计算和excel、Google不一样

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

BITLSHIFT 1. When referencing cells, the calculation is different from excel and Google when the cell numbers are greater than 26.

[zhaolixin7]

Bitor 1、参数超过10位时计算结果错误

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Bitor 1. The calculation result is wrong when the parameters exceed 10 digits.

[zhaolixin7]

@wpxp123456 erfc、ERFC.PRECISE
1、不同参数和其他产品结果有点不太一样（wps\google\excel）

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

@wpxp123456 erfc、ERFC.PRECISE

1. The results of different parameters are a little different from other products (wps\google\excel)
   

[zhaolixin7]

HEX2BIN 、HEX2OCT 1、空参数报#num

2、HEX2BIN计算结果错误、设置格式后结果会变，结果和其他产品也不一样
2024_8_12 19_29_47 commands.json
2024_8_12 19_29_47 video.webm


3、HEX2BIN白屏 公式=HEX2BIN（3214412，3214413）
2024_8_12 20_20_37 commands.json
2024_8_12 20_20_37 video.webm

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

HEX2BIN, HEX2OCT 1. Empty parameters report #num

2. The calculation result of HEX2BIN is wrong. The result will change after setting the format. The result is also different from other products.
   2024_8_12 19_29_47 commands.json
   2024_8_12 19_29_47 video.webm
   
   
3. HEX2BIN white screen formula =HEX2BIN (3214412, 3214413)
   2024_8_12 20_20_37 commands.json
   2024_8_12 20_20_37 video.webm

[zhaolixin7]

OCT2BIN 空参数报#num

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

OCT2BIN empty parameter report #num