https://bugs.documentfoundation.org/show_bug.cgi?id=159654
Bug ID: 159654
Summary: Enhancement Feature Request - Center Across Selection
Product: LibreOffice
Version: 7.0 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I would like to request a feature in LibreOffice Calc similar to MS Excel's
Center Across Selection. The goal of this request is as follows:
Introduce a new functionality in LibreOffice Calc that allows users to center
text horizontally across a selected range of cells without merging them. This
feature should mimic the behavior found in other spreadsheet software like
Microsoft Excel. While Calc offers various alignment options, users currently
lack a dedicated way to center text across non-merged cells. As of the moment,
there is no actual workaround, as only "Merge and Center" is available, but
these create visual approximations rather than true centering and can be
cumbersome for frequent use.
Proposed functionality:
Selection: Users can highlight a range of cells where they want to center text.
Activation: A dedicated button or menu option labeled "Center Across Selection"
is available. This could be located in the alignment section of the format menu
or on the toolbar for easy access.
Alignment: Activating the feature automatically redistributes the selected text
content within the chosen range so that it appears visually centered across all
cells. This should work independently of font size, cell width, or other
formatting elements.
Options: Consider offering additional options to fine-tune the alignment:
Padding: Allow users to choose the amount of padding (space) on either side of
the text for precise visual positioning.
Wrapping: Offer options to control how text wraps within the selection (e.g.,
no wrapping, wrap within cells, or specific word wrap settings).
Benefits:
Enhanced formatting capabilities: This feature would significantly improve text
presentation within spreadsheets, offering users a convenient way to create
visually appealing layouts without sacrificing cell independence.
User experience: Implementing "center across selection" aligns with industry
standards and user expectations, making Calc more intuitive and user-friendly
for those familiar with similar functionality in other software.
Efficiency: A dedicated feature would streamline the process of centering text
compared to current workarounds, saving users time and effort.
Actual Results:
The benefits of implementing this feature would be as follows:
Enhanced formatting capabilities: This feature would significantly improve text
presentation within spreadsheets, offering users a convenient way to create
visually appealing layouts without sacrificing cell independence.
User experience: Implementing "center across selection" aligns with industry
standards and user expectations, making Calc more intuitive and user-friendly
for those familiar with similar functionality in other software.
Efficiency: A dedicated feature would streamline the process of centering text
compared to current workarounds, saving users time and effort.
Expected Results:
The benefits of implementing this feature would be as follows:
Enhanced formatting capabilities: This feature would significantly improve text
presentation within spreadsheets, offering users a convenient way to create
visually appealing layouts without sacrificing cell independence.
User experience: Implementing "center across selection" aligns with industry
standards and user expectations, making Calc more intuitive and user-friendly
for those familiar with similar functionality in other software.
Efficiency: A dedicated feature would streamline the process of centering text
compared to current workarounds, saving users time and effort.
Reproducible: Always
User Profile Reset: No
Additional Info:
The benefits of implementing this feature would be as follows:
Enhanced formatting capabilities: This feature would significantly improve text
presentation within spreadsheets, offering users a convenient way to create
visually appealing layouts without sacrificing cell independence.
User experience: Implementing "center across selection" aligns with industry
standards and user expectations, making Calc more intuitive and user-friendly
for those familiar with similar functionality in other software.
Efficiency: A dedicated feature would streamline the process of centering text
compared to current workarounds, saving users time and effort.
--
You are receiving this mail because:
You are the assignee for the bug.
