데이터

ν˜„μž¬ μ‹œνŠΈμ˜ 데이터λ₯Ό νŽΈμ§‘ν•˜λ €λ©΄ 데이터 메뉴 λͺ…령을 μ‚¬μš©ν•©λ‹ˆλ‹€. λ²”μœ„ 지정, 데이터 μ •λ ¬ 및 필터링, κ²°κ³Ό 계산, 데이터 κ°œμš”, 데이터 파일럿 μ—΄κΈ° 등을 μˆ˜ν–‰ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

Sort

μ§€μ •ν•œ 쑰건에 따라 μ„ νƒν•œ 행을 μ •λ ¬ν•©λ‹ˆλ‹€. LibreOffice은(λŠ”) λ°μ΄ν„°λ² μ΄μŠ€ λ²”μœ„λ₯Ό μžλ™μœΌλ‘œ 인식 및 μ„ νƒν•©λ‹ˆλ‹€.

Sort Ascending

Sorts the data of the selected field or cell range in ascending order. Text fields are sorted alphabetically, numerical fields are sorted by number.

Sort Descending

Sorts the data of the selected field or cell range in descending order. Text fields are sorted alphabetically, number fields are sorted by number.

AutoFilter

μ„ νƒν•œ μ…€ λ²”μœ„λ₯Ό μžλ™μœΌλ‘œ ν•„ν„°λ§ν•˜κ³ , ν‘œμ‹œν•  ν•­λͺ©μ„ 선택할 수 μžˆλŠ” 단일 ν–‰ λͺ©λ‘ μƒμžλ₯Ό λ§Œλ“­λ‹ˆλ‹€.

More Filters

데이터λ₯Ό ν•„ν„°ν•˜λŠ” λͺ…령을 λ³΄μ—¬μ€λ‹ˆλ‹€.

Define Range

μ‹œνŠΈμ—μ„œ μ„ νƒν•œ 셀에 κΈ°μ΄ˆν•˜μ—¬ λ°μ΄ν„°λ² μ΄μŠ€ λ²”μœ„λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€.

Select Range

데이터 - λ²”μœ„ μ§€μ •μ—μ„œ μ§€μ •ν•œ λ°μ΄ν„°λ² μ΄μŠ€ λ²”μœ„λ₯Ό μ„ νƒν•©λ‹ˆλ‹€.

λ²”μœ„ μƒˆλ‘œ κ³ μΉ¨

Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.

μš°μ„  μˆœμœ„ ν…Œμ΄λΈ”

Opens a submenu to create or edit a pivot table. A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.

Calculate

Commands to calculate formula cells.

Validity

μ„ νƒν•œ μ…€ λ˜λŠ” μ…€ λ²”μœ„μ— λŒ€ν•΄ μœ νš¨ν•œ 데이터λ₯Ό μ§€μ •ν•©λ‹ˆλ‹€.

Subtotals

μ„ νƒν•œ 열에 λŒ€ν•œ 뢀뢄합을 κ³„μ‚°ν•©λ‹ˆλ‹€. LibreOfficeμ—μ„œλŠ” SUM ν•¨μˆ˜λ₯Ό μ‚¬μš©ν•˜μ—¬ λ ˆμ΄λΈ”μ΄ μ§€μ •λœ λ²”μœ„μ˜ λΆ€λΆ„ν•©κ³Ό 총합계λ₯Ό μžλ™μœΌλ‘œ κ³„μ‚°ν•©λ‹ˆλ‹€. λ˜ν•œ λ‹€λ₯Έ ν•¨μˆ˜λ₯Ό μ‚¬μš©ν•˜μ—¬ 계산을 μˆ˜ν–‰ν•  μˆ˜λ„ μžˆμŠ΅λ‹ˆλ‹€. μ§€μ •λœ λ°μ΄ν„°λ² μ΄μŠ€ μ˜μ—­μ— μ»€μ„œλ₯Ό λ†“μœΌλ©΄ LibreOffice은(λŠ”) ν•΄λ‹Ή μ˜μ—­μ„ μžλ™μœΌλ‘œ μΈμ‹ν•©λ‹ˆλ‹€.

Form

Data Entry Form is a tool to make table data entry easy in spreadsheets. With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.

팁 μ•„μ΄μ½˜

The form supports up to 32 columns.


Streams

Create live data streams for spreadsheets.

XML Source

Import XML data in a spreadsheet.

Multiple Operations

맀개 λ³€μˆ˜ 값이 λ‹€λ₯Έ λ™μΌν•œ μˆ˜μ‹μ„ λ‹€λ₯Έ 셀에 μ μš©ν•©λ‹ˆλ‹€.

ν…μŠ€νŠΈλ₯Ό μ—΄λ‘œ

Opens the Text to Columns dialog, where you enter settings to expand the contents of selected cells to multiple cells.

Consolidate

ν•˜λ‚˜ μ΄μƒμ˜ 독립 μ…€ λ²”μœ„μ—μ„œ 데이터λ₯Ό κ²°ν•©ν•˜κ³  μ§€μ •λœ ν•¨μˆ˜λ₯Ό μ‚¬μš©ν•˜μ—¬ μƒˆ λ²”μœ„λ₯Ό κ³„μ‚°ν•©λ‹ˆλ‹€.

κ·Έλ£Ή 및 κ°œμš”

데이터 κ°œμš”λ₯Ό λ§Œλ“€κ³  ν–‰κ³Ό 열을 κ·Έλ£Ήν™”ν•˜λ©΄ 마우슀λ₯Ό ν•œ 번 ν΄λ¦­ν•˜λŠ” κ²ƒμœΌλ‘œ 그룹을 μΆ•μ†Œ 및 ν™•μž₯ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

Statistics

Use the data statistics in Calc to perform complex data analysis

Please support us!

Please support us!