How to edit the office file without changing the file format from Gmail and Google Drive

-

When we work with cross platforms like Microsoft and Google, it is quite helpful to create, change and update files in a single format without changing the another file format.

For example, we received a mail with a Microsoft Excel attachment in the Gmail and we needed to do a small change in the Excel File without converting it to the google sheet and retaining the file format as .xlsx. Now it can be done simply via Gmail and Google Drive itself.

Here what we did

This was the mail what we received with a MS excel attachment.

Gmail with MS Excel attachment

In the attachment you will see the edit icon, by clicking the edit icon, the excel file will open in new tab as google doc with MS excel format .xslx and copay of file has stored in your google drive.

Excel opened in Google doc

Now you can do changes and save it as.xslx file. To reply along with original mail and document, you can use "File" and click email, next reply with file or open original message. 

Reply with original excel file in Gmail

Supporting google files

  • Docs
  • Sheet
  • Slids

Supporting Office files

  • Word files: .doc, .docx, .dot
  • Excel files: .xls, .xlsx, .xlsm, .xlt 
  • PowerPoint files: .ppt, .pptx, .pps, .pot 

Note: if you have enabled the Chrome Extension in the browser, you have to disable it first to use this feature.

Comments

Post a Comment

Popular posts from this blog

How to clearly identify the "Cancellation" document in SAP Business One

-
Image
How to clearly identify the "Cancellation" document in SAP Business One When raising a cancellation document against an AR or AP document, it shows the status as closed with "Cancellation" in the new cancellation document, and the canceled document's status shows as Canceled. But, when you write a query report in SAP Business One how could you significantly identify the canceled document and cancellation document against the right one. Referring one by one in each document is a difficult one and there should be the easiest way to identify the cancellation. What would be the best practice? If you plan to implement an SAP B1 with number series, it is good to configure a separate number series for the Cancellation Document. Unless those cancellation documents will get the exiting number series and it is difficult to find which document would be canceled with the number series. There is an option in the Document Numbering - Setup called "Cancellation" und...
Read more

How to add "If" and "Else" conditional formula in PLD at SAP Business One ?

-
Image
It is effective to maintain SAP Business One PLDs for print layout requirements. Sometimes, companies require complex scenarios match to the PLDs and get the printouts. Limitation in PLD There is no "If" and "Else" conditional formula in SAP Business One at Print Layout Designer. But, it is an essential conditional statement to display some values in the fields according to the conditions. Thereby, we would like to introduce a workaround method to apply the "If "condition at PLD by overcoming such limitations. What is the scenario? Our scenario is, display the "Ship To" and "Deliver To" in the purchase order PLD according to the vendor type like "Foreign Vendor" and "Local Vendor". If the PO has been raised for Local Vendor, the "Delivery To" statement has to be mentioned in the layout, else Foreign Vendor, the "Ship To" statement has to be mentioned in the layout. Solution We would create for n...
Read more

How to Create the PKCS12 file and including SSL Certificate and Key through OpenSSL

-
Image
When you are requiring to enable a secured connection for your web application or device that you need to have a PKCS12 file in order to encrypt and authenticate the data. Especially, in SAP Business One is required to have a PKCS12 certificate for its services such as SLD, Browser Access and Service Layer, etc. Refer to the below steps to generate .p12 file for SAP Business One installation.  Before moving to dive, let's clear doubts in major areas. What protocols are used to facilitate secured communication? Mainly there are two protocols such as SSL "Secure Sockets Layer" and TLS "Transport Layer Security" that are used to secure the connection and it enables data encryption, integrity, and authentication. How do you identify that data has not been read and has not been changed by someone? To overcome these problems, the SSL/TLS uses data encryption and digital signature to identify the sender and make sure data has not been changed. The encrypted data can...
Read more