Feature #32108

Option in core or plugin which convert file from MS Excel or LibreOffice to redmine table

Added by Tadeusz Miszczyk about 3 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Plugin Request
Target version:-
Resolution:

Description

Hi,
Where can I find some plugin which convert files ods (LibreOffice) or xls (Microsoft Office) to redmine table?

For now, I and my friends are using my own tool (https://www.s2rc.miszczyk.dev) but it is very old (about 4 years) and built-in option or plugin would be much better.

Currently my tool only supports:

  • Calculating formulas ( for example: "=sum(A7:K17)" )
  • Merged cells
  • Bold font
  • Italic font
  • Font color
  • Background color
  • Text aligning (left/center/right)

I would be nice if built-in option or plugin create the same output or better.

Output from my tool using xls file (converted from ods file in LibreOffice) :

Komórki scalone poziomo
1 2 3 <= suma A2 + C2 email test I2 J2 Komórki scalone pionowo
A3 B3 D3 cyfry napis maska
komórka B4 Warka F4 H4
B5 C5 paczka pokolenie asd 8 Informacja
Dużo informacji E6 pokaz obok pusta
1 2 3 4 5 6 7 8 9 10 55
2 4 6 8 10 12 14 16 18 20 110
3 6 9 12 15 18 21 24 27 30 165
4 8 12 16 20 24 28 32 36 40 220
5 10 15 20 25 30 35 40 45 50 275
6 12 18 24 30 36 42 48 54 60 330
7 14 21 28 35 42 49 56 63 70 385
8 16 24 32 40 48 56 64 72 80 440
9 18 27 36 45 54 63 72 81 90 495
10 20 30 40 50 60 70 80 90 100 550
55 110 165 220 275 330 385 440 495 550 3025

test_merged_cells.xls - Example file which I convert to Redmine (18 KB) Tadeusz Miszczyk, 2019-09-22 00:54

Also available in: Atom PDF