Microsoft Office ๋ฐ LibreOffice ์‚ฌ์šฉ

LibreOffice๋Š” Microsoft Office ํŒŒ์ผ์„ ์—ด๊ณ  ์ €์žฅํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.(Microsoft Office Open XML ํ˜•์‹ ํฌํ•จ)

Microsoft Office ํŒŒ์ผ ์—ด๊ธฐ

  1. ํŒŒ์ผ - ์—ด๊ธฐ๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค. LibreOffice ํŒŒ์ผ ์—ด๊ธฐ ๋Œ€ํ™” ์ƒ์ž์—์„œ Microsoft Office ํŒŒ์ผ์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

MS Office ํŒŒ์ผ...

์—ด๋ฆฌ๋Š” LibreOffice ๋ชจ๋“ˆ

Microsoft Word, *.doc, *.docx

LibreOffice Writer

Microsoft Excel, *.xls, *.xlsx

LibreOffice Calc

Microsoft PowerPoint, *.ppt, *.pps, *.pptx

LibreOffice Impress


Microsoft Office ํŒŒ์ผ๋กœ ์ €์žฅ

  1. ํŒŒ์ผ โ€“ ๋‹ค๋ฅธ ์ด๋ฆ„์œผ๋กœ ์ €์žฅ์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

  2. ํŒŒ์ผ ํ˜•์‹ ์ƒ์ž์—์„œ Microsoft Office ํŒŒ์ผ ํ˜•์‹์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

๊ธฐ๋ณธ์ ์œผ๋กœ ๋ฌธ์„œ๋ฅผ Microsoft Office ํ˜•์‹์œผ๋กœ ์ €์žฅ

  1. Choose - Load/Save - General.

  2. ๊ธฐ๋ณธ ํŒŒ์ผ ํ˜•์‹ ๋ฐ ODF ์„ค์ • ์˜์—ญ์—์„œ ๋จผ์ € ๋ฌธ์„œ ์œ ํ˜•์„ ์„ ํƒํ•œ ๋‹ค์Œ ์ €์žฅํ•  ํŒŒ์ผ ์œ ํ˜•์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.

์ด์ œ๋ถ€ํ„ฐ ๋ฌธ์„œ๋ฅผ ์ €์žฅํ•˜๋ฉด ์„ ํƒํ•œ ๋‚ด์šฉ์— ๋”ฐ๋ผ ํŒŒ์ผ ํ˜•์‹์ด ์„ค์ •๋ฉ๋‹ˆ๋‹ค. ๋ฌผ๋ก  ํŒŒ์ผ ์ €์žฅ ๋Œ€ํ™” ์ƒ์ž์—์„œ ๋‹ค๋ฅธ ํŒŒ์ผ ํ˜•์‹์„ ์„ ํƒํ•  ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค.

๋งŽ์€ Microsoft Office ํŒŒ์ผ์„ OpenDocument ํ˜•์‹์œผ๋กœ ๋ณ€ํ™˜

๋ฌธ์„œ ๋ณ€ํ™˜๊ธฐ ๋งˆ๋ฒ•์‚ฌ๋Š” ํด๋”์— ์žˆ๋Š” Microsoft Office ํŒŒ์ผ์„ ๋ชจ๋‘ ๋ณต์‚ฌํ•˜์—ฌ OpenDocument ํŒŒ์ผ ํ˜•์‹์˜ LibreOffice ๋ฌธ์„œ๋กœ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์ฝ์„ ํด๋”์™€ ๋ณ€ํ™˜๋œ ํŒŒ์ผ์„ ์ €์žฅํ•  ํด๋”๋ฅผ ์ง€์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  1. ํŒŒ์ผ - ๋งˆ๋ฒ•์‚ฌ - ๋ฌธ์„œ ๋ณ€ํ™˜๊ธฐ๋ฅผ ์„ ํƒํ•˜์—ฌ ๋งˆ๋ฒ•์‚ฌ๋ฅผ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

Microsoft Office์™€ LibreOffice์˜ ๋งคํฌ๋กœ

๋ช‡ ๊ฐ€์ง€ ์˜ˆ์™ธ๋ฅผ ์ œ์™ธํ•˜๊ณ  Microsoft Office์™€ LibreOffice์€(๋Š”) ๊ฐ™์€ ๋งคํฌ๋กœ ์ฝ”๋“œ๋ฅผ ์‹คํ–‰ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค. Microsoft Office๋Š” VBA(Visual Basic for Applications) ์ฝ”๋“œ๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  LibreOffice์€(๋Š”) LibreOffice API(Application Program Interface) ํ™˜๊ฒฝ์„ ๊ธฐ๋ฐ˜์œผ๋กœ ํ•˜๋Š” Basic ์ฝ”๋“œ๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค. ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด๋Š” ๊ฐ™์ง€๋งŒ ๊ฐœ์ฒด์™€ ๋ฉ”์„œ๋“œ๋Š” ๋‹ค๋ฆ…๋‹ˆ๋‹ค.

note

์ตœ์‹  ๋ฒ„์ „์˜ LibreOffice์—์„œ๋Š” - ๋ถˆ๋Ÿฌ์˜ค๊ธฐ/์ €์žฅํ•˜๊ธฐ - VBA ์†์„ฑ์—์„œ ์ด ๊ธฐ๋Šฅ์„ ํ™œ์„ฑํ™”ํ•˜๋ฉด, ์ผ๋ถ€ Excel Visual Basic ์Šคํฌ๋ฆฝํŠธ๋ฅผ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.


ํ•œ ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์—์„œ ์‚ฌ์šฉ ์ค‘์ธ ๋งคํฌ๋กœ๋ฅผ ๋‹ค๋ฅธ ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์—์„œ๋„ ์‚ฌ์šฉํ•˜๋ ค๋ฉด ๋งคํฌ๋กœ๋ฅผ ํŽธ์ง‘ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. LibreOffice์€(๋Š”) Microsoft Office ํŒŒ์ผ์— ํฌํ•จ๋œ ๋งคํฌ๋กœ๋ฅผ ๋กœ๋“œํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ, ์‚ฌ์šฉ์ž๋Š” LibreOffice Basic IDE ํŽธ์ง‘๊ธฐ์—์„œ ๋งคํฌ๋กœ ์ฝ”๋“œ๋ฅผ ํ™•์ธํ•˜๊ณ  ํŽธ์ง‘ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

VBA ๋งคํฌ๋กœ๋ฅผ ๋ณด์กดํ•  ๊ฒƒ์ธ์ง€ ์•„๋‹ˆ๋ฉด ์‚ญ์ œํ•  ๊ฒƒ์ธ์ง€ ์„ ํƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

VBA ๋งคํฌ๋กœ ์ฝ”๋“œ๊ฐ€ ์žˆ๋Š” Microsoft Office ๋ฌธ์„œ๋ฅผ ์—ฝ๋‹ˆ๋‹ค. ์ผ๋ฐ˜ ๋‚ด์šฉ(ํ…์ŠคํŠธ, ์…€, ๊ทธ๋ฆผ)๋งŒ ๋ณ€๊ฒฝํ•˜๊ณ  ๋งคํฌ๋กœ๋Š” ํŽธ์ง‘ํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ํ•ด๋‹น ๋ฌธ์„œ๋ฅผ Microsoft Office ํŒŒ์ผ ํ˜•์‹์œผ๋กœ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค. Microsoft Office์—์„œ ํŒŒ์ผ์„ ์—ด๋ฉด ์ด์ „์ฒ˜๋Ÿผ VBA ๋งคํฌ๋กœ๊ฐ€ ์‹คํ–‰๋ฉ๋‹ˆ๋‹ค.

๋กœ๋“œํ•˜๊ฑฐ๋‚˜ ์ €์žฅํ•  ๋•Œ Microsoft Office ํŒŒ์ผ์—์„œ VBA ๋งคํฌ๋กœ๋ฅผ ์‚ญ์ œํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  1. LibreOffice์—์„œ VBA ๋งคํฌ๋กœ ๊ด€๋ จ ์„ค์ •์„ ํ•˜๋ ค๋ฉด - ๋ถˆ๋Ÿฌ์˜ค๊ธฐ/์ €์žฅํ•˜๊ธฐ - VBA ์†์„ฑ ํ•ญ๋ชฉ์„ ํ™•์ธํ•˜์‹ญ์‹œ์˜ค.

Please support us!