Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
SEO Metadata
composedTitlePlay SQL Spreadsheets
robotsNo index
titlePlay SQL Spreadsheets

Images can now be pasted or uploaded in Play SQL.

Info
titleHighlight of the release
  • Images can now be pasted or uploaded in Play SQL.
  • The default limit is 3Mb, it is possible to change the limit or disable them.

Images

Since 

Jira
serverJIRA
serverIdc44f7f6b-309d-3e24-ae45-f50de66a98eb
keyPLAYSQL-252
, it is now possible to paste images in cells:


You just have to set the type "Image":

Images can be imported by:

  • Uploading,
  • Pasting an image in the cell,
  • Pasting the URL of an image,
  • Pasting cells from another spreadsheet from the same space.

How are images stored?

Images are stored with the binary type BYTEA. It's a variable-length binary string. The binary string starts with metadata, then the file starts after a dozen bytes (depending on the type and version).

Administrator notes

  • It is possible to limit the size of images,
  • It is possible to disable images entirely.
  • The default size is 3Mb.


Issue list

Jira
serverJIRA
columnskey,summary,type,status,resolution,components
maximumIssues20
jqlQueryproject = PLAYSQL AND fixVersion = 3.1.0
serverIdc44f7f6b-309d-3e24-ae45-f50de66a98eb

Upgrade notes

  • The "PSEA" plugin will be installed together with Play SQL Base or Spreadsheets. It is required. It performs the Excel exports.
  • The Legacy SQL Macro was removed in a previous version. Please do not upgrade if you still require it.
  • If you upgrade from Play SQL 2.6, there are new requirements:
  • If you upgrade from Play SQL 2.9, there are schema changes:

Known issues

Jira
serverJIRA
columnskey,summary,type,status,resolution
maximumIssues20
jqlQueryproject = PLAYSQL AND (affectedVersion = 3.0 OR affectedVersion = 3.0.x)
serverIdc44f7f6b-309d-3e24-ae45-f50de66a98eb