My question is why can LO Calc, apparently by default, remove this attribute and allow an otherwise previously encrypted file to be saved as an un-encrypted file without my overtly removing that attribute? However as a user, I should be able to assume that if I have assigned a spreadsheet file the security-related attribute of “password protected”, then my action of later editing and saving the changed original with a different name would mean that the new file inherits the original file’s security attribute and will remain encrypted until I make an overt act to remove that attribute. Import it into the Canvas gradebook and follow the directions onscreen.I agree if I were saving an unprotected spreadsheet in either Excel or Calc.

Now put column headings in the first row:.

Next, insert two empty columns between the name column and the score columns.Deleting columns is similar to deleting rows. Keep the columns that contain scores themselves, and the column with the combined names.

Select Home > Insert > Delete Sheet Rows.Keep the rows that contain scores themselves, the row with the name of the assignments, and the row with the number of points possible in each assignment.Next we must delete all the extraneous rows and columns.In Microsoft Excel, select Home > Paste > Paste Values. Then uncheck 'Paste all' and check only 'Text'. In LibreOffice Calc, select Edit > Paste Special.In LibreOffice Calc, select Edit > Cut.Ĭombined names have been cut to the clipboard.Next we must save our combined names as text, not formulas.In Microsoft Excel, select Home > Fill > Down. In LibreOffice Calc, select Data > Fill Cells > Down.

Select cell C8 and all the cells below it, all the way down to the last student row.In cell C8, enter the formula =CONCATENATE(D8,', ',E8).In LibreOffice Calc, select Sheet > Insert Columns > Columns Left.In Microsoft Excel, select Home > Insert > Insert Sheet Columns.Select a cell in the 'Last name' column.We must combine the 'Last name' and 'First name' fields as follows:.The first step is to open your csv file containing scores in a spreadsheet editor, such as LibreOffice Calc or Microsoft Excel.Ī csv file containing several assignments. Reformatting grades for Canvas Reformatting grades in a csv file for Canvas import

Libre excel