*************************** ELN add-on ******************************

ELN Changelog per year:

2011 / 2012 / 2013 / 2014
2015 / 2016 / 2017 / 2018
2019 / 2020 / 2021 / 2022


************** 2011 **************
# 2.10
2011/11/21: add functions: 
    -download excel files
    -view excel files in PDF and print document
    -view version number for pages
    -can't edit a page if already open by an other user (lock page if editing)
    -merge two or more pages in print / pdf view

# 2.11
2011/12/16
    -new typo supported in PDF:
        korean (configure you browser to read korean langage)
        chinese (configure you browser to read chinese langage)
        japanese
2011/12/23
    -new icon for iPad

************** 2012 **************

# 2.12
2012/01/11
    -add new setup for font in PDF:
        in file "html2pdf/html2pdf_config.php", setup is $default_pdf_font;
        if not set / void: the default font will be helvetica;
        change this value to a PHP file name in "html2pdf/_tcpdf_5.0.002/fonts/" to change default font (exp "arialunicid0" for "arialunicid0.php");
        you can choose / create your own PHP font.
    -japanese characters in PDF is now defined by web browser's langage configuration
    -lightest PDF for only occidental characters document

# 2.13
2012/02/27
    -bug fix: markup 'captation' and 'colgroup' in PDF. Users can add other markup.
    -new install & update script (more space for pages contents)
    -new upload image (fix bug)

# 2.14
2012/05/15
    -bug fix: Edit/lock protection on pages, user name on editing lock alert corrected
    -bug fix: add template had no ckeditor
    -added workflow name on experiment level
    -added template name on page
    -added template name + instructions on edit page
    
# 2.15
2012/05/31
    -bug fix: added JS support on content level
    -applet spreadsheet OBJECT/EMBED on create from empty sheet
    -bug fix: ckeditor toolbar missing icons are back

#2.16
2012/11/20
    - ADMIN sees all books inside GROUP
    - View All Books Tab: visibility parameter in Admin menu
    - Admin>>Page signing & validation take care of groups
    - bug fix: Records linked view (for links, URLS, images, files)

************** 2013 **************

#2.17
2013/03/21
    - New CKEditor
    - NEw Spreadsheet applet

2013/05/13
    - Bug correction on admin & validation signing pages

#2.18
2013/09/13
    - IE10 layout bug corrected
    - JAva applets resigned and improved

#2.20
2013/11/28
    - added new management custom field
    - new custom field selection on template
    - New Custom Field : Grid
    - bug fix : new task/check/edit redirection
    - buf fix : add/edit WF template redirects to WF/template listing
    - New edition for pages, expr and book
    - New PasteButton in CKeditor (plugins)
    - sign page require sign identification or sign certificat 
    - added management of digital certificat option
    - IE10 New Css
    - new PopUP changed the Modalbox for Fancybox
    - Java applets resigned and improved
    - Tree search now works on special chars
    - Improved and corrected PRINT and PDF exports

#2.20 rev1
2013/12/02
    - IE11 support for Word copy/paste with images 
    - Print and Export bugs
    - Encoding bugs
    - linking bugs
    
#2.20 rev2
2013/12/04 
    - Print and Export bugs
    - Signing Options bug

#2.20 rev3
2013/12/18 
    - ckeditor bugs corrected


#2.20 rev4
2013/12/20 
    - Bug on H1-H6 style for printing and PDF

************** 2014 **************
    
#2.21
2014/01/15
    - New Ckeditor version 3.4
    - New simpleuploads version 4.1
    - New Ckeditor plugin Long String 
    - New Ckeditor plugin Help
    - Lang bug
    - Optimise Java loading

#2.22
2014/01/15
    - Fix Bug already doublons with chekbox custom field
    - Script Sql to delete doublon Custom Field on page
    - New Css color for Save/Edit button
    - Footer fixed at bottom
    - New information for division on ckeditor
    
#2.3
2014/04/22
    - New admin management All Books (Read/Write)
    - New admin management for create Books/Projects
    - New Custom Field Link
    - New ckeditor plugins Molecule with chemtool license
    - New ckeditor plugins Lc_Photobank 
    - Reworking of search  
    - The activate options appear in License 
    - Fix Bugs charset
    - Fix Bugs broken images (ckeditor)
    - Fix window tiff (Imagick)
    - Improved ckeditor automatic history backup: automatic history targeted to each ELN zone (pages, experiments, books, templates) 
    
#2.35
    - Changing the loading system of tree
    - New tree icons 
    - New page types
    - Change Barcode CODE36 to CODE128
    - Added database index for book/experiment/page
    
#2.4 
    - News functions Recover Content and Recover for version
    - Bug fix : back to authentification page when user session breaked
    - Bug fix : book description saved in book history
    - Bug fix : image breaked in history
    
#3.0
2014/12/16
    - New: interface
    - Box Maps & plates integration
    - New advanced roles and permissions
    - New templates and workflow management
    - New: ZIP export of pages, experiments, books
    - New: File uploads to HDD or DB
    - New: changed PDF generator
    - NEW: TAGs associated to pages

 #3.01
2014/12/23
    - Bugs corrections
    - applet resigned

************** 2015 **************

#3.05	
2015/01/19
    - BUG in templates management
    - BUG in character encoding
    - BUG: templates editing and management
    - BUG: Workflow editing and management

#3.06	
2015/02/04
    - BUG: Template permissions
    
#3.07
2015/02/10
    - BUG: Template options
    
#3.08
2015/02/14
    - BUG: default template management
    - BUG: tooltip for boxes / clean display
2015/02/20
    - BUG: book permission on non superadmin	
2015/02/23:
    - BUG: book permission error on non superadmin
    - BUG: Fancy box size on books permission popup
#3.09
2015/02/24:
    - BUG: templates problem when no default exist (template_id 1)
    - BUG: page display with no template
#3.10
2015/03/10
    - BUG: Book permissions popup problems
    - BUG: Tags autocompletes when editing/adding
    - BUG: Tree now loads in full to facilitate searches
#3.11
2015/04/01
    - BUG: Tree filter for ALL BOOKS
    - BUG: eln_options value field size too short
    - BUG: eln upload table fields
    - BUG: edit tags
    - BUG Template/WorkFlow access for non admin/PI users

#3.12
2015/04/17	
    - BUG: EDIT button on boxes in pages.
    - BUG: Image displayer tool panel width
    - BUG: PDF & PRINT generator page order.
    - BUG: custo Fields saving and improve in display with helper tooltip.
    

2015/05/19
    BUG: Sign button not showing
    BUG: JS files

#3.13
2015/07/15
    BUG: EDIT collaborations on books when PI. Was overwriting owner info.
    ADDED: option to remove signature image
    BUG: page display in the admin signing list
    BUG: unarchive/archive button bug.
    
    
#3.5
10/12/2015
    BUG: refresh tree on experiment level
    NEW: New interface UI design

************** 2016 **************
#3.51
23/01/2016
    BUG: Major JxCell/spreadsheet loading bug	
    BUG: Add New Page/Exp/Book fancybx adjustment
    BUG: missing images
    BUG: adjustment of icons on page content (flat design)
    BUG: diagram objects resizing (jquery-ui)
    BUG: collaboration tree was not showing locks
    BUG: sign fancybox too short. Height adapted for FF
    BUG: fancybox to add experiments and books in FF (height)
    BUG: Edit Experiment name inline ajax call
    
#3.52
28/01/2016
    BUG: Edit names encoding (UTF8)
    BUG: admin page signing / vaidation open page preview corrected to fancybox
    BUG: Advanced permissions settings & PI Definitions
    BUG: View All Books

#3.53	
14/02/2016
    IMPROVED: keep session alive ajax call (every 10min)
    BUG: license demo days left
    BUG: LC link zone bug in older PHP
    BUG/ADDED: upload files with -, ), ( characters
    
#3.54	
22/02/2016
    BUG: license page display
    BUG: page upload/attach audit log
    BUG: Delete LC link on pages. Added also a confirmation dialog. Hides internal LC search after linking

#3.55	
01/03/2016
    BUG: mixed up user variables conflicting with main LabCollector

#3.6
24/05/2016
    NEW: Image editor: upload and/or edit images (crop, apply filters, annotate texts & stickers)
    NEW: Manage image stickers: predefined images plus custom images
    NEW: Upload multiple files at once, clicking or drag-n-drop
    NEW: Upload page image. See thumbnail in top right corner. Included in page print & PDF 
    NEW: Auto login time out (activated in ADMIN menu options) set a timeout before blur page and force to enter password to continue
    NEW: Button duplicate in template list
    NEW: Confirmation when exit/change page without saving
    NEW: Drag & drop of pages and experiment
    NEW: Flat spreadsheet
    NEW: API to connect with mobile app
    IMPROVED: Update ckeditor 4.5.7, remove a few buttons & applet Java
    IMPROVED: No block page if user editing equal user logged
    IMPROVED: Show template description in page
    IMPROVED: Workflow logic: all users can see WF created by superadmin
    IMPROVED: Choose Box/Microplate as template option 
    IMPROVED: Search options improved to adapt all screen sizes 
    IMPROVED: System of backup/restore of content editor on pages and description on books & experiments
    IMPROVED: New arrows & forms in diagram designer
    IMPROVED: Button 'Add Next Page' in page menu
    IMPROVED: Certificate options mutually exclusive
    IMPROVED: Buttons to open LabCollector data
    BUG: If user editing not equal user logged, edit buttons must be blocked
    BUG: Field 'Admin validation required' on pages
    BUG: Order of tasks in WF
    BUG: Upload files with spaces
    BUG: When big images in content, edit button was not visible
    BUG: Mandatory fields, display asterisk, fix error message & do not allow sign/close the page without them
    BUG: Audit trail not saving attach file details
    BUG: Admin certificate options are not responding well
    BUG: Options of FileSystem storage
    BUG: Edit Box/Microplate in experiment level
    BUG: Fullscreeen in spreadsheet
    BUG: Prevent creating pages without names
    BUG: Unable to close own pages, if authentication mode = 'login'
    BUG: Padlock doesn't appear in tree after close page
    BUG: Boxes/microplates don't appear in print view
    
#3.601
02/06/2016
    BUG: Spreadsheet save in FF
    
#3.61
06/10/2016
    NEW: Book field 'Project code' (based on LC project code manager). Searchable and filterable 
    NEW: Component 'Infographic' on pages and templates, integrated with Mindthegraph tool
    NEW: Plugin 'Infographic' in content editor, integrated with Mindthegraph tool
    NEW: Plugin 'Plate' in content editor, that insert a plate 96 as HTML table
    NEW: Plugin 'LabCollector' to allow insert links to records of LabCollector
    IMPROVED: Component 'LabCollector data'. Includes creation of new records of LabCollector
    IMPROVED: Web layer of Excel spreadsheets has been improved. Signed for HTTPS
    IMPROVED: Associate spreadsheet template to a page template
    IMPROVED: Paste image on Internet Explorer
    BUG: Flat spreadsheet support special characters
    
#3.62
10/10/2016
    BUG: Default template missing
    BUG: Upgrade from previous version fails		
    BUG: Open spreadsheet using protocol HTTPS
    BUG: Edit content fails if computer language is German
    
#3.63
30/11/2016
    NEW: ZOHO spreadsheet integration 
    NEW: Spreadsheet editor selector
    NEW: Import spreadsheet from hard disk 
    NEW: Templates for flat spreadsheet
    IMPROVED: Update flat spreadsheet engine
    IMPROVED: Update image editor PhotoeditorSDK v3.5
    IMPROVED: View image stickers classified by category
    IMPROVED: Bigger window of image editor to facilitate the annotations of images
    IMPROVED: PDF export includes spreadsheets
    IMPROVED: Update CKEditor v4.6
    IMPROVED: New skin for content editor
    IMPROVED: Copy content from word keeps format and includes images
    IMPROVED: Show structure in LabCollector data linked
    BUG: Photobank plugin very tiny
    BUG: Labcollector plugin opens blank page
    BUG: Content editor in fullscreen mode hides plugins 
    BUG: Close a page while in EDIT mode and content is lost
    BUG: Error saving flat spreadsheet	
    BUG: Sign all pages must not include own pages
    BUG: Templates search
    BUG: Change page name changes page icon
    BUG: Save in audit trail when deleting attached files

************** 2017 **************

#3.64
23/01/2017
    BUG: Closed pages with Jxcell spreadsheet are not loaded    
    BUG: Encodding issue in admin->manage permissions
    BUG: Encodding issue in LabCollector linked data
    BUG: Button link LabCollector data does nothing after edit a comment  
    BUG: Update license does not refresh session
    IMPROVED: Increase number Labcollector links in pages and experiments to unlimited    
    NEW: View CIF files in LabCollector linked data	

#3.641
27/01/2017
    BUG: Pages get hanged or take a long time when saving very long contents 
    BUG: LabCollector modules renamed or hidden are not refreshed on the ELN module list
    BUG: Group members can't link LabCollector shared records
    BUG: Only admin could recover content of pages
    BUG: Admins and users with permissions to see all books only saw their books in the search list
    BUG: Search by tag 
    BUG: Diagram designer install
    IMPROVED: All users with permissions to create templates can add and edit spreadsheet templates
01/02/2017
    BUG: Filter by dates
    IMPROVED: Display datepickers in search by dates
06/02/2017
    IMPROVED: Show Book/Page/Exp ID on tree and top of content
    IMPROVED: Delete page button removed in WF if not last page in WF
    IMPROVED: Move restriction on WF tree elements
    IMPROVED: Remove box grid (box map)
    IMPROVED: Green color on tree filter icon when there is an active filter
    IMPROVED: Installer mustn't remove tables neither reload itself after errors
    BUG: Download file issue in Chrome
10/02/2017
    BUG: Barcode in print/PDF
    IMPROVED: PDF name and styles
14/02/2017
    BUG: Search in items of other owners if superadmin or VAB permissions
    BUG: Search results aligned vertically
    BUG: There is no way of revoke PI permissions if user is no longer administrator on LabCollector

#3.642	
20/02/2017
    BUG: Install fails: attempt to create some tables that exist

#3.65	
05/04/2017	
    IMPROVED: Plugin Molecule and Reactions revamped
    - all images are generated in .png on browser, no further installation neither code or temp folders to convert images on server is needed
    - draw new molecules
    - search on LabCollector or memorized data
    - cells of reactions are editables,
    - drag'n'drop of elements
    - ability to add/remove columns/rows
    - reuse templates
    - admin->template->reaction template
    - when reaction is inserted in content: not to insert inside other object
    IMPROVED: Diagram designer improved
    - replace jmol plugin by molsoft, all images are generated in .png on browser
    - draw new molecules
    - add memorized structures from LabCollector
    - add structures already linked in page 
    - view images of arrows/forms in menu
    - auto-save texts 
    - print preview (diagram menu) and export PDF (page menu)
    IMPROVED: LabCollector data
    - added button "Memorized" to link memorized records from LabCollector 
    - prevent to insert duplicates
    - inserting a structure in content using reactions plugin, or in diagram, involves a link in LabCollector data is created	
    IMPROVED: Custom fields
    - text fields: length restriction. textbox have maxlenght set to prevent write more text that would be truncated
    - grid fields: import from CSV now works
    - grid fields: buttons to edit/save/cancel were too big, now they are small like on other components
    - show helper text when defined
    - date field: added popup calendar
    - align all custom fields to left
    IMPROVED: Well plates plugin, dropdown to select different types (plate96, plate384, plate48, plate24, plate12, plate6)
    IMPROVED: New icons for pages (flask, molecule)
    IMPROVED: Remove spaces surrounding content editor
    IMPROVED: Prevent Firefox redirect to Java page (new Firefox version doesn't support Java)
    IMPROVED: allow paste images in Safari 
    BUG: After user sign a page, a blank page appeared instead of reload
    BUG: If WF requires validation, prevent users sign their pages before admin approve & sign, button is hidden.
    BUG: If not WF or WF doesn't require validation, prevent admin can sign page before owner do it
    BUG: Eventual bug in signatures with login authentication and LDAP
    BUG: Conflict in flat spreadsheet if more than one page is open at the same time
    BUG: Only first page of spreadsheet was included in print/pdf	
    BUG: Photoeditor plugin in Internet Explorer caused error
    BUG: Uploading files to filesystem in Linux built wrong folder and file names
    BUG: When screen was blurred by login timeout, if maximizing the window some content was exposed
    BUG: If try to add a page to a workflow that already reached number of pages, a redirect is fired and ELN is opened inside the popup
    NEW: Extended demo mode to a non time limit mode for FREE usage of ELN, limited to 500 pages
    BUG: Upgrade needs re-login
    BUG: Upload files with size similar to max allowed packet size
#3.651	
09/05/2017	
    BUG: Check permissions before download attached files or spreadsheets
    BUG: Opening items clicking on search results shows blank page if item doesn't belong to 'My books'
    BUG: Must not remember last item opened when logout and login with a different user on the same browser
11/05/2017
    BUG: Out of memory if a page has a huge number of attached files
    
#3.66
13/07/2017
    NEW: Plugin to add ELN cross references to content
    NEW: Erratum boxes for closed pages
    NEW: Timeline with last events on home page
    NEW: History allows version comparison. Modifications are higlighted (green for additions, red crossed out for deletions)
    NEW: Color code for books/experiments and pages. Color visible on tree, content, print, pdf and search results
    NEW: Integration of Zoho spreadsheet editor/viewer for instances not reachable by internet
    NEW: Option to 'Duplicate' page
    IMPROVED: Floating editor toolbar
    IMPROVED: Content switch to edition mode with double-click
    IMPROVED: Name, tags and project switch to edition mode with single click
    IMPROVED: Updated ckeditor to v4.7 (includes improvements in advanced table selection, paste from excel and others)
    IMPROVED: Content edition - press enter makes a new line, press shift+enter makes a new paragraph
    IMPROVED: Content editor has font type/size by default
    IMPROVED: Select pages on all tabs without reload tree
    IMPROVED: Export page as PDF includes book name and experiment name
    IMPROVED: Decreased value of auto-login timeout (5-20 minutes)
    IMPROVED: Search by created date and modified date together
    IMPROVED: Layout and styles
    BUG: Spreadsheet on print causes error
    BUG: Merge pages misses elements
    BUG: Button 'move experiment' overlapping
    BUG: Missing name/id on archived books
    BUG: Headers of manage users are not aligned
    BUG: If a not admin user owns a book, opens 'Manage users' and submits, the same user is included as 'collaborator' besides 'owner' 

#3.661
26/07/2017
    BUG: users inside a group with VAB permissions view all changes of other groups on timeline
    BUG: users inside a group don't view the top menu of experiments on their own books 
    BUG: book content is not refreshed after close 'Manage user access' popup window

#3.662
21/08/2017
    BUG: Signing pages hangs out if there are many unsigned pages with big content
    IMPROVED: Replace message 'not signed by owner' by 'closed by user on datetime' on print/pdf

#3.663
22/08/2017
    IMPROVED: Performance on timeline if long list of items
    BUG: fonts on PDF generator
    BUG: save file upload path
    
#3.664
30/08/2017	
    BUG: timeline of previous version lacks items for last month
    BUG: prevent overlapping menus
    BUG: encoding issue in timeline and manage certificates
    IMPROVED: PDF supports CJK characters (chinese, korean, japanese)

#3.665
22/09/2017	
    BUG: edit button of content box is missing, and upload page thumb doesn't work after visit 'All books' tab with FireFox
    BUG: edit content in tablets doesn't work
    BUG: users PI don't appear on user list to add collaborators if user logged is not superadmin
    IMPROVED: label 'defult group' replaced by 'Full access'
    
#3.666
19/10/2017	
    CHANGED: custom lab logo doesn't use direct link to make it compatible with htaccess protection	
    
#3.667
23/10/2017	
    BUG: Zoho spreadsheet adapted to last change on Zoho Sheet API (now parameter eventsource is missing on save action)
    BUG: Zoho integration for local servers adapted for instances behind proxy
    
#3.668
27/10/2017
    BUG: bug to link images from ELN to Photobank if album name have spaces(LT143)
    IMPROVED: Photobank plugin adapted to Photobank v3.1 

06-10/11/2017
    BUG: encoding issues in page history and signature name
    BUG: sign images are not dimensioned on page, print and pdf
    IMPROVED: not create temporal image files for sign images
    BUG: color of experiments and pages don't appear on tree 'My collaborations' 
    BUG: initialize vars in permissions functions to avoid warnings in log
    NEW: be able to archive templates (LT227)
    NEW: be able to add categories to organize templates(LT227)
    IMPROVED: ask for confimation before delete a custom field
    IMPROVED: link to edit custom field and edit predefined values, opens a fancybox instead of other window, and looks with modern style
    IMPROVED: templates search
    IMPROVED: add high level info on headers print/pdf (LT188, LT146)
    BUG: export PDF gives a blank page if labcollector has custom logo and .htaccess protection
    IMPROVED: include print and export actions in audit trail (LT126)
    IMPROVED: add helper text on manage certificates (LT235)
    IMPROVED: add helper text in search tree informing barcodes are allowed (LT259)
    NEW: option to allow/disallow remove files associated to pages (LT177)
    
27-30/11/2017
    IMPROVED: define an entire group as collaborator (LT172)
    IMPROVED: multiple groups support (LT271)
    BUG: click save button (diskette) on fullscreen mode gives a blank page
    BUG: when pasting a picture in content editor, the image is pasted twice(LT270)
    IMPROVED: tree speed up display (LT248)
    
04-06/12/2017
    NEW: breadcrumb with dropdown lists on book/experiments/pages
    IMPROVED: tasklist - add time to task list beginning date and closed date (LT148)
    IMPROVED: tasklist - be able to assign a page to each task and create subtasks (LT266)

************** 2018 **************

22/01/2018
    BUG: download file with chinese character on filename

08-09/02/2018
    BUG: the slider to select max file size authorized in database didn't show the value if max value is greater than or equal to 100
    BUG: define PI when one user belongs to more than one group (LT271 bis)

14-16/02/2018
    BUG: prevent pages being saved in browser cache (LT279)
    BUG: template option 'Share with all ELN users' was always ticked (LT273)
    BUG: template option 'Share with my group' didn't work. Since each user can belong to more than one group, it has been simplified to share with a list of groups (LT273)
    IMPROVED: administrators only manage certificates of members of his groups (LT277)
    BUG: buttons for save/cancel edition of grid are 

19/02/2018
    IMPROVED: home timeline takes into account users within multiple groups and new collaborator group permissions
    BUG: double event on click tree item made loading pages slow
    BUG: firefox - message 'dropzone already attached' on firebug and hence attach files to page doesn't work
    BUG: firefox - diagram designer menu duplicated
    BUG: firefox - js error makes diagram designer menu doesn't work
    IMPROVED: on click to add a link to another ELN page, provide text stating link was created (LT261)
    
--- v3.67 19/02/2018

23/02/2018
    BUG: the button to hide/show the tree doesn't work always 

27/02-02/03/2018
    BUG: issue with autologin screen on ADMIN pages (templates, workflows, manage) - images are overlapped (LT274)
    BUG: on erratum edition, page modified_by was updated, and signatures could become invalid, if user was different
    IMPROVED: dashboard includes now erratum modifications 
    IMPROVED: counter-sign option on books permissions management, authorized users have access to ADMIN->Page->Page signing (LT282)
    IMPROVED: speed up Page signing page
    BUG: filter by book in Page signing doesn't work
    IMPROVED: page validation shows now one single line for each page (instead of one for each version) with a link to history comparison 
    IMPROVED: option to block pages creation in a WF until previous page has been validated (LT285)
    IMPROVED: typo for countersign part, replace admin by witness (LT288)
    BUG: the option edit and view only not stay validated once you validate manage users access (LT286)
    
05-06/03/2018
    IMPROVED: collaborators with permissions to close page and book owner can close pages, even if they are not the owners of the page 
    IMPROVED: search on book/expr/page content is case insensitive now

09/03/2018
    BUG: popup for page signing with login authentication has the login field filled and readonly to prevent input a different user
    
12-14/03/2018
    IMPROVED: update URL to get ZOHO API Key
    BUG: workflow list search doesn't work
    BUG: workflow edition doesn't save modified by and modified date
    IMPROVED: view dates of workflow creation and modification on workflow details
    IMPROVED: view dates of template creation and modification on template details
    IMPROVED: save in log the approval of pages in workflow
    IMPROVED: button to approve all in page validation (LT284)

20/03/2018
    BUG: disable touch on sliders (admin->manage permissions and book->manage user access), because caused that checkboxes don't work with last version of Firefox 

--- v3.68 20/03/2018

23/03/2018
    IMPROVED: create index in eln_page_attach
    
26/03/2018
    IMPROVED: memory usage has been reduced when saving big content of page/expr/books

--- v3.681 26/03/2018

28/03/2018
    BUG: in previous version, pages are not signed when they are approved by admin 
    
02/04/2018
    BUG: new users have permission to add new books, by default, but button 'New Book/Project' is not visible on header
    IMPROVED: content editor fits height to content automatically, with plugin auto-grow
    
--- v3.682 02/04/2018

10/04/2018
    BUG: Events of books that have been archived still appear in the timeline (MT1823)
    
01/06/2018
    CHANGED: compatible with sql-mode STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE (M2068)
    BUG: scroll in list of reaction templates
    BUG: encoding issue in list of reaction templates
    BUG: eventual security fail in "My books" tree visibility
    
--- v3.683 01/06/2018

06-08/06/2018
    BUG: script to upgrade version was not executed
    BUG: links in LabCollector records (custom fields autocomplete, etc) are not working from ELN (M2131)
    IMPROVED: general appearance of LabCollector data, linked records are opened in a fancybox
    BUG: view template details shows misplaced elements if no option is chosen (M2133)
    BUG: occasionaly after creating a new page, it doesn't appear on tree until user forces a refresh (M2134)
    BUG: incorrect characters in french for new experiment (M2135)
    IMPROVED: remove archived users in labcollector from permission pages (M2144)
    BUG: book owners could add theirself as collaborator (2145)
    
--- v3.684 08/06/2018

14/06/2018
    CHANGED: books of users with primary group are not visible for users of other groups in tab "All books", timeline and search results (M2180)
    BUG: several corrections in search (M2190)
    BUG: API returns false for GET method if there are books with apostrophe and format JSON is chosen (M2186)
    BUG: when making an edit to a page the delete button remains after version 2 is made (M1949)
    
--- v3.685 15/06/2018

18/06/2018
    BUG: table of users in 'manage user access' popup is blank if sql_mode = ONLY_FULL_GROUP_BY

25-27/06/2018
    BUG: duplicate page doesn't work (M2215)
    BUG: merge selected page (pdf), the first page appaearing in the pdf is not the wrong one (M2230)
    BUG: merge selected page, when one is not the owner of the book, print merged pages opens a blank window (M2231)
    BUG: strange characters when writing in french with accent (M2232)
    BUG: malfunction of buttons expand all and select pages on tree (M2233)
    CHANGED: force collation 'latin1_swedish_ci' to ELN database tables in install
    BUG: search by date doesn't work since last udpate
    NEW: new features in API to connect with mobile app
        - new POST parameter content
        - new GET parameter action with values getBooks, getExperiments, getPages, getPageImages, getPageContent

--- v3.69 27/06/2018

17/07/2018
    BUG: after do a search by keyword sometimes the keyword is not highlighted (M2340)

23/07/2018
    CHANGED: when a page is closed last modification date is compared with database time, instead of server time
    
31/07/2018
    BUG: if any page name contains a vertical tab (character \v) left tree is not displayed (M2401)

28/08/2018
    BUG: members of Full Access don't see superadmin in list of users when manage permissions of their books
    BUG: after last update, list of users is empty (depending of mysql version)
    
29/08/2018
    BUG: Search with admin account fails (M2514)
    BUG: In search results the keyword is not highlighted in a table in the body of the text (M2472)
    
05-06/11/2018
    BUG: Firefox console shows a red message 'XML error' searching LabCollector Data
    BUG: Firefox console shows a red message 'XML error' if custom field of type grid has not rows
    BUG: Users can not add theirself as a collaborator, even if they are not the owner of the book
    NEW: Allow change book owner
    
--- v3.691 06/11/2018

09/11/2018
    BUG: Edit page/experiment/book name remove characters '20' from the beginning of the name

************** 2019 **************
    
12/02/2019
    IMPROVED: reduce memory consumption and loading time for pages with huge number of attached files
    
15/02/2019
    BUG: ZOHO token generation doesn't work if ZOHO password contains the character '&' 	
    
15/03/2019
    BUG: duplicate page doesn't work if the user is not superadmin
    
10-11/04/2019
    BUG: adapt molecule editor and viewer to last Moledit lib
    BUG: button "Insert in page" in molecule reaction popup doesn't work, if page content is empty 

09/05/2019
    BUG: edit button doesn't work if the name of user contains an apostrophe (M3369)

15/05/2019
    BUG: If page name has apostrophe, versions in history are not saved (M3397)
    
04/06/2019
    BUG: unlock autologin screen does not work if password encryption mode is SHA-256 + strong rules
    ADDED: button to logout in autologin screen
    CHANGED: Update Photoeditorsdk to version 4.18 (M3550)
    
13-14/06/2019
    BUG: API method getPageImages sends wrong base64 data if PHP >= 5.4	
    BUG: API method to update content of existent page does not update
    BUG: login validation in sign page does not work if password encryption mode is SHA-256 + strong rules
    
19-28/2019
    BUG: update content through API does not generate versions
    BUG: wrong timestamp in history/version (M2280)
    BUG: Template edit allows to add empty user (M3200)
    BUG: repetition of the same page to validate and sign (M3216)
    BUG: API bug page name with apostrophe(M1273)
    NEW: copy/replicate multiple pages at once (M3552)
    CHANGED: certificate passwords are encoded now in database (M3401)
    NEW: In Pages > allow link to exact CH lot (M1237)

01/07/2019
    BUG: problem of encoding in manage user access form	(M2277)
    BUG: Alphabetical order not working in Tree (M1923)

--- v3.692 01/07/2019

02/07/2019
    BUG: search with 2 keywords not making AND (M3238)
    NEW: user can choose the operator AND or OR in search by keyword (M3238)
    BUG: Duplicate page does not refresh tree selected position (M2278)
    BUG: typo in Digital Certificate Options (M2407)
    
11/07/2019
    BUG: Export in PDF doesn't work if contain broken images (M3628)

15/07/2019
    CHANGED: move layout to current LabCollector design (M3684)
    
24-25/07/2019
    BUG: group filtering in LabCollector data search too old (M3692)
    BUG: encoding in page version popup (M3681)

29-31/07/2019
    ADDED: add LC link search could allow link in record to check details (M3711
    CHANGED: Remove Java spreadhseet (M3076)
    NEW: paginate search results in LabCollector data (M3710)
    NEW: link page in WF to a task item (M3709)

5-9/07/2019
    NEW: add checksum to audit trail (M3780)
    NEW: verify on EDIT content and page elements if session is still alive (M3675)
    NEW: release flatspreadsheet with graphs (M3077)

--- v3.7 09/08/2019

19-23/08/2019
    BUG: ELN version does not show anymore on footer (M3805)
    BUG: Change book owner does not remove previous owners (M3803)
    BUG: the books to which the owner was changed didn't appear in "My books" tab (M3803)
    ADDED: show owner in template list (M3518)
    BUG: Attachments appear to be saved even if the permission on the storage folder is not correct (M3154)

26-27/08/2019
    BUG: broken session allows to make books with empty owner (M3804)
    BUG: fixes in flat spreadsheet's graphs (M3077)

29/08/2019
    BUG: graphs in flat spreadsheet does not work in IE (M3849)
        
--- v3.701 29/08/2019	

02-06/09/2019
    BUG: Flat spreadsheet's graphs in PDF look different of page view/print (M3859)
    ADDED: Generation of PDF/A, secured PDF and possibility to add watermark (M3851)
    BUG: Apostrophe missing in name of Book/Experiment/Page when exporting in PDF (M3629)
    BUG: name must be mandatory when creating spreadsheet templates (M1750)
    ADDED: File viewer for PDF attached files, as LC (M3857)
    BUG: Flat spreadsheet's graphs are not copied in duplicated pages
    BUG: Edit and Add values to Custom fields with apostrophe does not work (M3872)
    BUG: Export ZIP does not include attached files (M3873)
    BUG: flat spreadsheet does not appear in report included in ZIP (M3874)
    
--- v3.702 06/09/2019	

11/09/2019

    BUG: create new page generates 2 versions in history, since 3.701 (M3893)
    BUG: page doesn't open in local, since 3.702 (M3907)
    BUG: The option to forbid add and edit Workflows does not work (M3882)
    BUG: some special characters does not work in the name of custom fields (M3908)	
    BUG: wrong label in watermark options
    CHANGED: Order custom fields by name

13/09/2019
    ADDED: compatibility with php7 (M3912)
    CHANGED: changes in permissions of user with role visitor (M3913)

--- v3.7021 13/09/2019	

16-17/09/2019
    BUG: insert molecule on page fails in MS Edge (M3932)
    CHANGED: molecule viewer and editor support now .CDX format (M3933)
    
--- v3.7022 17/09/2019	

21/10/2019
    BUG: Problem with the renewal of the digital signature
    
24/10/2019
    BUG: Page attachments stored in disk with the same name are overwritten
    
05-06/11/2019
    BUG: add page templates without task to workfow doesn't work (M4075)
    BUG: Unable to connect to Zoho using a proxy (M4078)
    
--- v3.7023 06/11/2019		

11/11/2019
    BUG: Users in a group don't get results in LabCollector data search (M3692)
    
13/11/2019
    ADDED: allow multi-tenant file upload for SaaS (M4037)	
    CHANGED: automatic file upload path for clients hosted in labcollector.online
    CHANGED: automatic silent installation for SaaS
    
--- v3.7024 06/11/2019	

************** 2020 **************

13/01/2020
    BUG: PI permissions removed when at least one PI permissions are updated (M4195)
    
23-29/04/2020
    CHANGED: Edit tags even on closed pages (M4402)
    CHANGED: Add tag editing to LOG/Audit trail	(M4402)
    ADDED: allow quick add tag to search result (M4361)
    ADDED: filter tree by tag (M4325)
    CHANGED: Modify the filter to be able to filter by keywords AND by tags (M4325)
    ADDED: limit the search to pages only or all (M4325)	
    BUG: Fixes in search and pagination
    CHANGED: Allow edit tags to users with VAB permissions	

--- v3.7025 29/04/2020	

04/05/2020	
    BUG: adding multiple users from other group in book>manage users' access
    BUG: duplicate multiple pages didn't close popup and refresh tree at end
    
20/05/2020
    BUG: experiment's owner doesn't see the button "Move to"

11/06/20202
    NEW: layout
    NEW: Real time documents editing with FileConnector (M4208)
    ADDED: API upload and retrieve files attached to pages

--- v4.0beta 23/06/2020	

29-30/06/2020
    CHANGED: link to CH and lot > do not show 1 lot by default (M4519)
    CHANGED: ckeditor update to last version and new plugins (Enhanced Imagem, Code Snippet and Equation Editor)
    BUG: book color is lost when edit book name
    NEW: subpages (M1259)
    
02/07/2020
    BUG: apostrophe in template name or description didn't save
    BUG: default template was not available in workflow design
    NEW: Tag management page (M1290)

07-10/07/2020
    CHANGED: update mpdf 8
    NEW: feature design page to reorder items in page and add new items (M1259)
    ADDED: file size and icon to download to associated files list

27-30/07/2020	
    ADDED: icon that indicates that the user can sign pages in book user's list
    NEW: all users have access to page to create our own certificate
    CHANGED: Cannot click on associated files preview if zoho is not configured & changed setup blocks order
    BUG: order of the custom fields in the template and page is not the same (M4566)
    BUG: in LabCollecor Data section, the button Memorized doesn't work (M3983)

17/08-07/09/2020	
    ADDED: Add new page -> template selector: filter by category first then see templates og the category
    ADDED: Selection of units improvement. Now we see UNIT (ml) before taking out the unit.
    ADDED: Work with spreadsheets without reloading the page.
    BUG: After adding a tag to an experience, we can't add a new experience, the button is blocked.
    BUG: Sign all listed pages at once doesn't work.
    BUG: Manage advanced permissions: block checkboxes to visitors.
    BUG: Images doesn't appear on PDF, lab logo is broken.
    BUG: PDF report diagram shows mixed with files list.
    BUG: Page -> Additional content -> Full screen: sometimes the photoeditor is displayed blank.
    BUG: Create a new workflow, when click on save button "Leave site?" popup apprears.
    BUG: Manage associated files is available even for closed pages.
    BUG: Diagram designer -> Add personal item doesn't work.
    BUG: Book users' access: when check "All membres", there are no relatives changes.
    NEW: Put install inside layout.
    NEW: Tree Filter: show active pages for the last 1/7/30/60/... days.
    NEW: Alert popup before sign page.
    CHANGE: Harmonization of the aspect of the text style between edition/saved, view print and PDF.
    CHANGE: Paginate certificates, filters, search (DataTables)	
    
08-11/09/2020
    BUG: Remove java applet
    BUG: Number of pages on WF must not include subpages
    CHANGED: Modify SSL message on FileConnector popup
    BUG: the organization and the number of page elements change after save (#120)
    BUG: chemistry reaction template load and edit (#62)
    CHANGED: search to reduce the size of preview DIV and make search page clear with breadcrumb style on each result
    CHANGED: admin>file uploads restricted to super-admin
    CHANGED: resize images uploaded to content max width 600px
    CHANGED: resize images uploaded on photoeditor plugin, max width 600px
    ADDED: main search searchs also in extra page content (when a page has multiple content editor)
    
14-18/09/2020
    CHANGED: create indexes in page history table to speed up page load
    CHANGED: add more indexes in multiple tables to greater overall speed
    REMOVED: 2 obsolete files, to prevent security risk

21/09/2020
    BUG: when a user has not permissions to access one settings page, the template is not loaded (M4645)
    CHANGED: remove unauthorized options from menu in basic mode (M4645)
    
--- v4.0 21/09/2020

22-25/09/2020
    ADDED: "copy activation key to clipboard" feature
    CHANGED: on editors, now button "floppy" saves and stay
    BUG: Encoding problem in the content (M4663)
    BUG: bad display adding users of other groups to book permissions

29-02/10/2020
    BUG:  Digital Certificate> Download certificate keys don't work (M4677)
    CHANGED: Increase field size for reaction template
    BUG: Special characters do not display well in book list when ELN reference and in book select when duplicate page (#141)
    BUG: There are some duplications in book select when duplicate page
    BUG: Archived book names are not well aligned in book list when ELN reference
    BUG: Special characters do not display well in alert when a page is currently edited
    BUG: JS error in ckeditor plugin mindthegraph
    BUG: small issue in associated files radio button
    BUG: session lost in stockage options
    BUG: when close page, page menu is not loaded (#156)
    BUG: drag'n'drop on tree causes JS error (#158)
    CHANGED: pick lang from profile if set
    
06-08/10/2020
    BUG: encoding issues
    BUG: certificates list is empty, if lang=fr (#175)
    BUG: search words with special characters (#169)
    CHANGED: update lang FR
    BUG: data of workflow's instruction field is truncated on save (#167)
    BUG: issues with apostrophes in workflow tasks (#167)
    BUG: hide the template select when creating a page in a WF (#173)
    BUG: responsive page bug (#176)
    CHANGED: fixes & improvements in load page spreadsheet(#151)
    BUG: when change lang on top right popup, new lang is not applied 
    BUG: error inserting reaction molecule template in page (#179)
    BUG: restore corrupted funtion spec_chars_fr in PDF generator
    BUG: some custom fields doesn't display after save
    BUG: add charset=utf-8
    BUG: fixes print merge
    BUG: encoding PDF and fix diagram overlapping
    BUG: user can add page even if he doesn't have permission

15-16/10/2020	
    BUG: ELN doesn't force SQLmode as LC
    ADDED: Tags - autocomplete finds in middle of words 
    CHANGED: absolute path for images in PDF
    CHANGED: archived books keep the button to change owner, and can be unarchived by superadmin or pi
    BUG: some pages missing in Page Validation & Signing
    
19-22/10/2020
    ADDED:  Warn the user that to create a tag he must press <Enter> if tag doesn't exist (M4710)
    CHANGED: Page signing: page popup show all page content like when printing page (M4518)
    CHANGED: make spreadsheet viewer readonly (requires LC update)
    CHANGED: improve layout of design page popup
    ADDED: flat spreadsheet saves columns widths and rows heights
    CHANGED: Increase icon size on book/experiment/page content
    BUG: Encoding issue in the warning alert when a grid is already in the process of being modified
    CHANGED: Hide select/add a template in spreadsheet data block on page content, if spreadsheet option = viewer
    ADDED: On default viewer 'Load another' file button added
    ADDED: On default viewer 'Download' file button added
    BUG: Users fullaccess don't have access to super admin's WFs (#177)
    BUG: Grid edit buttons don't refresh well (#165)
    BUG: Admin->Page Validation & Signing: when Certificate="Private Key" 'approve'->'validate' doesn't work (#182)
    BUG: menu overlapped over toolbar on template>editor>fullscreen (#214)
    BUG: when the title of the graph contains an apostrophe, the graph is not saved (#209)
    
27/10/2020	
    NEW: Add tags by group (#206)
    
--- v4.01 27/10/2020
    
27-29/10/2020
    BUG: wf filter doesn't work fine (#220)	
    CHANGED: diagram designer, remove spaces on text boxes (#196)
    CHANGED: diagram designer, border of text boxes lighter (#196)
    CHANGED: diagram designer, allow reduce size of text boxes (#196)
    BUG: missing image 'refresh' in the list of forms of diagram designer (#171)
    BUG: it was possible to add twice the same book/experiment/page clicking twice in button 'Save' (#152)
    BUG: adjustment in diagram designer in PDF (#222)
    BUG: fixes in merge pages (PDF & Print)
    BUG: there was a conflict if Spreadsheet(view mode) + flat spreadsheet are in the same page (requires LC update)
    ADDED: enable plugin 'CopyFormatting' in CKeditor	
    BUG: after design page, the page menu is missing
    CHANGED: make a way to reload default elements in design page popup (#157)
    NEW: allow multiple spreadsheets in pages
    BUG: Fix encoding bug in template view (#168)
    NEW: Debug options for PDF images (testing purpose)
    
03/11/2020
    BUG: list of books in eln plugin in ckeditor is empty (#223)
    CHANGED: Don't show arrows in book user access popup if the user only belongs to one group and is not superadmin (#224)
    
09/11/2020
    BUG: reconnect to mysql makes sql_mode get lost

11/11/2020
    BUG: error saving flat spreadsheet after apply styles (#227)
    BUG: Flat spreadsheets do not display in the exported PDF of the experiments (#228)

17-19/11/2020
    BUG: books with the same date of creation may appear more than once in tree, caused by wrong order of elements
    BUG: JS error in console after sign a page
    BUG: JS error in load spreadsheet, after apply formatting (M4738)
    BUG: JS error in Internet Explorer, syntaxis not supported
    NEW: add a tooltip when activation key is copied
    BUG: fix encoding bug in alerts when page signing (#231) (#168)
    BUG: page of linked to workflow experiment must not be duplicated (216)
    BUG: when a PI administrator makes "sign all", he signs all the closed pages even those to which he does not have access (M4740)
    BUG: View/Edit SpreadSheet template doesn't work, there is an error on the console (#232)
    
--- v4.011 19/11/2020

23-27/11/2020
    BUG: link to another page was always targeting first tab (#225)
    NEW: add preview of plain text (.txt) files in ELN (if LC version > 6.01)
    CHANGED: new connection to fileconnector
    ADDED: plugin 'lineheight' to CKEditor
    NEW: spinner animation during tab's book list loading
    NEW: reloading the page (ie with F5) reopen the current opened ELN level
    CHANGED: increase the max size of images uploaded in content or photoeditor from 600px to 1000px
    CHANGED: Better performances on getting book tree list (mainly for a large number of ELN level entries)

30/11-02/12/2020
    BUG: tags manager in IE11
    CHANGED: customize CKEDITOR plugin 'lineheight'
    FIX: Link to another page which should open "My Books" tab now really load&open "My Books" tree
    NEW: Advanced search with Elasticsearch
    
--- v4.02 03/12/2020

11-14/12/2020
    CHANGED: API file upload: remove extra spaces and line breaks at the end of the file
    CHANGED: API file upload: recalc file size after removing extra spaces
    CHANGED: don't disable fileconnector buttons after click
    BUG: API file upload: version number was not good
    ADDED: 8-well plate & 8-well row to CKEditor plugin for insert plates

17/12/2020
    UX: ELN Menu: It's now possible to open a majority of links in a new tab by pressing CTRL during the click (ie Home, Tools > Tag Manager...)

--- v4.03 15/12/2020

22/12/2020
    BUG: Fix flatspreadsheet's graph refresh (edition) overlapping previous graph, now the previous graph is replaced in the user interface
    BUG: Fix flatspreadsheet's legend in case of "Legend range" being empty, no more "undefined"
    FIX: Page block duplication on save from Page designer

--- v4.031 22/12/2020

24/12/2020
    NEW: Add spreadsheet local edition with file connector, use your favorite spreadsheet editor to edit sheets on ELN pages (M4763)
    UI: Page "SpreadSheet Data" button are now in a similar style than the other categories
    NEW: Add API action 'getPageSpreadsheet'
    NEW: Add reopen page feature (M4531)
    FIX: Remove 'delete' & 'load another' spreadsheet actions when page is closed
    NEW: New name format on spreadsheet download 'spreadsheet-{page_name}-{spreadsheet_id}.xls'

************** 2021 **************

07/01/2021
    NEW: Make page items draggable and sortable on home page
    CHANGED: Design page: remove CUSTOM item from the left side bar and make it unmoving on the right side bar

--- v4.032 07/01/2021

07/01/2021
    NEW: Add page design feature on add/edit template

--- v4.033 07/01/2021

08/01/2021
    UI: Add 'Edit' button on Diagramm Designer (ELN page) for better readability
    FIX: Bunsen burner on Diagramm Designer being named 'benzene' (in all language)
    FIX: Fix flatspreadsheet's graph refresh (edition) when multiple graph were present
    UI: Change flatspreadsheet's graph colors order for better readability
    NEW: 3 new flatspreadsheet's graph : horizontal bar, scatter and polar area

11/01/2021
    FIX: Fix editors content conflict in page content history

12/01/2021
    FIX: Flatspreadsheet's graph UI name when adding new graph
    UI: Remove useless XY axis for the following graph : pie, doughnut, polar area
    UI: Add a confirm dialog on graph remove
    FIX: Flatspreadsheet errors when working with big datasets
    FIX: Text content now strip all possibly unwanted content (iframe, javascript, css) before save & restore

13/01/2021
    NEW: "All Books" tab now shows owned and collabs books for basic users (#159)
    FIX: Formulas missing support in graph

25/01/2021
    NEW: Add and make page items sortable on add/edit template

27/01/2021
    BUG: Fix encoding custom fields bug on home page

28/01/2021
    FIX: Allow more characters in ELN levels like '+&=' (M4923)
    CHANGED: Change the display of sub pages in the table of content of PDF import
    NEW: Use default template by default when adding a new page
    BUG: Fix edit book name bug due to special characters of book description (M4924)

--- v4.034 29/01/2021

02/02/2021
    NEW: Add an attached files section to the experiment level (M4905)

--- v4.04 02/02/2021

05/02/2021
    NEW: Allow to edit page icon
    ADDED: Print page: add extra custom fields block
    ADDED: Page export PDF: add extra custom fields block

--- v4.041 (non public)

12/02/2021
    FIX: Subpage selected icon doesn't appear (#244)
    NEW: Flat Spreadsheet 2, Flat Spreadsheet with a much better sheet UI and UX (M4767)
    FIX: Duplicte of a tempalte doesn't work

--- v4.1 12/02/2021

15/02/2021
    FIX: missing page attach column indexes

--- v4.11 15/02/2021

16/02/2021
    CHANGED: Improve manage image stickers page => replace two last table comumns by the one with switcher (M4929)

19/02/2021
    NEW: Toolbox in advanced search. Now you can select results and do group actions. This first release contains only a Tag editor, more function to come (M4754)
    FIX: Export PDF long loading
    FIX: Prevents one rare fatal error, occuring on specific conditions

22-23/02/2021
    FIX: Associated files PDF viewer (M4657)
    UI: "Search by text or barcode" UI improvements (M4921): 
            * clickable area is not exactly on the word "find"
            *  add the possibility to tape on keyboard "enter" to launch the search
    ADDED: Improve tree options: add book, experiment order by creation date (M4964)

26/02/2021
    FIX: versioning: confusion with extra editor when recover content (M5107)
    FIX: versioning: confusion with extra custom fields when recover all
    FIX: save custom_field_value_history when editing extra custom fields

03/03/2021
    FIX: print/PDF level order (now correctly based on creation date with oldest on top and newest below)

12/03/2021
    FIX: PDF generator undisplayed images and rare truncated content
    NEW: Improve excel to HTML print system, will reduce loading time and size of prints & PDF generators

16/03/2021
    FIX: Security fail allowing edition of closed page files if a particular succession of actions was done (M5151)

23/03/2021
    CHANGED: Include gridstack.all.js locally
    FIX: Grids impossible to edit (M5158)
    FIX: Custom Fields save (M5158)
    FIX: Custom Fields being impossible to edit again after once edit (saved or canceled) (M5158)

26/03/2021
    FIX: Zoho fileviewer didn't work for attached files stored in disk

29/03/2021
    CHANGED: Improve how ELN contents (book/expr/pages) handle heavy images. Now suggest to compress images (less quality loss than previous resize to 1000x1000 system)

30/03/2021
    FIX: LC data comment edit bug, a comment added to one record were displayed (visual only) for the other record to (M5179)
    CHANGED: Update ckeditor to 4.16 and some plugins
    FIX: Specific javascript bug due to window.URL overwritten when equation editor (plugin of ckeditor) was opened.

31/03/2021
    NEW: QR code generator on ELN contents, extra contents & erratums (CKEditor)
    NEW: Footnotes on ELN contents, extra contents & erratums (CKEditor)
    NEW: On ELN pdf (books, exprs, pages & merge) generated, barcode are now clickable
    FIX: Subpages being duplicated in PDF generation (M5184)

--- v4.12 01/04/2021

02/04/2021
    FIX: Improve and harmonize "Additional Data" blocks views on pdf & print (M5189)
    FIX "Additional Data" missing on pdf merge & print merge (M5197)
    CHANGED: ELN diagrams in print & pdf will be more consistent with the web view (M5190)

06/04/2021
    FIX: Expr/Pages/Subpages not selected at creation since M5151 fix (M5203)
    FIX: Custom fields type "text" don't display line breaks (M5201)
    FIX: Character encoding issues on PDF generated with custom fields (M5199)

12/04/2021
    FIX: Templates edition bug (M5229)

23/04/2021
    FIX: Improve template view (M5229 - extension)

27/04/2021
    FIX: Rare case where default page template were not in first position (in template managers and selectors)
    CHANGED: It's now impossible to save a tamplate without a name (this field is now mandatory)
    FIX: Layout issue on page preview signature pop-up
    NEW: Confirm dialog on page signing and page validation
    FIX: Small UI bug for the "OK" button on "Admin>Page>Page Validation & Signing"
    FIX: Major bug where file attachements were linked to page of same id and not expr

--- v4.13 28/04/2021

30/04/2021
    FIX: save Zoho Sheet didn't save (M5278)

05/05/2021
    FIX: Search options not working on "View/Edit Template" page

06/05/2021
    NEW: Add tree book filters by owner, creator, last editor (M5234/M5239)
    CHANGED: tag management => change logic 

11/05/2021
     FIX: tag not assigned to group should be available to all (M5291)

14/05/2021
    FIX: Template additional data edition/deletion residues (M5272)

17-19/05/2021
    NEW: ELN API now support getting and editing expr associated files
    FIX: File Connector not working with expr associated files
    FIX: File preview not working with expr associated files
    FIX: error editing page content for Portugal's users, due to an error in lang file of one ckeditor plugin
    FIX: One "Authentication" word typo in english lang file
    NEW: Remove warning for openssl and curl extension needed on 'Admin > Manage > Digital certificates' when extensions are already installed and enabled

21/05/2021
    FIX: Sign page on 'Admin > Page > Page Signing' not working for certain users (M5276)
    CHANGED: Page Signing now lists project & tag infos
    NEW: Add a project and tag filters to Page Signing
    NEW: Page Signing preview list is now limited to 200 results in order to avoid long page load
    FIX: Missing templates in view template list
    FIX: Login/logout account view template list refresh
    FIX: User access bug at template creation
    FIX: Expr associated files not working properly with non admin user (M5240)
    FIX: Expr associated files cannot be download it once they have been upload (M5325)

25-26/05/2021
    NEW: Archived users are now displayed as striked
    CHANGED: Rename "Additional Data" in page template by "Additional Data (Custom fields)" (M5324)
    CHANGED: Modify icons and helper text in spreadsheet (M5320)
    CHANGED: Indicate search location in the title of the search bar in the tree (M5319)
    NEW: Add tree alphabetical and creation date sorts for pages (M4613) (M1064)
    CHANGED: Separate tree sorts for books and experiments (M1064)

27/05/2021
    CHANGED: Move expr functionality update
    CHANGED: Page Validation now lists project & tag infos
    NEW: Add a project and tag filters to Page Validation
    NEW: Page Validation preview list is now limited to 200 results in order to avoid long page load

28/05/2021
    FIX: Group definition not applied in labCollector data section (M5332)

--- v4.14 01/06/2021

02/06/2021
    FIX: Labcollector data keyword search not working as intended when search text contained spaces (M5350)

04/06/2021
    FIX: fix class HTMLDiff, used for version comparison in history, to be compatible with PHP7.4
    FIX: fix query in version comparison in page history
    
15/06/2021
    CHANGED: with advanced permissions, only PIs can sign pages of all members of their groups without explicit permissions in books

23/06/2021
    FIX: Rare bug on page design edition, randomly after save, content view wasn't reloaded (M5385)

--- v4.141

02/07/2021
    CHANGED: Better past from clipboard (ctrl+v) support for all navigator besides Internet Explorer

--- v4.142 02/07/2021

07/07/2021
    FIX: name's encoding issues on home page

09/07/2021
    CHANGED: Improve spreadsheet data file format support, ie reduce cases of XLS downloaded as XSLX (M5400)

13/07/2021
    NEW: Add spreadsheet type selector

15/07/2021
    NEW: New page component Microplate

19/07/2021
    FIX: Improve click on "Find" functionalities in ELN tree (M5417)
    FIX: Flatspreadsheet V2, allow formula recursion

21-23/07/2021
    CHANGED: Tasks Gantt view rework (M5321)
    - Add Zoom In, Zoom Out, Zoom to fit & Fullscreen options (Note: Zooms change scales minutes/hours/days/weeks/months/quarters/years; default to days)
    - Zoom In and Zoom Out can be done with ctrl+scroll
    - Add tooltip infos on task mouse over
    - Task duration are now showed in days and hours (separate units) but have a minute precision (hours can be decimal now)
    - Task duration is inline editables
    - Add task progress read only column
    - Better handling on popup window resize
    FIX: Gantt view now correctly shows subtasks (M5322)
    FIX: Modify a subtask start date and duration will update parent task accordingly (parent task start date set to lowest start date among its childrens, and duration to span between start date and end date of subtask which ends at last)
    FIX: Any change to a parent task date and duration will be overwriten by real value depending on its childs (as detailed in previous line)
    CHANGED: It's now impossible to edit a done task in gant view (M5423)

--- v4.15 23/07/2021

26/07/2021
    FIX: ELN subtasks print order (M5432)

06/08/2021
    FIX: correct admin PI permissions in tag manager (M5433)
    IMPROVED: add search tags by group in tag manager

24/08/2021
    FIX: Expr content sometimes doesn't print in export PDF (M5443)

--- v4.151 24/08/2021

14/09/2021
    FIX: Flatspreasheet v2 were priniting formulas instead of result on pdf/print export

24/09/2021
    NEW: tag manager => link to project and add option to mandatory tag on the project (M5509)
    NEW: add tag to book by selecting a project (M5511)

01/10/2021
    FIX: Flat Spreadsheet from default template on new installs should now use V2 (M5536)
    CHANGED: Change "new" by "extra" (ie "Extra Spreadsheet")

04/10/2021
    CHANGED: Manage owner UI rework

06/10/2021
    NEW: save a page block for reuse (M5549)

12/10/2021
    NEW: generate a template from a page (M1176)

18/10/2021
    NEW: add a new column 'dataurl' to the table 'eln_template_sheet_graph' (M1176)

22/10/2021
    NEW: add a new block to save vocal notes (M5548)
        - register audio with your microphone
        - listen it back
        - download the audio file

28/10/2021
    NEW: notifications (M1163)
    CHANGED: On print/pdf with Flat Spreadsheet 2 graph are now shown under the sheet it is associated with (M5577)

02/11/2021
    NEW: new version of page signature (on app side) which take more page data into account for signature, only apply to new signatures (M5597)
    FIX: user which has closed/signed a page cannot admin sign it anymore

04/11/2021
    FIX: microplate section => sql query isn't correct when there is a group id

12/11/2021
    CHANGED: lock/unlock feature => if a user has no rights, do not apply locked styles (M5615)

16/11/2021
    FIX: Unable to select text (in general in order to copy then paste elsewere) on page view
    CHANGED: Rework of book's manage collaborators UI (M4734)

26/11/2021
    NEW: page content => add linked pages block (M5287)
    NEW: Add a rights sum-up picture icons for book collaborator view
    FIX: Case were drag&drop wasn't functionning and returned a console error

01-08/12/2021
    CHANGED: Increase length of template name from 50 to 250 characters (M5471)
    NEW: Recipe block for page, allows to link recipes to a page (M1301)

--- v4.2 13/12/2021

15/12/2021
    CHANGED: Recipeblock UX

17/12/2021
    NEW: Migration action button for Flat Spreadsheet legacy, allow users to migrate old flat spreadsheet to the v2 version (M5680)
    CHANGED: Bring back basic search even if Elasticsearch & Advancedsearch is set up

22/12/2021
    CHANGED: put the book owner in the book's user list
    FIX: many things can be edited if a book is archived (M5686)
    FIX: no content section when a page is created from default template of version 1 (M5684)
    FIX: manage button of associtated files section doesn't work at the experiment level (M5688)
    IMPROVED: copy-paste image from one page to another creates full url (M5689)

--- v4.21 22/12/2021

************** 2022 **************

03/01/2022
    CHANGED: Book owner rights column in book's user list
    FIX: Visitors are now correctly limited to read-only on book/expr/page (M5690)
    FIX: Visitors, who had a digital certificate created before being a visitor, no longer have access to the admin page signing (M5690)
    FIX: Book ownership can no longer be transferred to visitors
    FIX: € symbol not exported in pdf (M5685)

06/01/2022
    FIX: Non-matching avatars in book's collaborators list
    CHANGED: "Add LabCollector link" option in content editors now insert links with barcode text value at the end, ie "strain name (123/ST)" (M4517)
    FIX: Book owner weren't able to counter sign pages created & signed by collaborators (M5700)

11/01/2022
    NEW: Add the archive/unarchive actions on the book homepage (M5687)

13/01/2022
    CHANGED: Update PhotoeditorSDK

20/01/2022
    FIX: Some fixes with quotes and special characters on custom fields, escpecially grids

21/01/2022
    CHANGED: Removed access to "Add Log Entry"
    FIX: Owner sometimes shown as archived (striked) on book collaborators list
    NEW: Open book/expr/page in new tab on "ADMIN > Page" sub links

--- v4.22 31/01/2022

16/02/2022
    FIX: Level content expand feature, reduce UI glitch at the bottom
    NEW: Block expand feature, now edit blocks like text content or flatspreadsheet in a bigger view
    NEW: Add scannable code bars on content level views
    CHANGED: Improved screen size responsiveness for level content view

21/02/2022
    FIX: paste image from html views
    NEW: Add search by lot & lot reference for linked data (M1244)
    CHANGED: Improve image view on UI

24/02/2022
    FIX: Tags created by 'Full access' members sometimes not visible by them
    FIX: Basic search always returning an error
    FIX: Extra content ckeditor internal save button overriding main content
    CHANGED: UI better reaction to extra content ckeditor internal save button

25/02/2022
    FIX: Subpages sometimes printed/pdf twice, mainly on export expr
    NEW: Subpages are now exported on export page, same for print

--- v4.23 28/02/2022

04/03/2022
    FIX: Illegal access to manage permission (M5800)
    FIX: Microplate box selector bad background color

07/03/2022
    FIX: Template spreadsheet not saved by Zoho

09/03/2022
    FIX: CKeditor & TinyMCE content visually lost on UI drag&drop

--- v4.231 11/03/2022

17/03/2022
    NEW: Add an ignore block for print/export buton to each page block

21/03/2022
    FIX: Change content font & font size according to default values : Arial & 12px

--- v4.232 22/03/2022

23/03/2022
    FIX: Spreadsheet data wasn't visible by other users if spreadsheet block was locked

31/03/2022
    FIX: Rare case were some Full Access members (especially Super Admin) weren't given the correct right level on book/expr/pages
    UI: Icon color on book collaborator list

01/04/2022
    NEW: Add rename page block for a custom name (M5806)

11/04/2022
    NEW: Add notify collaborators option for pages
    NEW: Add a strict search mode in the basic search (M5829)

--- v4.233 12/04/2022

14/04/2022
    NEW: Duplicate book, options to keep project & tags (M5848)
    BUG: script to upgrade version was not executed

15/04/2022
    FIX: User and Staff were able to create book without permission if basic mode was enabled (M4688)
    FIX: Admin were not able to edit tag in Tag Manager even with "C/E tg" checked (M5813)
    FIX: Several mobile navigation bugs
    FIX: Sometimes impossible to create custom fields

19/04/2022
    FIX: Unable to edit custom fields values
    FIX: It was sometime possible to close a page with unfilled mandatory fields (M5193)

20/04/2022
    FIX: On add LabCollector data, checkbox status now keeped when changing page result (M5801)
    NEW: On add LabCollector data, added search and change sort options
    FIX: Major issues with custom fields, especially grids

21/04/2022
    FIX: Changed colorpicker lib for better mobile support

--- v4.234 21/04/2022