LG G Pro F240K (Korean Model) Unrooting and Software Update

LG 지 프로 KT, 언루팅 & 소프트웨어 업데이트

한글 요약: 루팅이 되었기에 OTA 소프트웨어 업데이트를 할 수 없던 젤리빈 LG G Pro(KT버전)를 아래 Way 3에 소개된 방법으로 킷캣으로 업그레이드 할 수 있었다.

Situation: Trying s/w update (4.4.2 Kitkat) on a rooted LG G Pro (F240K) of 4.1.2 Jellybean

Why: Abnormally slowed response recently and needs of unrooted phone

Problem: LG blocked s/w update on a rooted phone

Way 1.
Trying to unroot with keeping 4.1.2
Failed: Couldn't find the unrooting tool which is related to my previous rooting tool.

Way 2.
Using LG Mobile Support Tool
Failed: The program keeps saying the battery is low even though it's fully charged.

Way 3.
Using LG Flash Tool 2014 with the Jellybean KDZ file for F240K
Succeeded: Hurray!

Preparation: LG Mobile Support Tool (B2CAppSetup.exe), LG Flash Tool 2014 (.zip), KDZ file for F240K (.kdz)

1. Run LGFlashTool2014.exe as an administrator
2. Select Type: CDMA
3. PhoneMode: EMERGENCY
4. Select KDZ file
5. Click [CSE Flash]
6. Click [Start]

Then it will run LG Mobile Support Tool and start firmware update.

I don't know why, but in my case, it stopped at 4% and showed some instructions of rebooting the phone and there was a [Retry] button. Instead of following the sentences I just click the [Retry] button and it proceeded greatly up to 95%, and then the phone was rebooted.

The initial setting steps were begun with the greeting Droid image, but the proceeding bar was 95% still so I was waiting and finally it became 100% without any change on the phone screen. I unplugged the USB cable and checked the s/w version which was changed to Jellybean, of course not rooted.

After 6 times of trials of s/w update from Jellybean to Kitkat, the phone works finely awesome! It responses as a quad-core device. I had to select and install 78 apps manually from my previously installed app list of the Google Play Store but it was a chance for me to organize the unused apps, so no problem.

Big thanks to all xda devs and the uploaders of tools and kdz files. You're super!

Microsoft Word 2013 - How to Underline with Spaces

In MS Word 2013, you cannot see any underlined spaces when type space bar on your keyboard with underlined font style. I didn't know that it was like this in Word 2007 or 2003 but it is in 2013 and makes users confusing because it doesn't work as it is expected.

It would be like this with just typing Space... So bothering!

We have to type Ctrl+Shift+Space (none-breaking space, what is that... why isn't the default space for underlining...) to see those underlines like the following.

It would be like this with typing Ctrl+Shift+Space.


Simple, but needed an extra effort to find out.

MS Office, very unkind.

MS Excel 2013 - How to apply a function to multiple cells & Excel shares its undo/redo history with all opened documents (workbooks, windows, worksheets whatever)

How to apply a function to multiple cells at once

You have one column (A) that have many cells filled with different values, and you want use a same function with that values and fill the results in the cells of a different column (B), probably next column.

Apply your function in B1 with using A1 as its parameter, got the result in B1? Then drag the right-bottom corner of B1 cell and drop it on BX which is the next cell of the A column's cell that has the last value you want to use as a parameter of your funciton.


How to add/subtract/multiply/divide in multiple cells at once
or
How to copy only Formulas/Values/Formats

The answer is ...

'Paste Special'

You have different values in A1:A20, and you want to do adding/subtracting/multiplying/dividing with a certain value but separately into/for all of A1:A20 values.

For example, you want to add '100' to A1:A20 independently, then type in 100 in any cell you wouldn't use in the future, and copy the cell, and then select A1:A20, right-click on the selection and expand the menu 'Paste Special' and click 'Paste Special' at the bottom again. (how poor this interface is ...)

Choose 'add' on the dialog and 'OK'. Done.

You can copy only functions, formats with this special paste without copying any values, or only values.


By the way, I found a terrible truth (in most case) that opened multiple Excel documents (or workbooks, or windows) share one undo/redo history, which is not convenient at all in many cases. Because the opened documents are managed by Excel application's one 'instance'; a computer term indicates one unit of processing, a.k.a 'process'. (One visible application may consist of one process or more processes. One process may have one thread or more threads.)

You can open a document as a new instance that has a independent undo/redo history by holding 'Alt' key before clicking the Excel icon on your Start menu or Taskbar (in Windows 7) and keep holding until you see a dialog asks about starting a new instance of Excel.

There should be a reason of that MS made Excel or other office applications like this, but as a light user, I couldn't find any benefit so far. Because of OneDrive cloud service?

How to configure Sublime Text 2 (서브라임 텍스트2 설정하기)

Open user-setting files on the menu like below.

Preferences - Settings-User
Preferences - Key Bindings-User

Add a rule that you want to add or change by referring 'Preferences - Settings-Default' and 'Preferences - Key Bindings-Default'. Here is my settings code.

Settings-User:
{
"color_scheme": "Packages/Color Scheme - Default/Sunburst.tmTheme",
"font_face": "Bitstream Vera Sans Mono",
"font_size": 8
}

Key Bindings-User:

[

{ "keys": ["ctrl+5"], "command": "toggle_minimap" },

{ "keys": ["ctrl+6"], "command": "toggle_setting", "args": {"setting": "word_wrap"} }

]

The full paths of the user-setting files are like the followings.

C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User\Preferences.sublime-settings

C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User\Default (Windows).sublime-keymap

So if you want to keep your own settings after re-installing Windows or something like that, copy the 'C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User' folder and overwrite it after installing Sublime Text 2.

FileZilla FTP Client - Connected to the server, but does't list a directory? (파일질라 서버 연결은 됐는데 폴더, 디렉토리 목록 조회가 안 될 때)

- Set 'Transfer Settings - Transfer mode: Active'

- Add your 'FTP port' or 'FTP Client program' onto the list of Inbound rules of Windows Firewall

- 전송 모드를 Default나 Passive가 아닌 Active로 바꿈

- 윈도우즈 방화벽의 인바운드에 접속 포트를 추가, 혹은 FTP Client를 추가

Cool!

공인인증서 또는 ISP 인증서 저장 위치

1) 공인 인증서(범용, 은행/보험용) 파일 저장 위치
   - Windows XP/Vista
     C:\Program Files\NPKI

   - Windows 7(64bit)
     C:\Users\[사용자 아이디]\AppData\LocalLow\NPKI

  * 위의 폴더 하위에

       증권용은 SignKorea 폴더, 은행용은 Yessign 폴더, 기관용은 CrossCert 폴더 등의 아래에 User 폴더에 존재

2) ISP 인증서(BC카드 등) 파일 저장 위치
   - Windows XP
     C:\Windows\Application Data\VCard

   - Windows Vista/Windows 7(64bit)
     C:\Users\[사용자 아이디]\AppData\LocalLow\KVP\Application Data\Vcard

3) USB 저장 장치의 경우, 해당 드라이브 루트(최상위 폴더)에 위치
   - USB드라이브명:\NPKI
   - USB드라이브명:\Vcard


출처: 잡다한 세상 블로그 (http://experience.so/9)

Solving an unknown error while burning a DVD video with Windows DVD Maker

Windows DVD Maker is good. It has some cool templates of DVD menu so people can make a decent DVD video or slideshow, but it also sucks. It makes a 4:3 ratio video from a 16:9 ratio wide source with the 16:9 screen setting. In addition, it spits just one warning message of something like "An error occurred while burning your DVD." and that's it. There is not one line of explanation or easy-to-find log about what the problem is. The user can only say ... "So what?"

This writing is one of the solutions for the underlined problem of Windows DVD Maker.

1. Download and install MediaCoder 32bit or 64bit, which is an awesome and even free encoding program
2. Run MediaCoder and choose AVI format for container, H.264 for video and MP3 for audio in its settings wizard
3. Encode your videos with the setting above
4. Run Windows DVD Maker and add your encoded .avi videos onto the list and burn!

Use a different blank DVD from the one you used when the error happened.

The problem seems it happens when the added video is encoded in a way that Windows DVD Maker cannot figure out while its trans-coding process after you click the Burn button.

Anyway, thank you, Colin MM

Source: At the end of http://social.technet.microsoft.com/Forums/windows/en-US/5a91b210-65ca-448b-82a9-ad8dbe8df782/windows-dvd-maker-error-an-error-occurred-when-burning-the-dvd-help?

And ...

COME ON, BIG COMPANY!



윈도우 DVD 메이커로 DVD 비디오를 구우려고 하면 오류를 뿜으며 계속 실패하는 문제에 대한 해결방법

1. MediaCoder를 다운로드 받아서 실행시킨 후
2. 설정 마법사에서 포맷은 AVI, 비디오는 H.264, 오디오는 MP3로 설정한 다음
3. 구우려는 동영상을 위 설정으로 인코딩 하고
4. 윈도우 DVD 메이커에서 불어와서 구우면 된다는 말씀!

출처는 위 링크의 마지막 댓글 참조.