This issue fix following bug:

• SP-469 - Attachment access locks are not cleaned before computing access type

This issue fix following bug:

• SP-469 - Attachment access locks are not cleaned before computing access type

This issue fix following bug:

• SP-469 - Attachment access locks are not cleaned before computing access type

Hello, this Spreadsheet release contains following updates :

New user request :

• SP-464 : Too many Elements Spreadsheet error pop-up displayed

Bug fixes :

• SP-422 : Copy-Paste a number on a cell in a text format doesn't work
• SP-423 : Impossible to paste number which cell has Text format
• SP-465 : User mentions not resolved when limit reachs 25 mentions
• SP-466 : Cursor move at cell content end when typing between two characters

Hello, this Spreadsheet release contains following updates :

New user request :

• SP-464 : Too many Elements Spreadsheet error pop-up displayed

Bug fixes :

• SP-422 : Copy-Paste a number on a cell in a text format doesn't work
• SP-423 : Impossible to paste number which cell has Text format
• SP-465 : User mentions not resolved when limit reachs 25 mentions
• SP-466 : Cursor move at cell content end when typing between two characters

This release contains following updates :

• New features :
  • SP-449 - Filter info on display view
  • SP-462 - Adjust Cell width when using Scroll PDF Exporter macro

• Bugs :
  • SP-351 - difference in format 'ssc' between Server and Cloud
  • SP-358 - Permissions in Spreadsheet document
  • SP-360 - Cannot subtract referenced value from other sheet
  • SP-401 - 0 disappear in an already attributed format Text cell
  • SP-426 - Stretch a merged cell range should preserve source merge configuration
  • SP-440 - When typing web address, date is displayed
  • SP-445 - Create a Spreadsheet by Import from file
  • SP-447 - Anonymous user can't view Elements Spreadsheet
  • SP-448 - Deleting column breaks formula

This release contains following updates :

• New features :
  • SP-449 - Filter info on display view
  • SP-462 - Adjust Cell width when using Scroll PDF Exporter macro

• Bugs :
  • SP-351 - difference in format 'ssc' between Server and Cloud
  • SP-358 - Permissions in Spreadsheet document
  • SP-360 - Cannot subtract referenced value from other sheet
  • SP-401 - 0 disappear in an already attributed format Text cell
  • SP-426 - Stretch a merged cell range should preserve source merge configuration
  • SP-440 - When typing web address, date is displayed
  • SP-445 - Create a Spreadsheet by Import from file
  • SP-447 - Anonymous user can't view Elements Spreadsheet
  • SP-448 - Deleting column breaks formula

This release adds 2 new features:

• Drop-down lists
  • SP-451 : Drop-down lists to organize your data and ensure consistency
• Color picker
  • SP-452 : Extended color palette with color picker to save personalized colors for your text or cell fill

And fix following bugs :

• SP-385 : Copy or Cut/Paste a very very long number doesn't work
• SP-356 : Bad calculation round
• SP-453 : Error when use formula
• SP-454 : Error when importing document
• SP-425 : Cmd +... / Ctrl +... delete cell content
• SP-455 : Weird background color imported from Excel
• SP-443 : Error in selection with merging cells
• SP-456 : Error when exporting user mention in xls

This release adds 2 new features:

• Drop-down lists
  • SP-451 : Drop-down lists to organize your data and ensure consistency
• Color picker
  • SP-452 : Extended color palette with color picker to save personalized colors for your text or cell fill

And fix following bugs :

• SP-385 : Copy or Cut/Paste a very very long number doesn't work
• SP-356 : Bad calculation round
• SP-453 : Error when use formula
• SP-454 : Error when importing document
• SP-425 : Cmd +... / Ctrl +... delete cell content
• SP-455 : Weird background color imported from Excel
• SP-443 : Error in selection with merging cells
• SP-456 : Error when exporting user mention in xls

This release fix the following issues:

• SP-435 : Documents with a name containing the '&' character cannot be loaded
• SP-431 : Bad behaviour for decimal places with autoformat cells
• SP-429 : Columnselection not correctly when merging first/last row
• SP-430 : Chart are no longer renderered after 3.4 update

This release fix the following issues:

• SP-435 : Documents with a name containing the '&' character cannot be loaded
• SP-431 : Bad behaviour for decimal places with autoformat cells
• SP-429 : Columnselection not correctly when merging first/last row
• SP-430 : Chart are no longer renderered after 3.4 update

This release fix the following issues:

• SP-424 : Can't view/edit spreadsheet after upgrade
• SP-427 : Table with more than 199 lines shows no data when imported and edited

This release fix the following issues:

• SP-424 : Can't view/edit spreadsheet after upgrade
• SP-427 : Table with more than 199 lines shows no data when imported and edited

This release includes several new features:

• SP-150 : Prevent concurrent edition
• SP-400 : Allow user mention

We also fixed the following issues:

• SP-311 : now() is only evaluated in the Editor > not in display
• SP-371 : Limit to 1Mb the size of imported documents to avoid application crash
• SP-377 : Confluence Date Picker Issue
• SP-378 : Cut from a merged cell and Paste in an unmerged cell should preserve source merge configuration
• SP-388 : F2 clears the current cell content
• SP-395 : Formula erased when clicking on referenced cell
• SP-402 : Number & Standard format with numbers are not well imported from Excel
• SP-403 : IE11 Cannot select content (in merged or unmerged cell)
• SP-404 : Ctrl + S in edition is caught by Confluence
• SP-408 : Alphabetical edition issue after saving and reopening spreadsheet

This release includes several new features:

• SP-150 : Prevent concurrent edition
• SP-400 : Allow user mention

We also fixed the following issues:

• SP-311 : now() is only evaluated in the Editor > not in display
• SP-371 : Limit to 1Mb the size of imported documents to avoid application crash
• SP-377 : Confluence Date Picker Issue
• SP-378 : Cut from a merged cell and Paste in an unmerged cell should preserve source merge configuration
• SP-388 : F2 clears the current cell content
• SP-395 : Formula erased when clicking on referenced cell
• SP-402 : Number & Standard format with numbers are not well imported from Excel
• SP-403 : IE11 Cannot select content (in merged or unmerged cell)
• SP-404 : Ctrl + S in edition is caught by Confluence
• SP-408 : Alphabetical edition issue after saving and reopening spreadsheet

This release fix the following issue:

• SP-415 : Error when migrate old document from 3.2.0 to 3.3.0 without style

This release fix the following issue:

• SP-415 : Error when migrate old document from 3.2.0 to 3.3.0 without style

This release includes several minor features:

• SP-376 : UI - Dynamic resizing of header bars
• SP-380 : UI - Add editor in Popup
• SP-379 : Add auto format to detect cell content (equivalent to Excel Standard format)
• SP-383 : Compatibility when importing previous versions of SSC and compatibility between Cloud and Server configurations

We also fixed the following issues:

• SP-369 : Formula doesn't work with empty cells with style in reference
• SP-382 : Set / unset cell borders
• SP-384 : Automatic date calculation when stretching cells
• SP-365 : UI - Keep state for alignment buttons
• SP-364 : UI - Fx button doesn't clear formula

This release includes several minor features:

• SP-376 : UI - Dynamic resizing of header bars
• SP-380 : UI - Add editor in Popup
• SP-379 : Add auto format to detect cell content (equivalent to Excel Standard format)
• SP-383 : Compatibility when importing previous versions of SSC and compatibility between Cloud and Server configurations

We also fixed the following issues:

• SP-369 : Formula doesn't work with empty cells with style in reference
• SP-382 : Set / unset cell borders
• SP-384 : Automatic date calculation when stretching cells
• SP-365 : UI - Keep state for alignment buttons
• SP-364 : UI - Fx button doesn't clear formula

In this version, we fixed a security vulnerability (Cross-Site Scripting) (SP-353). We also fixed the following issues:

• SP-335 : Better improvement of copy / paste with formula.
• SP-315 : Editor removes border.
• SP-349 : Encoding problem with formula.
• SP-346 : Bad encoding when exporting to excel
• SP-107 : Manage filters values in system clipboard
• SP-331 : Keep text format
• SP-321 : Cells referenced by a IF() function not highlighted when focus is on formula

In this version, we fixed a security vulnerability (Cross-Site Scripting) (SP-353). We also fixed the following issues:

• SP-335 : Better improvement of copy / paste with formula.
• SP-315 : Editor removes border.
• SP-349 : Encoding problem with formula.
• SP-346 : Bad encoding when exporting to excel
• SP-107 : Manage filters values in system clipboard
• SP-331 : Keep text format
• SP-321 : Cells referenced by a IF() function not highlighted when focus is on formula

In this version, we fixed the following issues:

• SP-343 - Cell with DateTime format not correctly rendered
• SP-342 - Usage of arrows keys when editing a cell not working
• SP-341 - Some formula references are not detected
• SP-340 - Solving error when importing xls file with hidden data

In this version, we fixed the following issues:

• SP-343 - Cell with DateTime format not correctly rendered
• SP-342 - Usage of arrows keys when editing a cell not working
• SP-341 - Some formula references are not detected
• SP-340 - Solving error when importing xls file with hidden data

IMPROVEMENTS

• Better interaction with system clipboard
• Columns and rows resizers are now more efficient. You can also reduce a column or a row to its minimal size by double-clicking on the resizer.

FIXES

• Solving issue with the "Disable/enable all" toggle in the Filters panel
• Reinforcement against XSS vulnerability

IMPROVEMENTS

• Better interaction with system clipboard
• Columns and rows resizers are now more efficient. You can also reduce a column or a row to its minimal size by double-clicking on the resizer.

FIXES

• Solving issue with the "Disable/enable all" toggle in the Filters panel
• Reinforcement against XSS vulnerability

Filters are back in Elements Spreadsheet but better and smarter.

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

• Add, remove and organize filters to narrow down your data sets
• Activate or deactivate filters applied to a sheet, either individually or globally

Filters are back in Elements Spreadsheet but better and smarter.

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

• Add, remove and organize filters to narrow down your data sets
• Activate or deactivate filters applied to a sheet, either individually or globally

NEW

• You can now specify headers and footers in your document.
• Elements Spreadsheet documents can be sorted by columns

IMPROVEMENTS

• SP-326 : Adding information about non-activated licences
• SP-327 : Information about saving progression on cloud
• Vertical and horizontal alignements buttons are now grouped in the toolbar
• A click on the top-left part of the table trigger a "Select all" action

FIXES

• SP-312: Hyperlink truncation is now fixed
• SP-329: The displayed sheet is directly opened in the editor
• Hide rows/columns from the cell context menu is now working

NEW

• You can now specify headers and footers in your document.
• Elements Spreadsheet documents can be sorted by columns

IMPROVEMENTS

• SP-326 : Adding information about non-activated licences
• SP-327 : Information about saving progression on cloud
• Vertical and horizontal alignements buttons are now grouped in the toolbar
• A click on the top-left part of the table trigger a "Select all" action

FIXES

• SP-312: Hyperlink truncation is now fixed
• SP-329: The displayed sheet is directly opened in the editor
• Hide rows/columns from the cell context menu is now working

Fix times formats issues

Fix times formats issues

Valiantys Software has a new name: Elements, a Valiantys company!

We've also renamed our products to provide consistency and clarity across our apps portfolio.

Spreadsheets will now be called Elements Spreadsheet.

Fixed bugs

• SPREAD-317 Incorrect references in unsaved drafts with an origin
• Better excel import

Valiantys Software has a new name: Elements, a Valiantys company!

We've also renamed our products to provide consistency and clarity across our apps portfolio.

Spreadsheets will now be called Elements Spreadsheet.

Fixed bugs

• SPREAD-317 Incorrect references in unsaved drafts with an origin
• Better excel import

Fixed issue with safari and formula function selection crash

This version enhances the way you can use spreadsheets in an advanced intuitive editor dedicated to Confluence. It now features:

• Over 400 formulas, including VLOOKUP, COUNTIF and CONCATENATE
• An improved UI with a native Confluence look and feel, date picker, full screen display, drag & drop tabs feature, floating formula editor

You can still import from & export to Excel, and use integration with third-party apps like Table Filter and Charts.

Note: documents created or edited with previous versions are compatibles with this version of Spreadsheets

Rollback is possible with Spreadsheets for Confluence 2.5.6.

This version enhances the way you can use spreadsheets in an advanced intuitive editor dedicated to Confluence. It now features:

• Over 400 formulas, including VLOOKUP, COUNTIF and CONCATENATE
• An improved UI with a native Confluence look and feel, date picker, full screen display, drag & drop tabs feature, floating formula editor

You can still import from & export to Excel, and use integration with third-party apps like Table Filter and Charts.

Note: documents created or edited with previous versions are compatibles with this version of Spreadsheets

Rollback is possible with Spreadsheets for Confluence 2.5.6.

Added forward compatibility with the upcoming V3 release

Added forward compatibility with the upcoming V3 release

Fixed issues with some instances of confluence and internet explorer while saving a document

Added support for older confluence versions

This version enhances the way you can use cells and improves the user experience. You can now:

• Merge and unmerge cells
• Display content in cells on several lines
• Be warned when you leave the edition of an unsaved document

The menu in the display view can now be rendered in French, English, German, Spanish, and Russian.

We've also fixed a bug: from now on the 'Create page' keyboard shortcut is no longer active when editing your Spreadsheets document from a page in display mode - SPREAD-259

We're happy to bring new awaited features to Spreadsheets with this version. You can now:

• Export your Spreadsheets for Confluence tables to Microsoft Excel - SPREAD-100 & SPREAD-77
• Choose to render your spreadsheets as defined in the editor or adapt their width to the size of your Confluence page. This new display option allows you to have an harmonize the width of your spreadsheets when you have multiple tables in the same page.

Our objective with this new version of Spreadsheets is to make it impossible to distinguish Spreadsheets table with Confluence tables.

• Read our blog article
• Discover all the new features and bug fixes

With this new version of Spreadsheets, we've enhanced the way your spreadsheets are integrated in your Confluence pages.

From now on :

• Spreadsheets documents can be used in Confluence templates and blueprints
• You can select which sheets are visible in the Confluence page. It's ideal to break down your report into multiple sections, and display only a sheet at a time.

In this version, we improved the integration of Spreadsheets with Confluence.Now Spreadsheets tables are:

• visible in PDF exports of Confluence pages
• embeddable in other macros (you can generate charts !)

But that's not all :

• the editor has been redesigned
• we have fixed some bugs

And last but not least, Spreadsheets document are loaded instantly when viewing a page!

Note We changed the way Spreadsheets are stored in Confluence. After install, editors will be asked to upgrade their document.But no worries, documents created with this version will still be compatible with the previous one, so a downgrade to 2.0.2 is possible.

This is a recommended update for all Spreadsheets 2.0.0 & 2.0.1 users.

Bug fixes:

• Unable to import a file while creating a new Spreadsheets in Confluence 5.9+ (SPREAD-86)
• Issues when hitting escape while editing a formula or the title (SPREAD-96, SPREAD-95, SPREAD-94)
• Do not display the edit button to users with only read permission (SPREAD-50)
• Cannot navigate with arrow keys before clicking inside the editor (SPREAD-91)

• SPREAD-93 Issue with Spreadsheets preventing file upload and document preview

The original viewer has been replaced with a real table that displays only what you need and integrates smoothly in a Confluence page.

Note : data model has changed for this new 2.0 version. As a consequence, documents created or edited with this version of Spreadsheets won't be compatible with previous versions.

Bug fix :

• Impossible to edit a Spreadsheets from the "edit" page

This release fix a major bug affecting all version of Chrome >= 41 :

• SPREAD-54 - Spreadsheets plugin is not shown in Confluence
• SPREAD-58 - Can't get spreadsheets to work due to js errors

It is highly recommanded to install this release.

In this release we improved the support of Dates and Currencies in Excel imports but, above all, we removed the infinite scroll from the read only views.

Features:

• New design for the editor view
• Date support
• All selected columns/rows are now resized when resizing a single column/row in the selection
• More visible indicator in case columns or rows are hidden

Bug fixes:

• Scroll shall skip hidden rows and columns
• Fixed rounding issues
• Cannot edit title with navigation keys
• Copy / Paste from display view doesn't work
• Copy / Paste Row with formula produce NaN
• Sorting data break formula
• Decimal cell fill does not keep the format and display approximate values in the edit line

Performances:

• Faster document load
• Spreadsheets embedded on a page only when needed

Bug fixes :

• [SPREAD-27] - Using I.E. locks the session up when trying to load an xls from existing document
• [SPREAD-30] - copy paste doesn't work in any way
• Caret position incorrect when referencing another sheet in formula in IE9
• Currency formatting is not imported
• The size of the filter select box should be limited
• Sheet reference not updated when deleting row or column
• Sheets name disappear when dragging left panel to the right
• Formula copy (drag & drop) does not retain $ ($A$1 becomes A1)
• Hidden cells are navigable with arrows keys

Improve runtime performances on large documents.

Bug

• [SPREAD-6] - Spreadsheet gives wrong result on simple calculation

Improvement

• [SPREAD-20] - Wrap Text
• Formulas dialog helper when 'clicking' on Fx button

New Feature

• [SPREAD-15] - Inplace-Editing of the spreadsheets (no need to go into edit-mode)
• Fullscreen mode

Support Request

• [SPREAD-5] - Upcoming Features - when will it be available?

New Feature

• Sorting
• Filtering
• Excel import

Change request

• Display oversized numbers as '######' in cells
• Use values from other sheets

Bug

• I can't underline and strike a word at the same time
• IE8 Caret not correctly positioned when selecting cell while editing formula
• IE8 compatibility broken
• Bug in formula : Addition is not commutative.
• All minus value between -0.9 and -0.1 are displayed without the minus
• Performance issue with formulas
• When I click on the toolbar buttons, popup shows up
• Undo/Redo after creating a new sheet displays javascript errors
• Bug copy/cut/paste cut is not working
• Insert right columns has problem with style/format
• Duplicate sheet error, cannot switch between sheets
• Copy / Paste style - can't copy / paste style a "no style" cell
• Changes in Spreadsheets are not visible in view mode in IE
• Add or remove decimals - strange behaviour when using number format and removing decimals
• Possible to open rename sheet input in view mode

• Fixed a javascript AMD conflict (random issue)
• Fixed plugin logo in UPM :)

• Confluence 5.6.X compatibility
• Bug fix about number displayed incorrectly after document reload

Bug fixes

• Move with arrow keys does not scroll the table
• Issue when I add decimal
• Link help button to HTML or to valiantys web site
• Safari : Macro resize not taken into account
• General UI ergonomics
• Sheet name contains a ' (quote) are not displayed
• Scroll bug when at the top of sheet
• Height of lines containing values are oversized in FF
• Bug when clear content for all document
• When a cell on the last column is selected, the entire line is selected
• Selection grip is not visible when selection greater than grid
• When the attachment is missing, the error is not displayed correctly
• Alignment button not working
• Current cell editing value lost when clicking save button
• Formatting buttons inactive in other sheets
• Javascript error message in read only when resizing column/row
• Crash with the ATANH(x) function when x=-1 and x=1
• Add missing key bindings

This is the first release of Spreadsheets for Confluence!

Included features :

• Full spreadsheet editor
• Functions and calculations
• Advanced cell formatting and styling
• Undo / Redo
• Copy / Paste
• Multiple data types

Current limitations :

• No support for IE8/IE9 yet (coming soon).
• No cell reference between sheets yet.