Writer/Paste and Match Style Specification

From Apache OpenOffice Wiki
Jump to: navigation, search

Writer Icon.png

Writer Project

Please view the guidelines
before contributing.

Popular Subcategories: The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` WHERE 1=1 AND `page`.page_namespace IN (14) AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 5 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)


Internal Documentation: The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` WHERE 1=1 AND `page`.page_namespace IN (0) AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 5 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)


API Documentation:

Ongoing Efforts: The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` WHERE 1=1 AND `page`.page_namespace IN (0) AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 5 OFFSET 0

Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)


Sw.OpenOffice.org


Book-old.png    This article is outdated.    

THIS DOCUMENT IS NOT VALID ANYMORE - IT IS STORED ONLY FOR ARCHIVAL REASONS

Writer

Document - ID Specification Owner Last Change Status
Draft
Conforms to
Applies to sw, officecfg
Task ID(s)
Category Enhancement

Abstract

The Paste and Match Style command and associated keyboard shortcut (CTRL-ALT-SHIFT-V on Windows/Linux, Cmd-Option-Shift-V on Mac) makes it possible to use the styling of OpenOffice.org documents more efficiently and in powerfully consistent way.

The greatest advantage is that no matter where the copied content originated from (web page, another office program, ...) the styling of the document being worked on is maintained by using the styling of the target document also in the pasted content.

i-Team Members (The specification owner is part of the i-Team)

Name E-mail Address
User Experience Mox Soini mox@openoffice.org
Development Mox Soini mox@openoffice.org
Quality Assurance <Name + Initials>
Documentation <Name + Initials>


Document Change History

Rev. Level Change Initials Date
1.0 initial version mox 2009-03-17
1.1 updated dimming/functionality definition mox 2009-03-31
1.2 OBSOLETE mox 2009-04-02


Motivation

While it is technically possible to achieve a similar functionality via "Paste Special -> Unformatted text", it is highly cumbersome and hard to discover. "Unformatted text" does not truly express what a powerful tool it can be.

User Scenarios

User copies text from a web page and pastes it to the document he works on. Styling Just Works. No additional work needed.

Goals

Make powerful pasting functionality understandable to users. Make it efficient to use pasting so that target document style consistent through-out the document.

Requirements and Dependencies

Requirements

Menu item "Paste and Match Style" under "Paste" menu item in "Edit" menu Shortcut key: CTRL-ALT-SHIFT-V on Windows/Linux, Cmd-Option-Shift-V on Mac

Technical Dependencies

Not known.

Competitive Analyses

Apple's iWork has this functionality and it's extremely useful and efficient for those interested in high quality documents.

Detailed Specification

See also requirements.

Menu item "Paste and Match Style" in "Edit" menu

  • Below "Paste" menu item
  • Above "Paste Special" menu item (if it exists)

Shortcut key: CTRL-ALT-SHIFT-V on Windows/Linux, Cmd-Option-Shift-V on Mac

Initial implementation relies fully on the functionality provided by the existing "unformatted text" functionality (i.e. SOT_FORMAT_STRING paste type). However, in the future this functionality could be improved beyond the simple unformatting of the source content.

String list

Item English German French Spanish Comments
Menu item Paste and Match Style Einsetzen und Stil anpassen Coller et appliquer le style Pegar con el mismo estilo


Error Conditions

Menu item is dimmed if this kind of pasting is not possible. Same rules as with the OOo 3.1 command: Edit -> Paste Special -> Unformatted text.

Migration

Not needed.

Future Tasks

In the future this functionality could be improved beyond the simple unformatting of the source content.

Notes

None at this time.

References

Personal tools