DCLG to address open source obstacles

Written by Colin Marrs on 4 November 2014 in News

The Department for Communities and Local Government is to carry out more work on a solution after identifying problems converting Excel documents in open source format.

The department today released its implementation plan for the publication of documents across central and local government in open formats.

From this week, it has promised to publish PDFs and Word documents in PDF/A and ODS formats respectively.

However, on Excel, which are most commonly published as “live” data tables, it said: “Content producers should convert to ODS format before submitting to digital content teams.

“However the statisticians have identified problems with certain spreadsheets – where drop-down filters fail to work when converted – more work needs to be done on finding a solution to this problem and DCLG will to commit to the spreadsheets where possible will be published from 1 November 2014 being in an ODS format.”

DCLG said that it is committed to opening up government and providing a level playing field for open source systems, providing the citizen with free access to government information.

Data which will be excluded from the plans include mini-applications including business applications, calculators, financial models and smart forms.

It said: “Files created by analysts are likely to fall outside the scope of the mandate depending on the business requirement.”

Other exclusions include tabular data that can be used by systems to deliver other services, web pages and complex structured data (such as those in formats such as XML, JSON, and RDF).

A second phase of delivery beginning in March will address a number of challenges to the publication of data.

In addition to the spreadsheet issue, the department said that some documents created using Microsoft Office may not render in the same way in applications that support Open Document Format.

Also, the current version of Microsoft Office only supports the ODF 1.1 standard, and not all applications support the use of ODF formatted documents.

The use of ODF needs to be integrated into business applications, the department added.

A third phase, planned for July, will attempt to embed solutions to the issues within government systems.

This could include a move to Microsoft Office 2013 to meet ODF 1.2 standard and the packaging of Libre Office or a similar system to allow the manipulation of ODF documents.

Share this page



Please login to post a comment or register for a free account.

Related Articles

NHS signs £4.5m deal to ‘transform’ demographic data use and better match patients to records
20 May 2022

Work aims to make it easier for NHS number to be found, which contract says will help reduce issues such as false death notices

Revealed: Vaccine Damage Payment Scheme expects up to 2,500 Covid claims with £6m medical assessment firm appointed
18 May 2022

Commercial documents reveal existing scheme for rare instances of severe adverse reactions expects approximately twentyfold increase in usage

HMRC kick-starts project to create £180m digital one-stop-shop for UK traders
17 May 2022

Digital supplier sought to support work over the coming year

Supplier blacklists and non-compliance investigators: Government’s new procurement regime
13 May 2022

Bill introduced during Queen’s Speech proposes a range of reforms