Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

With JExcel, you can copy issues from Excel to JExcel and back.

Copying cells from JExcel to Excel

You can copy cells from JExcel to Excel in two ways:

  • select the cells you want to copy and press Ctrl+C 
    • then open an Excel file and press Ctrl+V to paste the cells
    • then open an Excel file and press right click and select "paste" to paste the cells
  • select the cells and right click on them and select Copy from the dialog  
      • then open an Excel file and press Ctrl+V to paste the cells
      • then open an Excel file and press right click and select "paste" to paste the cells
Image RemovedImage Added

Copying cells from Excel to JExcel:

To create multiple issues, you need to use the import feature of JExcel.

To do the import, you need to use a Notepad or an Excel.

When wanting to import there are 3 mandatory columns you need to have in Excel

Panel
borderColororange
borderStylesolid
  • Summary
  • Issue Type
  • Project

After filling out the columns, select the cells you want to import and press Ctrl+C.

Image RemovedImage Added

There are 3 ways to copy them into JExcel:

  1. Press Ctrl+M then Ctrl+V in JExcel
  2. Open Workbook menu and clicking on Import... option and press Ctrl+V
  3. Or just press Ctrl+V
Image RemovedImage Added

If you choose the way 1 or 2,  you will get a dialog like this with some useful information on it.

When you see this dialog, press Ctrl+V to preview the import.

Image RemovedImage Added

If there is any problem with the import, you will see the problematic cells coloured red. 

If you hover over the red cells, there will be an error message of it, so you will be able to see the problem.


To fix the problem, go back to your Excel file or change the value right in the import screen. Just double click in the cell you want to edit and hit Enter when you finished.

(Please make sure that you paste values with correct column names.)


After fixing the problems, you will see the preview without any red cells and you can click on Create.

Image RemovedImage Added






Panel
borderColororange
borderStylesolid

If you choose the way 3, you have to pay attention to an important thing!

The cells will be imported right where you stand!


Panel
borderColorgreen
borderStylesolid

Pro tipp

The easiest way to import issues is to copy from JExcel to Excel, change values and then to copy back to JExcel.

This way you can avoid making mistakes.


Panel
borderColornavy
borderStylesolid

Copying cells within JExcel:

If you want to copy only one cell, you can do it without the import dialog.

If you want to copy more cells than it works with the import dialog.

To see how the import dialog works, see the previous section "Copying cells from Excel to JExcel".