color – Why are word processors blue and spreadsheet programs green?

I believe that this is just following the idea that the market leader (in this case: Microsoft) had.

There is an interesting article about the history of MS Office software here: which may explain more.

Originally, teal colour was used in the icons of both MS Word and MS Excel applications. The icons had a different shape, though. At some point (as the article screenshots show: in 1999) the developer decided to use different colours to easier tell one from another.

At that time, due to the obvious market leadership, the applications themselves were equated with their purpose (so instead of saying: “Send me that rich text document!” we used “Send me that Word (file)!” and similarly “spreadsheet” = “Excel (file)” etc.).

What was behind the choice of a specific colour may be hard to identify now, but the sole fact of making them different allowed to make easy connection between the application icon and the file icon, as both of them contained the same elements (namely: the file icon contained the icon of the app opening it). This reduced the cognitive load used to identify the right subset of files in a long list of them (look for green if you want a spreadsheet and blue if you want a text document).

From now on the convention was followed about using green for Excel, dark blue for Word, and other dedicated colours for the rest of the applications in the package. The competitive solutions started following many conventions regarding the UX of the software, compatibility, formats etc. Between them, the colour convention was apparently followed as well.

One more thing regarding the choice of colours is that for the User who, in many cases, was familiar with Excel greens and Word blues, leaving the same convention would, again, limit the cognitive load when moving from one solution to another.

Count occurrences of a specific word in Google Spreadsheet

I have some cells with text. I need to count the occurrences of a specific word from those cells.

Example sheet:

How do I merge two rows based on a column match.(Google Spreadsheet)?

I have a sheet that gets values through two forms it looks something like that:

ID        |Name     | Agreement
2324      |Lina     |
2324      |         |I agree

I want to achieve this :

ID        |Name     | Agreement
2324      |Lina     | I agree

I want to merge any two rows that have the same ID value,
I’m new to google sheets , so any help is so much appreciated.

javascript – Create a function to upload and import spreadsheet file to google sheets?

I have successfully created a button to execute a function that will actually grab the file off on my computer. But will not to completely import the data of that file into a new sheet tab.

My current code is:

 * Displays an HTML-service dialog in Google Sheets that contains client-side
 * JavaScript code for the Google Picker API.
function showPicker() {
  var html = HtmlService.createHtmlOutputFromFile('dialog2.html')
  SpreadsheetApp.getUi().showModalDialog(html, 'Select a file');

 * Gets the user's OAuth 2.0 access token so that it can be passed to Picker.
 * This technique keeps Picker from needing to show its own authorization
 * dialog, but is only possible if the OAuth scope that Picker needs is
 * available in Apps Script. In this case, the function includes an unused call
 * to a DriveApp method to ensure that Apps Script requests access to all files
 * in the user's Drive.
 * @return {string} The user's OAuth 2.0 access token.
function getOAuthToken() {
  return ScriptApp.getOAuthToken();

function upload(obj) {
  var file = DriveApp.createFile(obj.upload);
  return {
    fileId: file.getId(),
    mimeType: file.getMimeType(),
    fileName: file.getName(),


<!DOCTYPE html>
    <base target="_top">
    <link rel="stylesheet" href="">
  <form> <!-- Modified -->
    <div id="progress" ></div>
    <input type="file" name="upload" id="file">
    <input type="button" value="Submit" class="action" onclick="form_data(this.parentNode)" >
    <input type="button" value="Close" onclick="" />
    function form_data(obj){ // Modified;
    function closeIt(e){ // Modified

sharing – A private copy of a Google sheet for each person authorized to access the main spreadsheet

here is my problem.

I have prepared a Google sheet which allows me to simulate many budget allocations that my local government could grant to applicant companies. Stuff like "the government will fund 50% of type a and type b spending up to a maximum of 80% of type c spending".

Ideally I would like to share this spreadsheet with everyone interested, but each user should have access to their own copy. If they all have access to the same sheet, they will actually be working on the same budget simulation, when I would like everyone to use a "private" simulation.

Do you know if this is possible in Google Sheets? If yes, how?

Thanks in advance.

Can I add a single auto-increment field to multiple responses in a column of a Google spreadsheet based on a Google form?

I need to add a single auto-increment field to multiple responses in a column of a Google spreadsheet based on a Google form.

I was able to add the function trigger in the scripts, but I need to add auto-increment to multiple items from a drop-down list in one of the responses. What I am trying to accomplish is to create a multimedia database with individual multimedia file codes. For example, if one of my videos was filmed in St. Louis, Missouri, I would have something like "stl_adv_23" and if one of my videos was filmed in Tulsa, OK, then this entry would be "tul_adv_7" and so on. So when the user fills in the first question on the form and the responses of multiple city codes in a drop down list, I want the auto increment to then add the next sequential number for that specific drop down answer and not just the next line in the set for all answers. How to do this in the script editor?

I used this answer as a starting point and it worked, but I need the additional function above

The SharePoint list "Export to Excel" produces a spreadsheet which, when re-imported into SharePoint, does not keep the correct column types

Desired behavior

Export a SharePoint list to a CSV or Excel file in a format that can be re-imported into SharePoint as a list with all correctly formatted column types and values.

The reason why this functionality is required is to ensure that all backed up SharePoint lists can be restored quickly and easily.

Current behavior

Importing a file created by clicking on Export to Excel from a SharePoint list (which prompts you to download a .iqy file which, once opened, can be saved .xlsx file) results in a list where the column types are incorrect and the values ​​are not formatted correctly.

What I have tried

By following the instructions in the following article, it should be possible to create a SharePoint list from the exported Excel document:

Create a list based on a spreadsheet

The article does, however, have this caveat:

Note: Typically, columns are configured on the SharePoint site based on the type of data they contain. However, after importing a list, you need to inspect the columns and data to make sure everything was imported as expected. For example, you may want to specify that a column contains a currency rather than a simple number. To view or modify the list settings, open the list and from the Settings menu, select List settings.

More specifically, these are the results I get (the exclamation mark ! indicates an incorrect column type):

|                Column                |      Original Type     |    Imported Type       |
| Title                                | Single line of text    | Single line of text    |
| MySingleLineOfTextColumn             | Single line of text    | Single line of text    |
| MyMultipleLinesOfTextColumn          | Multiple lines of text | Multiple lines of text |
| MyLocationColumn                     | Location               | Single line of text !  |
| MyNumberColumn                       | Number                 | Number                 |
| MyYesNoColumn                        | Yes/No                 | Yes/No                 |
| MyPersonColumn                       | Person or Group        | Single line of text !  |
| MyDateColumn                         | Date and Time          | Date and Time          |
| MyChoiceColumnMultiWithSelections    | Choice                 | Single line of text !  |
| MyChoiceColumnMultiWithoutSelections | Choice                 | Single line of text !  |
| MyChoiceColumnSingleWithSelection    | Choice                 | Single line of text !  |
| MyChoiceColumnSingleWithoutSelection | Choice                 | Single line of text !  |
| MyHyperlinkColumn                    | Hyperlink or Picture   | Hyperlink or Picture   |
| MyPictureColumn                      | Hyperlink or Picture   | Hyperlink or Picture   |
| MyCurrencyColumn                     | Currency               | Currency               |
| Modified                             | Date and Time          | Date and Time          |
| Created                              | Date and Time          | Date and Time          |
| Created By                           | Person or Group        | Person or Group        |
| Modified By                          | Person or Group        | Person or Group        |

The following columns therefore have the incorrect type:

|                Column                |      Original Type     |    Imported Type       |
| MyLocationColumn                     | Location               | Single line of text !  |
| MyPersonColumn                       | Person or Group        | Single line of text !  |
| MyChoiceColumnMultiWithSelections    | Choice                 | Single line of text !  |
| MyChoiceColumnMultiWithoutSelections | Choice                 | Single line of text !  |
| MyChoiceColumnSingleWithSelection    | Choice                 | Single line of text !  |
| MyChoiceColumnSingleWithoutSelection | Choice                 | Single line of text !  |

Strangely, Person or Group works when these are values ​​added automatically by SharePoint, i.e. Created By and Modified By columns, but not when I searched for and selected a user in a Person or Group column.

In the List Parameters area, if I change the column type of all the columns that should be choice columns of choice (with the relevant parameters of “ check boxes (allow multiple selections) '' & # 39; & # 39 ;, and that I have to manually set all available options), then the values ​​from the list interface are displayed correctly.

So what was posted at Choice1;#Choice2;#Choice3 is now displayed as Choice1, Choice2, Choice3 and the relevant selections are "checked" when editing the items.

It is not possible to change the column type of columns which must have types of Location and Person or Group, however, because they are both now Single line of text type.


What should all column type values ​​be before they can be imported correctly into SharePoint?

Or, perhaps more specifically, how should the values ​​be exported so that they can be re-imported correctly into SharePoint?

PS …

I noticed when exporting the list and opening the result .iqy file, I get the message:

The table contains a string too long for Excel to be displayed. If you change the long value, some data may be lost.

So therefore the Location column value is truncated, how to work around this problem when you want to save content that includes a location?

Google Script: Spreadsheet: how to switch between data fit and specific height (row height adjustment)

I want to program my script to switch between two line heights (default and automatic adjustment) using a self-programmed button in the Google spreadsheet. But once the row is adjusted automatically, there is no way to reset the row height to a certain height. I want to expand the line to display all the chips in the cell when needed.

spreadsheet function – Excel TREND () input tables consisting of multiple ranges

Is it possible to create entries (known_y a known_x) for TREND function, when cells are not in a single range?


I want to compare the average value (B2) with TREND result (without rearranging the table)

|   | A  | B  |
| 1 | X  | Y  |
| 2 | 0  | 0  |
| 3 | 5  | 5  |
| 4 | 10 | 10 |

It means that known_y are {B2; B4}, known_x {A2; A4}.

So i tried to create a matrix for TREND input tables: =TREND({B2;B4},{A2;A4};A5) but this is not recognized as an appropriate function. It seems that the references are not authorized in the matrices made manually (simple ={A1;A2} doesn't work either).

Is there a trick to get the desired behavior without creating a new table where TREND will the input data be in a range?

Thanks for your advice and sorry for my English.

phpexcel – Error exporting a DB spreadsheet to php

Guys, the spreadsheet comes out with all of the HTML content on the INDEX page, not just the table created.

Can anyone help me?

Follow the code

class Export{

public static function excel(){

$dadosXls  = "";
$dadosXls .= "  ";
$dadosXls .= "          ";
$dadosXls .= "          ";
$dadosXls .= "          ";
$dadosXls .= "          ";
$dadosXls .= "      ";

$sql = Mysql::conectar()->prepare("SELECT Codigo,Descricao,Quantidade FROM `registro`");


while($res = $sql->fetch(PDO::FETCH_ASSOC)):
    $dadosXls .= "      ";
    $dadosXls .= "          ";
    $dadosXls .= "          ";
    $dadosXls .= "          ";
    $dadosXls .= "      ";
$dadosXls .= "  
"; // Definimos o nome do arquivo que será exportado $arquivo = "MinhaPlanilha.xls"; // Configurações header para forçar o download header('Content-Type: application/');

header (& # 39; Content-Disposition: attachment; filename = "& # 39 ;. $ file. & # 39;" & # 39;);
header (& # 39; Cache-Control: max-age = 0 & # 39;);
echo $ dataXls;


insert description of image here