Publicação
Model-based programming environments for spreadsheets
| Resumo: | Although spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus. |
|---|---|
| Autores principais: | Cunha, Jácome Miguel Costa |
| Outros Autores: | Saraiva, João Alexandre; Visser, Joost |
| Assunto: | Ciências Naturais::Ciências da Computação e da Informação |
| Ano: | 2012 |
| País: | Portugal |
| Tipo de documento: | comunicação em conferência |
| Tipo de acesso: | acesso aberto |
| Instituição associada: | Universidade do Minho |
| Idioma: | inglês |
| Origem: | RepositóriUM - Universidade do Minho |
| _version_ | 1867438274888335360 |
|---|---|
| author | Cunha, Jácome Miguel Costa |
| author2 | Saraiva, João Alexandre Visser, Joost |
| author2_role | author author |
| author_facet | Cunha, Jácome Miguel Costa Saraiva, João Alexandre Visser, Joost |
| author_role | author |
| contributor_name_str_mv | RepositóriUM - Universidade do Minho |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Cunha, Jácome Miguel Costa\"},{\"Person.name\":\"Saraiva, João Alexandre\"},{\"Person.name\":\"Visser, Joost\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | RepositóriUM - Universidade do Minho |
| datacite.creators.creator.creatorName.fl_str_mv | Cunha, Jácome Miguel Costa Saraiva, João Alexandre Visser, Joost |
| datacite.date.Accepted.fl_str_mv | 2012-01-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2015-06-17T14:39:01Z |
| datacite.date.embargoed.fl_str_mv | 2015-06-17T14:39:01Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.fl_str_mv | Ciências Naturais::Ciências da Computação e da Informação |
| datacite.titles.title.fl_str_mv | Model-based programming environments for spreadsheets |
| dc.contributor.none.fl_str_mv | RepositóriUM - Universidade do Minho |
| dc.creator.none.fl_str_mv | Cunha, Jácome Miguel Costa Saraiva, João Alexandre Visser, Joost |
| dc.date.Accepted.fl_str_mv | 2012-01-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2015-06-17T14:39:01Z |
| dc.date.embargoed.fl_str_mv | 2015-06-17T14:39:01Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | https://hdl.handle.net/1822/35642 |
| dc.language.none.fl_str_mv | eng |
| dc.publisher.none.fl_str_mv | Springer Verlag |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| dc.subject.none.fl_str_mv | Ciências Naturais::Ciências da Computação e da Informação |
| dc.title.fl_str_mv | Model-based programming environments for spreadsheets |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_5794 |
| description | Although spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | conferencePaper |
| fulltext.url.fl_str_mv | https://repositorium.uminho.pt/bitstreams/6b4bd87e-641e-494a-8291-87237431e103/download |
| id | rum_14729f62022d4e37e0933cdbbb8e718c |
| identifier.url.fl_str_mv | https://hdl.handle.net/1822/35642 |
| instacron_str | repositorium |
| institution | Universidade do Minho |
| instname_str | Universidade do Minho |
| language | eng |
| network_acronym_str | rum |
| network_name_str | RepositóriUM - Universidade do Minho |
| oai_identifier_str | oai:repositorium.uminho.pt:1822/35642 |
| organization_str_mv | urn:organizationAcronym:repositorium |
| person_str_mv | Cunha, Jácome Miguel Costa Saraiva, João Alexandre Visser, Joost |
| publishDate | 2012 |
| publisher.none.fl_str_mv | Springer Verlag |
| reponame_str | RepositóriUM - Universidade do Minho |
| repository_id_str | urn:repositoryAcronym:rum |
| service_str_mv | urn:repositoryAcronym:rum |
| spelling | engSpringer VerlagporAlthough spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.application/pdfporModel-based programming environments for spreadsheetsCunha, Jácome Miguel CostaSaraiva, João AlexandreVisser, JoostHostingInstitutionOrganizationalRepositóriUM - Universidade do Minhoe-mailmailto:repositorium@usdb.uminho.ptrepositorium@usdb.uminho.ptISBNIsPartOf978-3-642-33181-7ISBNIsPartOf978-3-642-33182-4ISSNIsPartOf0302-9743DOIIsPartOf10.1007/978-3-642-33182-4_102015-06-17T14:39:01Z20122012-01-01T00:00:00ZHandlehttps://hdl.handle.net/1822/35642http://purl.org/coar/access_right/c_abf2open accesshttp://www.oecd.org/science/inno/38235147.pdfFields of Science and Technology (FOS)Ciências Naturais::Ciências da Computação e da Informação363676 bytesother research producthttp://purl.org/coar/resource_type/c_5794conference paperhttp://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://repositorium.uminho.pt/bitstreams/6b4bd87e-641e-494a-8291-87237431e103/download |
| spellingShingle | Model-based programming environments for spreadsheets Cunha, Jácome Miguel Costa Ciências Naturais::Ciências da Computação e da Informação |
| status | SINGLETON |
| subject.other.fl_str_mv | Ciências Naturais::Ciências da Computação e da Informação |
| title | Model-based programming environments for spreadsheets |
| title_full | Model-based programming environments for spreadsheets |
| title_fullStr | Model-based programming environments for spreadsheets |
| title_full_unstemmed | Model-based programming environments for spreadsheets |
| title_short | Model-based programming environments for spreadsheets |
| title_sort | Model-based programming environments for spreadsheets |
| topic | Ciências Naturais::Ciências da Computação e da Informação |
| topic_facet | Ciências Naturais::Ciências da Computação e da Informação |
| url | https://hdl.handle.net/1822/35642 |
| visible | 1 |