[Aug 13, 2019] What's new with Hancom Office Online?

The latest Hancom Office Online version 1.9, which is currently available in private beta, includes a major spreadsheet application upgrade with significant feature, performance and usability enhancements.  

 

1) Hancom Office Cell Online (spreadsheet):

 

Conditional Formatting

We have added complete support for the feature to render, add, and modify conditionally formatted cells.

mceclip0.png
 
The new conditional rules manager allows you to set up rule sets to apply color scale, cell value and icon set formatting rules to specified cell ranges.
 
mceclip1.png
 
The conditional formatting result is similar to what you would see in MS Excel.
 
image.png
 
 
Name Box and Name Manager
With this new feature, you can specify names for a cell or a range of cells.  You can also browse the named cells and edit/add names to cells using the new Name Manager dialog. This makes it very easy to navigate large spreadsheets.
 
mceclip2.png
 
 
 
Duplicate Sheet
This new time-saving feature allows you to fully duplicate any existing sheet.
 
mceclip3.png
 
Sheet Tab Color
You can now set the tab color to organize or highlight specific tabs easily.
 
mceclip2.png
 
 
AutoComplete
This essential time-saving feature makes spreadsheet data entry a breeze.
 
mceclip3.png
 
Data Validation
Now data validations within the spreadsheet are rendered.
 
mceclip3.png
 
 
Status Bar
You can now see the average, count, max, min and sum of selected cells in the enhanced status bar.  You can also choose which values are shown in the status bar.
  mceclip6.png
 
Number Format Support
New number formats and various date locales are supported now. 
mceclip3.png
Various date locales:
 
mceclip2.png
 
Number Filter and Text Filter
Quickly filter numbers and text with specified conditions.
 
mceclip8.png
 
Sort A to Z, Z to A
This new feature adds alphabetical/reverse alphabetical sorting to any column.  Previously, only columns with filtered data could be sorted.
 
mceclip9.png
 
 
Reading View
The new reading view maximizes the viewing area so that you can comfortably view large spreadsheets.  It's possible to toggle between reading and editing views quickly without waiting for the sheet to reload.
 
mceclip10.png
 
Double underline
New double underline style added for additional emphasis on the selected text.
 
 mceclip11.png
 
 
Copy format
A frequently requested feature allows users to copy cell styles to target cells.
mceclip12.png
 
 
 
Adjustable Formula Bar Height
The formula bar is now expandable by clicking the button at the right end to increase viewing area. 
 
mceclip13.png
 
Enhanced Find/Replace
More options are available on the Find/Replace dialog box.
 
mceclip0.png
 
 
More chart options
Now more chart options are available for you to customize your chart type and style.
 
mceclip1.png
 
 
Improved Performance and Limitations
Now the scroll speed performance is improved by 4X. Limitations have also been improved such as increasing renderable column (from 100 to 520), unlimited number of sheets (from 300), more recalcuations (2000 to 4000), and more columns (from 100 to 520).
 
 
2) Hancom Office Word Online (word processor):
In addition to the spreadsheet updates, the word processor and presentation applications have also been updated.
 
Insert image by drag and drop
We have added a feature that automatically inserts an image when you drag an image file on the desktop using the mouse and drop it in the Hancom Office Word Online document area.
 
Added function to insert the appropriate size when pasting images
If you copy(Ctrl+C) the image from a non-Hancom Office Word Online file and paste it into the Hancom Office Word Online(Ctrl+V), the image is automatically inserted with proper dimensions if the image size is too large.
 

More Shortcut-keys

More shortcut keys were added to make navigating the document more convenient.

 

Page Up

Move one screen up

Page Down

Move one screen down

Home

Move to the first of the sentence

End

Move to the end of the sentence

Ctrl+Home

Move to the first of the document

Ctrl+End

Move to the end of the document

 
 
 
3) Hancom Office Show Online (presentation):
 

Slide transition effect

Sometimes slide transitions are used to give a presentation more impact. For these users, the ability to load slide transitions stored in the original document and render them during a slide show has been added. Note that editing or applying new transitions are not provided.

 

Slide reset

You can revert to the original slide state after changing the position of the placeholders or changing the text and paragraph formatting, using the new “Reset Slide” function. The input (text, objects, etc.) is retained, and only the placeholder's position and formatting are restored.

 

mceclip0.png

 

Crop image

You can crop the image by clicking the “Crop Picture” function located in the task pane or context menu and adjusting the area as needed. Cropped parts can be hidden and re-displayed at any time using the Crop Picture feature.

 mceclip1.png

 

Shortcut help dialog

The dialog can be displayed by pressing Ctrl + / or clicking K icon in the upper right.

mceclip2.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.