Skip to main content

Cell features

Yuque Sheet featureSub-featureRestoration supportedNotes
Text
Number
Percent
CurrencyUSD
CNY
EUR
GBP
Date2018-01-08
2018/01/08
01/08/2018
2018.01.08
2018-01
01/08
2018
January 8, 2018 (Chinese format)
August 2018 (Chinese format)
January 8 (Chinese format)
January
Monday
January 8, 2018✅ PartialPartial support means: English will be converted to the local system language.
January✅ Partial
Monday✅ Partial
Time13:00:00
1:00:00 PM✅ Partial
13:00
1:00 PM✅ Partial
Date & Time2018-01-08 13:00:00
2018/01/08 13:00:00
2018/01/08 1:00 PM
Increase/decrease decimal places
Font size
Bold
Italic
Strikethrough
Underline
Font color
Background color
Checkbox
Dropdown List
Image
Link
Attachment✅ PartialAttachments will be converted into links.
Alias
Alignment
Vertical alignment
Text wrap
Custom borders
Diagonal border
Merge Cells
Freeze
Protected ranges
Hide worksheet
Worksheet color

Chart features

Yuque Sheet featureSub-featureRestoration supportedNotes
Column
Color
Layout
Custom
Stacked Column
Color
Layout
Custom
Bar
Color
Layout
Custom
Stacked Bar
Color
Layout
Custom
Line
Color
Layout
Custom
Smooth Line✅ PartialWill be downgraded to a standard “Line” chart.
Pie
Color
Layout
Custom
Doughnut
ColorWill be reset to the default doughnut chart color in DingTalk Docs.
Layout
Custom

Formula features

Because of the large number of formulas, if any formula behaves abnormally, contact the DingTalk Docs Employee ID through DingTalk for investigation.The table below lists only the 10 most commonly used formulas.
Yuque Sheet featureRestoration supportedNotes
SUM
IF
LOOKUP
VLOOKUP
MATCH
CHOOSE
DATE
DAYS
FIND
INDEX

Filter features

Yuque Sheet featureSub-featureRestoration supportedNotes
Filter by Content
Filter by colorBy cell background color
By Text Color
Filter by conditionNumerical: equals
Numerical: not equal to
Numerical: greater than
Numerical: greater than or equal to
Numerical: less than
Numerical: less than or equal to
Text: starts with
Text: does not start with
Text: ends with
Text: does not end with
Text: contains
Text: does not contain
Date: yesterday
Date: today
Date: tomorrow
Date: last 7 days
Date: last week
Date: this week
Date: next week
Date: last month
Date: this month
Date: next month
Duplicate values
Unique values
Special values
Blank values
Multi-condition filterAND
OR

Conditional Formatting features

Yuque Sheet featureSub-featureRestoration supportedNotes
By conditionNumerical equals
Numerical not equal to
Numerical greater than
Numerical greater than or equal to
Numerical less than
Numerical less than or equal to
Text starts with
Text does not start withThe following are not supported:
Text ends with
Text does not end with
Text contains
Text does not contain
Date yesterdayThe following are not supported:
Date today
Date tomorrow
Date last 7 days
Date last week
Date this week
Date next week
Date last month
Date this month
Date next month
Duplicate values
Unique values
Special values
Blank values
Multi-conditionAND
OR
Format