데이터

The Data tab page allows you to assign a data source to the selected control.

이 λͺ…령을 μ‚¬μš©ν•˜λ €λ©΄...

Open context menu of a selected form element - choose Control Properties - Data tab.

Open Form Design toolbar, click Control icon - Data tab.


μ°Έκ³  μ•„μ΄μ½˜

For forms with database links, the associated database is defined in the Form Properties. You will find the functions for this on the Data tab page.


The possible settings of the Data tab page of a control depend on the respective control. You will only see the options that are available for the current control and context.
The following fields are available:

데이터 ν•„λ“œ

With database forms, you can link controls with the data fields.

ν•„λ“œλ₯Ό μ‚¬μš©ν•˜λŠ” κ²½μš°λŠ” μ—¬λŸ¬ κ°€μ§€μž…λ‹ˆλ‹€.

  1. 사둀 1: 양식에 ν•˜λ‚˜μ˜ ν…Œμ΄λΈ”λ§Œ μžˆμŠ΅λ‹ˆλ‹€.

    λ‚΄μš©μ„ ν‘œμ‹œν•  데이터 원본 ν…Œμ΄λΈ”μ˜ ν•„λ“œλ₯Ό 데이터 ν•„λ“œμ— μ§€μ •ν•©λ‹ˆλ‹€.

  2. 사둀 2: SQL 쿼리둜 λ§Œλ“€μ–΄μ§„ ν•˜μœ„ 양식에 콘트둀이 ν¬ν•¨λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

    λ‚΄μš©μ„ ν‘œμ‹œν•  SQL 문의 ν•„λ“œλ₯Ό 데이터 ν•„λ“œμ— μ§€μ •ν•©λ‹ˆλ‹€.

  1. 사둀 3: 콀보 μƒμž

    콀보 μƒμžμ˜ 경우 데이터 ν•„λ“œμ—μ„œ μ‚¬μš©μžκ°€ μž…λ ₯ν•˜κ±°λ‚˜ μ„ νƒν•œ 값이 μ €μž₯될 ν˜„μž¬ 양식 ν‘œμ˜ ν•„λ“œλ₯Ό μ§€μ •ν•˜μ‹­μ‹œμ˜€. (콀보 μƒμžμ˜ λͺ©λ‘μ— ν‘œμ‹œλœ 값은 λͺ©λ‘ λ‚΄μš©μ— μž…λ ₯된 SQL 문을 톡해 μ§€μ •λ©λ‹ˆλ‹€.)

  2. 사둀 4: λͺ©λ‘ μƒμž

    데이터 원본 ν…Œμ΄λΈ”μ—λŠ” ν‘œμ‹œν•  λ°μ΄ν„°λŠ” ν¬ν•¨λ˜μ–΄ μžˆμ§€ μ•Šκ³  일반 데이터 ν•„λ“œλ₯Ό 톡해 데이터 원본 ν…Œμ΄λΈ”μ— μ—°κ²°λœ ν…Œμ΄λΈ”μ„ ν¬ν•¨ν•©λ‹ˆλ‹€.

    ν˜„μž¬ 데이터 원본 ν…Œμ΄λΈ”μ— μ—°κ²°λœ ν…Œμ΄λΈ”μ˜ 데이터λ₯Ό λͺ©λ‘ μƒμžμ— ν‘œμ‹œν•˜λ €λ©΄ λͺ©λ‘ μƒμž λ‚΄μš©μ΄ μ°Έμ‘°ν•  데이터 원본 ν…Œμ΄λΈ”μ˜ ν•„λ“œλ₯Ό 데이터 ν•„λ“œμ—μ„œ μ§€μ •ν•©λ‹ˆλ‹€. λ˜λŠ” μ–‘μ‹μ˜ 데이터 ν‘œμ‹œλ₯Ό μ œμ–΄ν•˜λŠ” λ°μ΄ν„°λ² μ΄μŠ€λ₯Ό 지정할 수 μžˆμŠ΅λ‹ˆλ‹€. μ–‘μͺ½ ν…Œμ΄λΈ”μ„ 일반 데이터 ν•„λ“œλ₯Ό 톡해 μ—°κ²°ν•  수 μžˆλŠ” 경우 이 데이터 ν•„λ“œλŠ” λ‹€λ₯Έ ν…Œμ΄λΈ”μ— λŒ€ν•œ 링크λ₯Ό μ œκ³΅ν•©λ‹ˆλ‹€. κ³ μœ ν•œ ID 번호λ₯Ό μ €μž₯ν•˜λŠ” 데이터 ν•„λ“œκ°€ λŒ€κ°œ 여기에 ν•΄λ‹Ήν•©λ‹ˆλ‹€. λ‚΄μš©μ΄ 양식에 ν‘œμ‹œλ˜λŠ” 데이터 ν•„λ“œλŠ” λͺ©λ‘ λ‚΄μš©μ—μ„œ SQL 문에 μ˜ν•΄ μ§€μ •λ©λ‹ˆλ‹€.

λͺ©λ‘ μƒμžλŠ” μ°Έμ‘°λ₯Ό μ‚¬μš©ν•˜μ—¬ μž‘μ—…ν•©λ‹ˆλ‹€. λͺ©λ‘ ν•„λ“œλŠ” μ—°κ²°λœ ν…Œμ΄λΈ”κ³Ό ν•¨κ»˜ SQL 문을 톡해 μ‹€ν–‰λ˜κ±°λ‚˜ (4 번째 경우) κ°’ λͺ©λ‘μ„ 톡해 μ‹€ν–‰λ©λ‹ˆλ‹€:

μ—°κ²°λœ ν…Œμ΄λΈ”μ„ ν†΅ν•œ μ°Έμ‘° (SQL λ¬Έ)

μ–‘μ‹μ—μ„œ 기반으둜 ν•˜λŠ” ν…Œμ΄λΈ”μ— 일반 데이터 ν•„λ“œλ‘œ μ—°κ²°λœ λ°μ΄ν„°λ² μ΄μŠ€ ν…Œμ΄λΈ”μ˜ 데이터λ₯Ό λͺ©λ‘ μƒμžμ— ν‘œμ‹œν•˜λ €λŠ” 경우 양식 ν…Œμ΄λΈ”μ˜ 링크 ν•„λ“œλ₯Ό 데이터 ν•„λ“œμ— μ§€μ •ν•©λ‹ˆλ‹€.

λ§ν¬λŠ” SQL Select둜 λ§Œλ“€μ–΄μ§€λ©°, "SQL"μ΄λ‚˜ "Native SQL"을 μ„ νƒν•˜λ©΄ λͺ©λ‘ λ‚΄μš© ν•„λ“œμ˜ λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ— μ§€μ •λ©λ‹ˆλ‹€. 예λ₯Ό λ“€μ–΄ "Orders" ν…Œμ΄λΈ”μ€ ν˜„μž¬ 양식 콘트둀과 μ—°κ²°λ˜κ³  λ°μ΄ν„°λ² μ΄μŠ€μ—μ„œλŠ” "Customers" ν…Œμ΄λΈ”μ΄ "Orders" ν…Œμ΄λΈ”κ³Ό μ—°κ²°λ©λ‹ˆλ‹€. SQL 문을 λ‹€μŒκ³Ό 같이 μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€.

SELECT 고객 이름, 고객 번호 FROM 고객,

μ—¬κΈ°μ—μ„œ "CustomerName"은 μ—°κ²°λœ "Customers" ν…Œμ΄λΈ”μ˜ 데이터 ν•„λ“œμ΄λ©°, "CustomerNo"λŠ” 데이터 ν•„λ“œμ— μ§€μ •λœ β€œOrders” 양식 ν…Œμ΄λΈ”μ˜ ν•„λ“œμ™€ μ—°κ²°λœ "Customers" ν…Œμ΄λΈ”μ˜ ν•„λ“œμž…λ‹ˆλ‹€.

κ°’ λͺ©λ‘μ„ ν†΅ν•œ μ°Έμ‘°

λͺ©λ‘ μƒμžμ—μ„œλŠ” κ°’ λͺ©λ‘μ„ μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€. μ΄λŠ” μ°Έμ‘° 값을 μ •μ˜ν•˜λŠ” λͺ©λ‘μž…λ‹ˆλ‹€. κ·ΈλŸ¬λ―€λ‘œ μ–‘μ‹μ—μ„œ 콘트둀 ν•„λ“œλŠ” λ°μ΄ν„°λ² μ΄μŠ€ ν•„λ“œμ˜ λ‚΄μš©μ„ 직접 ν‘œμ‹œν•˜μ§€ μ•Šκ³  κ·Έ λŒ€μ‹  κ°’ λͺ©λ‘μ„ 톡해 μ§€μ •λœ 값을 ν‘œμ‹œν•©λ‹ˆλ‹€.

κ°’ λͺ©λ‘μ˜ μ°Έμ‘° 값을 μ‚¬μš©ν•˜λŠ” 경우 μ–‘μ‹μ˜ 데이터 ν•„λ“œμ— μ§€μ •ν•œ 데이터 ν•„λ“œ λ‚΄μš©μ€ ν‘œμ‹œλ˜μ§€ μ•Šκ³  ν• λ‹Ήλœ κ°’λ§Œ ν‘œμ‹œλ©λ‹ˆλ‹€. λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ˜ 데이터 νƒ­μ—μ„œ "Valuelist"λ₯Ό μ„ νƒν•˜κ³  λͺ©λ‘ ν•­λͺ©(일반 탭에 μž…λ ₯)μ—μ„œ μ–‘μ‹μ˜ λ³΄μ΄λŠ” λͺ©λ‘ ν•­λͺ©μ— μ°Έμ‘° 값을 ν• λ‹Ήν•œ 경우, 이 μ°Έμ‘° 값은 주어진 데이터 ν•„λ“œμ˜ 데이터 λ‚΄μš©κ³Ό λΉ„κ΅λ©λ‹ˆλ‹€. μ°Έμ‘° 값이 데이터 ν•„λ“œ λ‚΄μš©κ³Ό μΌμΉ˜ν•˜λŠ” 경우 κ΄€λ ¨ λͺ©λ‘ ν•­λͺ©μ΄ 양식에 ν‘œμ‹œλ©λ‹ˆλ‹€.

λͺ©λ‘ λ‚΄μš©

With database forms, specifies the data source for the list content of the form-element. This field can be used to define a value list for documents without a database connection.

λ°μ΄ν„°λ² μ΄μŠ€ μ–‘μ‹μ˜ 경우 데이터 원본은 λͺ©λ‘ μƒμžλ‚˜ 콀보 μƒμžμ˜ ν•­λͺ©μ„ κ²°μ •ν•©λ‹ˆλ‹€. μ΄λŸ¬ν•œ κ°œμ²΄κ°€ λ°μ΄ν„°λ² μ΄μŠ€μ— μžˆλŠ” 경우 μ„ νƒν•œ μœ ν˜•μ— 따라 λͺ©λ‘ λ‚΄μš© μ•„λž˜μ—μ„œ λ‹€μ–‘ν•œ 데이터 원본 쀑 ν•˜λ‚˜λ₯Ό μ„ νƒν•©λ‹ˆλ‹€. λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ—μ„œ μ„ νƒν•œ λͺ¨λ“  μ‚¬μš© κ°€λŠ₯ν•œ λ°μ΄ν„°λ² μ΄μŠ€ 개체 μœ ν˜•μ΄ 여기에 μ œκ³΅λ©λ‹ˆλ‹€. "κ°’ λͺ©λ‘" μ˜΅μ…˜μ„ μœ ν˜•μœΌλ‘œ μ„ νƒν•œ 경우 λ°μ΄ν„°λ² μ΄μŠ€ 양식에 λŒ€ν•œ μ°Έμ‘°λ₯Ό μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€. SQL λͺ…λ ΉμœΌλ‘œ 콘트둀의 ν‘œμ‹œλ₯Ό μ œμ–΄ν•˜λŠ” 경우 SQL 문이 여기에 μž…λ ₯λ©λ‹ˆλ‹€.

SQL 문의 예:

λͺ©λ‘ ν•„λ“œμ—μ„œ SQL 문의 ν˜•νƒœμ˜ μ˜ˆλŠ” λ‹€μŒκ³Ό κ°™μŠ΅λ‹ˆλ‹€:

SELECT field1, field2 FROM table,

μ—¬κΈ°μ—μ„œ "ν…Œμ΄λΈ”"은 κ·Έ 데이터가 콘트둀 ν•„λ“œμ˜ λͺ©λ‘μ— ν‘œμ‹œλ˜λŠ” ν…Œμ΄λΈ”μž…λ‹ˆλ‹€(λͺ©λ‘ ν…Œμ΄λΈ”). "ν•„λ“œ1"은 μ–‘μ‹μ—μ„œ λ³Ό 수 μžˆλŠ” ν•­λͺ©μ„ μ§€μ •ν•˜λŠ” 데이터 ν•„λ“œμ΄λ©° κ·Έ λ‚΄μš©μ€ λͺ©λ‘ ν•„λ“œμ— ν‘œμ‹œλ©λ‹ˆλ‹€. "ν•„λ“œ2"λŠ” μ—°κ²°λœ ν•„λ“œ = 1이 μ„ νƒλ˜μ—ˆμ„ 경우 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œλ₯Ό 톡해 양식 ν…Œμ΄λΈ”(κ°’ ν…Œμ΄λΈ”)κ³Ό μ—°κ²°λ˜μ–΄ μžˆλŠ” λͺ©λ‘ ν…Œμ΄λΈ”μ˜ ν•„λ“œμž…λ‹ˆλ‹€.

콀보 μƒμžμ—μ„œ SQL 문의 ν˜•νƒœμ˜ μ˜ˆλŠ” λ‹€μŒκ³Ό κ°™μŠ΅λ‹ˆλ‹€:

SELECT DISTINCT field FROM table,

μ—¬κΈ°μ„œ "field"λŠ” 콀보 μƒμž λͺ©λ‘μ— λ‚΄μš©μ΄ ν‘œμ‹œλ˜μ–΄ μžˆλŠ” λͺ©λ‘ ν…Œμ΄λΈ” "table"의 데이터 ν•„λ“œμž…λ‹ˆλ‹€.

HTML λ¬Έμ„œμ—μ„œμ˜ κ°’ λͺ©λ‘

HTML μ–‘μ‹μ˜ 경우 λͺ©λ‘ λ‚΄μš©μ—μ„œ κ°’ λͺ©λ‘μ„ μž…λ ₯ν•  수 μžˆμŠ΅λ‹ˆλ‹€. λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ—μ„œ "Valuelist" μ˜΅μ…˜μ„ μ„ νƒν•©λ‹ˆλ‹€. 여기에 μž…λ ₯된 값은 양식에 ν‘œμ‹œλ˜μ§€ μ•ŠμœΌλ©° ν‘œμ‹œλ˜λŠ” ν•­λͺ©μ— 값을 ν• λ‹Ήν•  λ•Œ μ‚¬μš©λ©λ‹ˆλ‹€. λͺ©λ‘ λ‚΄μš©μ—μ„œ λ§Œλ“  ν•­λͺ©μ€ HTML νƒœκ·Έ <OPTION VALUE=...>에 ν•΄λ‹Ήν•©λ‹ˆλ‹€.

λͺ©λ‘ μƒμžλ‚˜ 콀보 μƒμžμ—μ„œ μ„ νƒν•œ ν•­λͺ©μ„ 데이터 전솑할 λ•Œ λͺ©λ‘ ν•­λͺ©μ˜ 일반 탭에 μž…λ ₯ν•˜μ—¬ 양식에 ν‘œμ‹œν•œ λͺ¨λ“  κ°’ λͺ©λ‘κ³Ό λͺ©λ‘ λ‚΄μš©μ˜ 데이터 탭에 μž…λ ₯ν•œ κ°’ λͺ©λ‘μ„ λͺ¨λ‘ κ³ λ €ν•©λ‹ˆλ‹€. λΉ„μ–΄ μžˆμ§€ μ•Šμ€ ν…μŠ€νŠΈκ°€ κ°’ λͺ©λ‘ (<OPTION VALUE=...>)의 μ„ νƒν•œ μœ„μΉ˜μ— 있으면 μ „μ†‘λ©λ‹ˆλ‹€. 그렇지 μ•Šμ€ 경우 (<OPTION>) μ½˜νŠΈλ‘€μ— ν‘œμ‹œλœ ν…μŠ€νŠΈκ°€ μ „μ†‘λ©λ‹ˆλ‹€.

κ°’ λͺ©λ‘μ— 빈 λ¬Έμžμ—΄μ΄ μžˆλŠ” 경우 λͺ©λ‘ λ‚΄μš©μ˜ "$$$empty$$$" 값을 ν•΄λ‹Ή μœ„μΉ˜μ— μž…λ ₯ν•©λ‹ˆλ‹€(λŒ€λ¬Έμž/μ†Œλ¬Έμž μ°Έκ³ ). LibreOffice은(λŠ”) 이 μž…λ ₯을 빈 λ¬Έμžμ—΄λ‘œ ν•΄μ„ν•˜μ—¬ ν•΄λ‹Ή λͺ©λ‘ ν•­λͺ©μ— μ§€μ •ν•©λ‹ˆλ‹€.

λ‹€μŒ ν…Œμ΄λΈ”μ€ "λͺ©λ‘ μƒμž1"μ΄λΌλŠ” μ΄λ¦„μ˜ λͺ©λ‘ ν•„λ“œμ— μ˜κ±°ν•˜μ—¬ HTMLκ³Ό JavaScript, LibreOffice-ν•„λ“œμΈ λͺ©λ‘ λ‚΄μš© μ‚¬μ΄μ˜ 관계λ₯Ό λ³΄μ—¬μ€λ‹ˆλ‹€. 이 λ•Œ "ν•­λͺ©"은 μ–‘μ‹μ—μ„œ λ³Ό 수 μžˆλŠ” λͺ©λ‘ ν•­λͺ©μ„ μ˜λ―Έν•©λ‹ˆλ‹€:

HTML-νƒœκ·Έ

JavaScript

콘트둀 ν•„λ“œμ˜ κ°’ λͺ©λ‘μ— μžˆλŠ” ν•­λͺ© (λͺ©λ‘ λ‚΄μš©)

μ „μ†‘λœ 데이터

<OPTION>ν•­λͺ©

λΆˆκ°€λŠ₯

""

...λ³Ό 수 μžˆλŠ” λͺ©λ‘ ν•­λͺ© ("ListBox1=Item")

<OPTION VALUE="κ°’">ν•­λͺ©

ListBox1.options[0].value="Value"

"κ°’"

...λͺ©λ‘ ν•­λͺ©μ— μ§€μ •λœ κ°’ ("λͺ©λ‘ μƒμž1=κ°’").

<OPTION VALUE="">ν•­λͺ©

λͺ©λ‘ ν•­λͺ©1.options[0].value=""

"$$$empty$$$"

...λΉ„μ–΄ μžˆλŠ” 슀트링 ("ListBox1=")


λͺ©λ‘ λ‚΄μš©μ˜ μ’…λ₯˜

Determines the data to fill the lists in list and combo boxes.

Valuelist μ˜΅μ…˜μ„ μ‚¬μš©ν•˜λ©΄ 일반 νƒ­μ˜ λͺ©λ‘ ν•­λͺ© ν•„λ“œμ— μž…λ ₯ν•œ λͺ¨λ“  ν•­λͺ©μ΄ μ½˜νŠΈλ‘€μ— ν‘œμ‹œλ©λ‹ˆλ‹€. λ°μ΄ν„°λ² μ΄μŠ€ μ–‘μ‹μ˜ 경우 μ°Έμ‘° 값을 μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€(κ°’ λͺ©λ‘μ„ μ‚¬μš©ν•˜λŠ” μ°Έμ‘° 절 μ°Έμ‘°).

콘트둀의 λ‚΄μš©μ„ λ°μ΄ν„°λ² μ΄μŠ€μ—μ„œ 읽은 경우 λ‹€λ₯Έ μ˜΅μ…˜μ„ μ‚¬μš©ν•˜μ—¬ 데이터 μ›λ³Έμ˜ μœ ν˜•μ„ κ²°μ •ν•  수 μžˆμŠ΅λ‹ˆλ‹€. 예λ₯Ό λ“€μ–΄, ν…Œμ΄λΈ”κ³Ό 쿼리 μ‚¬μ΄μ—μ„œ 선택할 수 μžˆμŠ΅λ‹ˆλ‹€.

λΉ„μ–΄ μžˆλŠ” λ¬Έμžμ—΄μ€ NULLμž…λ‹ˆλ‹€

Defines how an empty string input should be handled. If set to "Yes", an input string of length zero will be treated as a value NULL. If set to "No", any input will be treated as-is without any conversion.

An empty string is a string of length zero (""). Normally, a value NULL is not the same as an empty string. In general, a term NULL is used to denote an undefined value, an unknown value, or "no value has been entered yet."

λ°μ΄ν„°λ² μ΄μŠ€ μ‹œμŠ€ν…œμ€ λ‹€μ–‘ν•˜κ³ , NULL 값을 λ‹€λ₯΄κ²Œ μ²˜λ¦¬ν•  수 μžˆμŠ΅λ‹ˆλ‹€. μ‚¬μš©ν•˜κ³  κ³„μ‹œλŠ” λ°μ΄ν„°λ² μ΄μŠ€μ˜ λ¬Έμ„œλ₯Ό μ°Έμ‘°ν•˜μ‹­μ‹œμ˜€.

μ—°κ²°λœ μ…€

Specifies the reference to a linked cell on a spreadsheet. The live state or contents of the control are linked to the cell contents. The following tables list the controls and their corresponding link type:

μ—°κ²°λœ 셀이 μžˆλŠ” ν™•μΈλž€

μž‘μ—…

κ²°κ³Ό

Select the check box:

TRUE is entered into the linked cell.

Deselect the check box:

FALSE is entered into the linked cell.

Tri-state check box is set to "undetermined" state:

#NV is entered into the linked cell.

Enter a number or a formula that returns a number in the linked cell:

If entered value is TRUE or not 0: Check box is selected.
If entered value is FALSE or 0: Check box is deselected.

Clear the linked cell, or enter text, or enter a formula that returns text or an error:

삼쀑 μƒνƒœ ν™•μΈλž€μ€ "κ²°μ •λ˜μ§€ μ•ŠμŒ" μƒνƒœλ‘œ μ„€μ •λ˜κ³ , λ‹€λ₯Έ ν™•μΈλž€ 선택은 ν•΄μ œλ©λ‹ˆλ‹€.

Select the box. The Reference value box contains text:

The text from the Reference value box is copied to the cell.

Deselect the box. The Reference value box contains text:

셀에 빈 λ¬Έμžμ—΄μ΄ λ³΅μ‚¬λ©λ‹ˆλ‹€.

The Reference value box contains text. Enter the same text into the cell:

ν™•μΈλž€μ΄ μ„ νƒλ©λ‹ˆλ‹€.

The Reference value box contains text. Enter another text into the cell:

ν™•μΈλž€ 선택이 ν•΄μ œλ©λ‹ˆλ‹€.


μ—°κ²°λœ 셀이 μžˆλŠ” μ˜΅μ…˜ λ²„νŠΌ(λΌλ””μ˜€ λ²„νŠΌ)

μž‘μ—…

κ²°κ³Ό

Select the option button:

TRUE is entered into the linked cell.

Option button is deselected by selecting another option button:

FALSE is entered into the linked cell.

Enter a number or a formula that returns a number in the linked cell:

If entered value is TRUE or not 0: Option button is selected.
If entered value is FALSE or 0: Option button is deselected.

Clear the linked cell, or enter text, or enter a formula that returns text or an error:

Option button is deselected.

Click the option button. The Reference value box contains text:

The text from the Reference value box is copied to the cell.

Click another option button of the same group. The Reference value box contains text:

셀에 빈 λ¬Έμžμ—΄μ΄ λ³΅μ‚¬λ©λ‹ˆλ‹€.

The Reference value box contains text. Enter the same text into the cell:

μ˜΅μ…˜ λ²„νŠΌμ΄ μ„ νƒλ©λ‹ˆλ‹€.

The Reference value box contains text. Enter another text into the cell:

μ˜΅μ…˜ λ²„νŠΌμ΄ μ§€μ›Œμ§‘λ‹ˆλ‹€.


μ—°κ²°λœ 셀이 μžˆλŠ” ν…μŠ€νŠΈ μƒμž

μž‘μ—…

κ²°κ³Ό

Enter text into the text box:

Text is copied into the linked cell.

Clear the text box:

Linked cell is cleared.

Enter text or a number in the linked cell:

Text or number is copied into the text box.

Enter a formula into the linked cell:

Formula result is copied into the text box.

Clear the linked cell:

Text box is cleared.


μ—°κ²°λœ 셀이 μžˆλŠ” 숫자 ν•„λ“œμ™€ μ„œμ‹ μžˆλŠ” ν•„λ“œ

μž‘μ—…

κ²°κ³Ό

Enter a number into the field:

Number is copied into the linked cell.

Clear the field:

Value 0 is set in the linked cell.

Enter a number or a formula that returns a number in the linked cell:

Number is copied into the field.

Clear the linked cell, or enter text, or enter a formula that returns text or an error:

Value 0 is set in the field.


μ—°κ²°λœ 셀이 μžˆλŠ” λͺ©λ‘ μƒμž

λͺ©λ‘ μƒμžλŠ” 두 가지 μ—°κ²° λͺ¨λ“œλ₯Ό μ§€μ›ν•©λ‹ˆλ‹€. "μ—°κ²°λœ μ…€μ˜ λ‚΄μš©" 속성을 μ°Έκ³ ν•˜μ‹­μ‹œμ˜€.

  1. Linked contents: Synchronize the text contents of the selected list box entry with the cell contents.

  2. Linked selection position: The position of the single selected item in the list box is synchronized with the numerical value in the cell.

μž‘μ—…

κ²°κ³Ό

Select a single list item:

λ‚΄μš©μ΄ μ—°κ²°λœ 경우: μ—°κ²°λœ 셀에 ν•­λͺ© ν…μŠ€νŠΈκ°€ λ³΅μ‚¬λ©λ‹ˆλ‹€.

Selection is linked: Position of the selected item is copied into the linked cell.
For example, if the third item is selected, the number 3 will be copied.

Select several list items:

#NV is entered into the linked cell.

Deselect all list items:

Contents are linked: Linked cell is cleared.

Selection is linked: Value 0 is entered in the linked cell.

Enter text or a number into the linked cell:

Contents are linked: Find and select an equal list item.

Selection is linked: The list item at the specified position (starting with 1 for the first item) is selected. If not found, all items are deselected.

Enter a formula into the linked cell:

Find and select a list item that matches the formula result and link mode.

Clear the linked cell:

Deselect all items in the list box.

Change the contents of the list source range:

λ³€κ²½ 사항에 따라 λͺ©λ‘ μƒμž ν•­λͺ©μ΄ μ—…λ°μ΄νŠΈλ©λ‹ˆλ‹€. 선택은 μœ μ§€λ©λ‹ˆλ‹€. 이둜 인해 μ—°κ²°λœ 셀이 μ—…λ°μ΄νŠΈλ  μˆ˜λ„ μžˆμŠ΅λ‹ˆλ‹€.


μ—°κ²°λœ 셀이 μžˆλŠ” 콀보 μƒμž

μž‘μ—…

κ²°κ³Ό

Enter text into the edit field of the combo box, or select an entry from the drop-down list:

Text is copied into the linked cell.

Clear the edit field of the combo box:

Linked cell is cleared.

Enter text or a number into the linked cell:

Text or number is copied into the edit field of the combo box.

Enter a formula into the linked cell:

Formula result is copied into the edit field of the combo box.

Clear the linked cell:

Edit field of the combo box is cleared.

Change the contents of the list source range:

λ³€κ²½ 사항에 따라 λ“œλ‘­λ‹€μš΄ λͺ©λ‘ ν•­λͺ©μ΄ μ—…λ°μ΄νŠΈλ©λ‹ˆλ‹€. 콀보 μƒμžμ˜ νŽΈμ§‘ ν•„λ“œμ™€ μ—°κ²°λœ 셀은 λ³€κ²½λ˜μ§€ μ•ŠμŠ΅λ‹ˆλ‹€.


μ—°κ²°λœ μ…€μ˜ λ‚΄μš©

Select the mode of linking a list box with a linked cell on a spreadsheet.

  1. Linked contents: Synchronize the text contents of the selected list box entry with the cell contents. Select "The selected entry".

  2. Linked selection position: The position of the single selected item in the list box is synchronized with the numerical value in the cell. Select "Position of the selected entry".

μ—°κ²°λœ ν•„λ“œ

μ°Έκ³  μ•„μ΄μ½˜

속성 λΈŒλΌμš°μ €μ—μ„œ μ—°κ²°λœ ν•„λ“œ μ…€μ˜ λ‚΄μš©μ„ μ‚­μ œν•˜λ©΄ κ²°κ³Ό μ§‘ν•©μ˜ 첫 번째 ν•„λ“œλ₯Ό μ‚¬μš©ν•˜μ—¬ 데이터λ₯Ό ν‘œμ‹œν•˜κ³  κ΅ν™˜ν•©λ‹ˆλ‹€.


λͺ©λ‘ ν•„λ“œμ— λŒ€ν•˜μ—¬ μ‚¬μš©ν•  수 μžˆλŠ” 속성은 μ—°κ²°λœ ν‘œμ˜ μ–΄λ–€ 데이터 ν•„λ“œκ°€ 양식에 ν‘œμ‹œλ˜λŠ”μ§€ μ§€μ •ν•©λ‹ˆλ‹€.

μ–‘μ‹μ˜ λͺ©λ‘ μƒμžμ—μ„œ 양식 ν…Œμ΄λΈ”μ— μ—°κ²°λœ ν…Œμ΄λΈ”μ˜ λ‚΄μš©μ„ ν‘œμ‹œν•˜λŠ” 경우 λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜• ν•„λ“œμ—μ„œ SQL λͺ…령에 μ˜ν•΄ ν‘œμ‹œκ°€ κ²°μ •λ˜λŠ”μ§€ λ˜λŠ” μ—°κ²°λœ ν…Œμ΄λΈ”μ— μ•‘μ„ΈμŠ€ν•˜λŠ”μ§€ μ§€μ •ν•©λ‹ˆλ‹€. λ°”μš΄λ“œ ν•„λ“œ μ†μ„±μ—μ„œλŠ” 색인을 μ‚¬μš©ν•˜μ—¬ λͺ©λ‘ ν•„λ“œλ₯Ό μ—°κ²°ν•  쿼리 λ˜λŠ” ν…Œμ΄λΈ”μ˜ 데이터 ν•„λ“œλ₯Ό μ§€μ •ν•©λ‹ˆλ‹€.

μ°Έκ³  μ•„μ΄μ½˜

λ°”μš΄λ“œ ν•„λ“œ 속성은 두 개 μ΄μƒμ˜ ν…Œμ΄λΈ”μ— μ•‘μ„ΈμŠ€ν•  λ•Œ μ‚¬μš©λ˜λŠ” μ–‘μ‹μ—λ§Œ μ‚¬μš©ν•  수 μžˆμŠ΅λ‹ˆλ‹€. 양식이 ν•œ ν…Œμ΄λΈ”λ§Œ 기반으둜 ν•˜λŠ” 경우 양식에 ν‘œμ‹œλ˜λŠ” ν•„λ“œκ°€ 데이터 ν•„λ“œ μ•„λž˜μ— 직접 μ§€μ •λ©λ‹ˆλ‹€. ν•˜μ§€λ§Œ 일반 데이터 ν•„λ“œλ₯Ό 톡해 ν˜„μž¬ ν…Œμ΄λΈ”μ— μ—°κ²°λœ ν…Œμ΄λΈ”μ˜ 데이터λ₯Ό λͺ©λ‘ μƒμžμ— ν‘œμ‹œν•˜λ €λŠ” 경우 μ—°κ²°λœ 데이터 ν•„λ“œκ°€ λ°”μš΄λ“œ ν•„λ“œ 속성에 μ˜ν•΄ μ§€μ •λ©λ‹ˆλ‹€.


λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ—μ„œ "SQL"을 μ„ νƒν•œ 경우 SQL λͺ…령이 지정할 색인을 κ²°μ •ν•©λ‹ˆλ‹€. 예: λͺ©λ‘ λ‚΄μš©μ—μ„œ "SELECT Field1, Field2 FROM tablename" 같은 SQL λͺ…령을 μ§€μ •ν•œ 경우 λ‹€μŒ ν…Œμ΄λΈ”μ„ μ°Έμ‘°ν•˜μ‹­μ‹œμ˜€.

μ—°κ²°λœ ν•„λ“œ

μ—°κ²°

-1

The index of the selected entry in the list is linked to the field specified under Data field.

{empty} or 0

"ν•„λ“œ1" λ°μ΄ν„°λ² μ΄μŠ€ ν•„λ“œλŠ” 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œμ™€ μ—°κ²°λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

1

"ν•„λ“œ2" λ°μ΄ν„°λ² μ΄μŠ€ ν•„λ“œλŠ” 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œμ™€ μ—°κ²°λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.


λͺ©λ‘ λ‚΄μš©μ˜ μœ ν˜•μ—μ„œ "ν…Œμ΄λΈ”"을 μ„ νƒν•œ 경우 ν…Œμ΄λΈ” ꡬ쑰가 지정할 색인을 μ§€μ •ν•©λ‹ˆλ‹€. 예: λͺ©λ‘ λ‚΄μš©μ—μ„œ λ°μ΄ν„°λ² μ΄μŠ€ ν…Œμ΄λΈ”μ„ μ„ νƒν•œ 경우 λ‹€μŒ ν…Œμ΄λΈ”μ„ μ°Έμ‘°ν•˜μ‹­μ‹œμ˜€.

μ—°κ²°λœ ν•„λ“œ

μ—°κ²°

-1

The index of the selected entry in the list is linked to the field specified under Data field.

{empty} or 0

ν…Œμ΄λΈ”μ˜ 첫 번째 열은 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œμ™€ μ—°κ²°λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

1

ν…Œμ΄λΈ”μ˜ 두 번째 열은 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œμ™€ μ—°κ²°λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.

2

ν…Œμ΄λΈ”μ˜ μ„Έ 번째 열은 데이터 ν•„λ“œμ— μ§€μ •λ˜μ–΄ μžˆλŠ” ν•„λ“œμ™€ μ—°κ²°λ˜μ–΄ μžˆμŠ΅λ‹ˆλ‹€.


원본 μ…€ λ²”μœ„

Enter a cell range that contains the entries for a list box or combo box on a spreadsheet. If you enter a multi-column range, only the contents of the leftmost column are used to fill the control.

μ°Έμ‘° κ°’(μ‚¬μš© μ•ˆ 함)

Check boxes and radio buttons in spreadsheets can be bound to cells in the current document. If the control is enabled, the value you enter in Reference value (on) is copied to the cell. If the control is disabled, the value from Reference value (off) is copied to the cell.

μ°Έμ‘° κ°’(μ‚¬μš©)

You can assign a reference value to option buttons and check boxes. The reference value will be remitted to a server when sending the web form. With database forms the value entered here will be written in the database assigned to the control field.

μ›Ή μ–‘μ‹μ—μ„œμ˜ μ°Έμ‘° κ°’

μ°Έμ‘° 값은 μ›Ή 양식을 λ””μžμΈν•˜κ³  콘트둀 μƒνƒœμ— λŒ€ν•œ 정보λ₯Ό μ„œλ²„λ‘œ μ „μ†‘ν•˜λŠ” κ²½μš°μ— μœ μš©ν•©λ‹ˆλ‹€. μ‚¬μš©μžκ°€ μ½˜νŠΈλ‘€μ„ ν΄λ¦­ν•˜λ©΄ ν•΄λ‹Ή μ°Έμ‘° 값이 μ„œλ²„λ‘œ μ „μ†‘λ©λ‹ˆλ‹€.

예λ₯Ό λ“€μ–΄ "μ—¬μ„±"κ³Ό "남성"μ΄λΌλŠ” μ˜΅μ…˜μ˜ 콘트둀 ν•„λ“œ 2κ°œκ°€ 있고 "μ—¬μ„±" ν•„λ“œμ—λŠ” μ°Έμ‘° κ°’ 1을, "남성" ν•„λ“œμ—λŠ” κ°’ 2λ₯Ό ν• λ‹Ήν–ˆλ‹€κ³  κ°€μ •ν•  λ•Œ "μ—¬μ„±" ν•„λ“œλ₯Ό ν΄λ¦­ν•˜λ©΄ κ°’ 1이, "남성" ν•„λ“œλ₯Ό ν΄λ¦­ν•˜λ©΄ κ°’ 2κ°€ μ„œλ²„λ‘œ μ „μ†‘λ©λ‹ˆλ‹€.

λ°μ΄ν„°λ² μ΄μŠ€ μ–‘μ‹μ—μ„œμ˜ μ°Έμ‘° κ°’

λ°μ΄ν„°λ² μ΄μŠ€ μ–‘μ‹μ—μ„œ μ°Έμ‘° 값을 톡해 μ˜΅μ…˜ ν•„λ“œλ‚˜ ν™•μΈλž€μ˜ μƒνƒœλ₯Ό ν‘œμ‹œν•  수 있으며 이 μ°Έμ‘° 값을 λ°μ΄ν„°λ² μ΄μŠ€μ— μ €μž₯ν•  수 μžˆμŠ΅λ‹ˆλ‹€. 예λ₯Ό λ“€μ–΄ "μž‘μ—… 쀑", "ν•΄κ²°", "λ‹€μ‹œ μ œμ•ˆ"의 μ„Έ 가지 μ˜΅μ…˜μ˜ 그룹화와 ν•¨κ»˜ 각 μ°Έμ‘° 값인 "ToDo", "OK", "WV"κ°€ μžˆμ„ 경우 각 μ˜΅μ…˜μ„ ν΄λ¦­ν•˜λ©΄ 이 μ°Έμ‘° 값이 λ°μ΄ν„°λ² μ΄μŠ€μ— λ‚˜νƒ€λ‚©λ‹ˆλ‹€.

ν•„ν„° μ œμ•ˆ

While designing your form, you can set the "Filter proposal" property for each text box in the Data tab of the corresponding Properties dialog. In subsequent searches in the filter mode, you can select from all information contained in these fields. The field content can then be selected using the AutoComplete function. Note, however, that this function requires a greater amount of memory space and time, especially when used in large databases and should therefore be used sparingly.

Please support us!