[Bug] 1. The last 2-3 Digits of ID Number (18 digit number) Change to 0 When Copied 2. Time text copy English: Time Text Defaults to Time Format When Copied

[AKA-LinCoder]

Before you submit this issue, have you checked the following

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

Affected packages and versions

"@univerjs/presets": "^0.5.2",

Reproduction link

Expected behavior

1.身份证号问题(ID Number issue):
复制18位身份证号到目标单元格或输入框后，所有数字保持原样，不应自动将后两到三位数字变成0。
English: When copying an 18-digit ID number into a target cell or input field, all digits should remain unchanged, and the last 2-3 digits should not be automatically converted to 0.
2.时间文本问题(Time text issue):
从文本格式单元格复制时间文本后，粘贴到目标单元格时，文本格式应保持不变，不应自动转换为时间格式。
English: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format.

Actual behavior

1.身份证号问题(ID Number issue):
复制18位身份证号到目标单元格或输入框后，后两到三位数字被自动四舍五入为0。
English: When copying an 18-digit ID number, the last 2-3 digits are automatically rounded to 0.
2.时间文本问题(Time text issue):
从文本格式单元格复制时间文本后，粘贴到目标单元格时，格式自动变为时间格式。
English: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell.

System information

No response

[univer-bot]

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

Origin Title: [Bug] 1.身份证号(18位数字)复制后后两到三位变成0的问题 English: Last 2-3 Digits of ID Number(18 digit number) Change to 0 When Copied 2. 时间文本复制后格式变为时间格式的问题 English: Time Text Defaults to Time Format When Copied

Title: [Bug] 1. The last 2-3 Digits of ID Number (18 digit number) Change to 0 When Copied 2. Time text copy English: Time Text Defaults to Time Format When Copied

---

Before you submit this issue, have you checked the following

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

Affected packages and versions

"@univerjs/presets": "^0.5.2",

Reproduction link

Expected behavior

1.ID Number issue:
After copying the 18-digit ID number to the target cell or input box, all numbers remain intact and the last two to three digits should not automatically change to 0.
English: When copying an 18-digit ID number into a target cell or input field, all digits should remain unchanged, and the last 2-3 digits should not be automatically converted to 0.
2. Time text issue:
After copying time text from a text format cell, the text format should remain unchanged when pasted into the target cell and should not be automatically converted to time format.
English: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format.

Actual behavior

1.ID Number issue:
After copying the 18-digit ID number to the target cell or input box, the last two to three digits are automatically rounded to 0.
English: When copying an 18-digit ID number, the last 2-3 digits are automatically rounded to 0.
2. Time text issue:
After copying time text from a text format cell, the format automatically changes to time format when pasted into the target cell.
English: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell.

System information

No response

[AKA-LinCoder]

nfg

[jikkai]

This user has some questions about usage. Could we add some basic explanations to the documentation? @ybzky

[ybzky]

Before you submit this issue, have you checked the following

在提交此问题之前，您是否检查了以下内容

• Is this really a problem?这真的是个问题吗？
• I have searched the Github Issues for similar issues, but did not find anything. 我在 Github Issues 上搜索过类似的问题，但没有找到任何东西。

Affected packages and versions 受影响的软件包和版本

"@univerjs/presets": "^0.5.2",

Reproduction link

Expected behavior

1.身份证号问题(ID Number issue): 复制18位身份证号到目标单元格或输入框后，所有数字保持原样，不应自动将后两到三位数字变成0。 English: When copying an 18-digit ID number into a target cell or input field, all digits should remain unchanged, and the last 2-3 digits should not be automatically converted to 0.中文: 将 18 位 ID 号码复制到目标单元格或输入字段时，所有数字应保持不变，并且最后 2-3 位不应自动转换为 0。 2.时间文本问题(Time text issue): 从文本格式单元格复制时间文本后，粘贴到目标单元格时，文本格式应保持不变，不应自动转换为时间格式。 English: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format.中文： 从文本格式的单元格复制时间文本时，粘贴到目标单元格时应保留文本格式，并且不应自动转换为时间格式。

Actual behavior

1.身份证号问题(ID Number issue): 复制18位身份证号到目标单元格或输入框后，后两到三位数字被自动四舍五入为0。 English: When copying an 18-digit ID number, the last 2-3 digits are automatically rounded to 0.中文：复制 18 位身份证号码时，后 2-3 位自动四舍五入为 0。 2.时间文本问题(Time text issue): 从文本格式单元格复制时间文本后，粘贴到目标单元格时，格式自动变为时间格式。 English: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell.中文: 从文本格式的单元格复制时间文本时，它会自动更改为目标单元格中​​的时间格式。

System information 系统信息

No response

You can first set the number format of the target cell to text

[univer-bot]

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

Before you submit this issue, have you checked the following

Before submitting this issue, did you check the following

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

Affected packages and versions Affected packages and versions

"@univerjs/presets": "^0.5.2",

Reproduction link

Expected behavior

1. ID Number issue: After copying the 18-digit ID number to the target cell or input box, all numbers remain the same and the last two to three digits should not automatically change to 0. English: When copying an 18-digit ID number into a target cell or input field, all digits should remain unchanged, and the last 2-3 digits should not be automatically converted to 0.中文: Copying an 18-digit ID number into a target cell or input field When entering a format or input field, all numbers should remain unchanged and the last 2-3 digits should not automatically convert to 0. 2. Time text issue: After copying time text from a text format cell, when pasting it into the target cell, the text format should remain unchanged and should not be automatically converted to time format. English: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format.中文: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format.中文: When copying time text from a text-formatted cell, it should retain the text format when pasted into the target cell and should not automatically convert to time format. Cells should retain text formatting and should not be automatically converted to time format.

Actual behavior

1. ID Number issue: After copying the 18-digit ID number to the target cell or input box, the last two to three digits are automatically rounded to 0. English: When copying an 18-digit ID number, the last 2-3 digits are automatically rounded to 0. Chinese: When copying an 18-digit ID number, the last 2-3 digits are automatically rounded to 0. 2. Time text issue: After copying time text from a text format cell and pasting it into the target cell, the format automatically changes to time format. English: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell.中文: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell.中文: When copying time text from a text-formatted cell, it automatically changes to a time format in the target cell. Time format.

System information System information

No response

You can first set the number format of the target cell to text