RelatedĬonverting Excel files into Google Sheets and Excel Vs. Regarding how to apply borders based on cell content, instead of using the built-in conditional formatting feature use an on edit / on change trigger from Google Apps Script to apply the borders.ĭisclaimer: I didn't reviewed your Excel file neither the Google Sheets linked spreadsheet, so I can't tell what could be the best approach in your specific case. Amongst many others, we support PDF, XLSX, XLS, CSV, ODS. These only break the functionality further though.Īt this time Google Sheets is not able to reliably convert all the Excel files into Google Sheets format by one hand because Google Sheets hasn't all the features that Excel has by the other because there are some features on converted files that Google Sheets hasn't an user interface nor the Google Sheets API has a resource able to access them.īy the way there are some features that doesn't work the same way.Ĭonsidering the above, IMHO, on certain cases the best is to create a Google Sheets spreadsheet from scratch. CloudConvert is an online document and spreadsheet converter. I've tried changing the rule to =ISNUMBER($A$1), =ISNUMBER(A1), and Applies to: $B1:$R1, among other things. Perhaps there is a clever way to edit this rule in Excel in order to make it translate properly to Google Sheets in the background? The conditional formatting rule working in the background here is: In Google Sheets, the border is applied two rows down instead. You can see how it's meant to function by opening it in Excel, but to describe the intended functionality: If you enter text into a cell in Column B, a number is added in the cell to the left (works correctly) and a top border is applied to the cell through Column R. Here is the same spreadsheet converted to a Google Sheet.Įxcel applies the borders through conditional formatting, and they are somehow maintained in the transfer to the Google Sheets format, slightly broken. I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |