질문하기

Liberty Belle's profile - activity

2019-02-27 02:59:49 +0200 질문에 댓글을 달았습니다 pdf export not working

I am on an even older iMac (late 2009) also running OS 10.13.6. LO 6.1.5.2 I just created a simple Writer doc and expor

2019-01-29 09:56:23 +0200 받은 배지  유명한 질문 (source)
2018-11-13 16:00:30 +0200 으뜸 답변으로 표시됨 Imported csv date formatting adds an apostrophe to the beginning of dates

Version: 6.0.3.2 Mac OS High Sierra 10.13.4

When I import a csv file and format the date column, LO adds an apostrophe to the beginning of each date. This apostrophe is only visible in the formula field. It's really weird. How can I stop this behavior?

It actually prevents the date from formatting correctly. I had formatted it to MM/DD/YY and at first I couldn't figure out why the formatting didn't 'take'. When I took a closer look, I saw the little apostrophe up in the formatting bar.

It looks like this is an old problem, as I found an old, unanswered thread on this: https://ask.libreoffice.org/en/questi...

image description

2018-11-10 19:36:18 +0200 질문에 댓글을 달았습니다 how can I secure a spreadsheet?

No, it very much does depend on the file format saved in. I have filed two bug reports detailing this behavior, and I

2018-11-10 19:36:05 +0200 질문에 댓글을 달았습니다 how can I secure a spreadsheet?

No, it very much does depend on the file format saved in. I have filed two bug reports detailing this behavior, and I d

2018-11-10 19:35:57 +0200 질문에 댓글을 달았습니다 how can I secure a spreadsheet?

No, it very much does depend on the file format saved in. I have filed two bug reports detailing this behavior, and I do

2018-11-10 19:34:16 +0200 질문에 댓글을 달았습니다 how can I secure a spreadsheet?

No, it very much does depend on the file format saved it. I have filed two bug reports detailing this, and I don't belie

2018-11-04 19:23:33 +0200 받은 배지  주목할 만한 질문 (source)
2018-11-04 08:49:56 +0200 받은 배지  유명한 질문 (source)
2018-09-05 21:05:56 +0200 받은 배지  주목할 만한 질문 (source)
2018-09-05 21:05:56 +0200 받은 배지  유명한 질문 (source)
2018-09-04 19:41:50 +0200 질문에 댓글을 달았습니다 how can I secure a spreadsheet?

Please be aware that passwords don't work very well if you are saving to Excel file types. You can set them up, but othe

2018-08-31 23:43:35 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

@Ratslinger can you take a look and see if this is the same bug https://bugs.documentfoundation.org/show_bug.cgi?id=1124

2018-08-31 19:38:26 +0200 질문에 답변하였습니다 LO 6.0.6.2 prints blank page

I am using the same version of LO and the same version of macOS, yet I am able to print Writer documents without issue.

2018-08-31 19:16:26 +0200 으뜸 답변으로 표시됨 Re-setting the primary key in Firebird embedded databases after deleting records

LO 6.0.6.2 on macOS High Sierra 10.13.6

When using the embedded HSQLDB in LO, I am able to re-set / restart the primary key if I delete some rows from a table and want new records to start where the remaining ones left off, but when I try this using the embedded Firebird database, I get an error message and can't do it.

Should I report this as a bug? Feature request? I think most people would like the option to have the primary key continue where the last current record leaves off.

Example: I have a table with records 1-30 with the primary key AutoValue set to Yes. I delete records 16-30. When I add new records, LO starts the primary key sequence at 31.

If I'm using the embedded HSQLDB and I want Base to "re-use" ID's 16-30, I can edit the table, set the primary key AutoValue to No, save the table, save the database, go back into edit mode, once again set the AutoValue for the primary key to Yes, saving everything. Then when I add new records, the next record will start with 16 again, leaving no gaps in the primary key sequence.

Unfortunately, this doesn't work at all when using the Firebird embedded database. When I delete records and then set the primary key AutoValue to No and try to save the table, I get an error message: "Warning. The column "ID" could not be changed. Should the column instead be deleted and the new format appended?"

I definitely don't want to delete all my existing primary key values, so I'm stuck.

2018-08-31 19:16:23 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

I think I will report all these bugs. Especially troubling is the inability to change AutoValue from no to yes. It's suc

2018-08-31 19:14:42 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

Got it. And you're right -- despite the error message, once I added new data Base did indeed restart the numbering exact

2018-08-31 18:13:44 +0200 받은 배지  인기있는 질문 (source)
2018-08-31 06:02:47 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

Even if I then redo the statement and ask it to restart with 16 or 17 or 18, I just keep getting the same error message

2018-08-31 05:59:31 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

BUT there's something else funny. When I told it to restart with 16, it actually restarted with 17. No problem, I though

2018-08-31 05:58:42 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

Yes, I just found that out myself. I decided to create a whole new table using Design View. Then I did get the alter sta

2018-08-31 05:13:32 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

That is truly strange, because the AutoValue was set to yes. I imported data from a spreadsheet that didn't have any pri

2018-08-31 04:53:18 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

You're not picky. I think I said it incorrectly / sloppily. I'm still doing something wrong, though. I used the quote ma

2018-08-31 04:30:07 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

Both my table name and my field name have spaces in between two words (Employee Table and Employee ID). Do I need sing

2018-08-31 04:27:26 +0200 코멘트달린 답변 Re-setting the primary key in Firebird embedded databases after deleting records

It's Tools > SQL on Mac as well. (Much of the rest of the Tools menu is in Preferences on a Mac.)

2018-08-31 01:00:29 +0200 질문하였습니다 Re-setting the primary key in Firebird embedded databases after deleting records

Re-setting the primary key in Firebird embedded databases after deleting records LO 6.0.6.2 on macOS High Sierra 10.13.6

2018-08-30 18:23:35 +0200 받은 배지  주목할 만한 질문 (source)
2018-08-30 03:49:03 +0200 으뜸 답변으로 표시됨 Created a database in MySQL, unable to connect via SBDC to LO Base
  • Mac desktop (64 bit)
  • OS High Sierra 10.13.6
  • LO 6.0.6.2
  • Java Runtime Environment 10.0.2 installed and currently in use (LO Preferences > Advanced)

This is my first time creating a MySQL database and connecting it to LO. I successfully created the database via the mysql command line: "Query OK, 1 row affected". I can also see this database in MySQL Workbench.

I downloaded and installed the native SBDC driver from https://www.arielch.org/aoo/aoo-my-sdbc/ (Mac OSX Version Apache OpenOffice4.1). I restarted LO. When I open a Writer doc and go to Tools > Extensions, I see this SBDC driver listed there.

I then perform the following steps to connect my new database:

  1. New Database
  2. Connect to existing > MySQL
  3. Connect directly
  4. Database name: myfirstsqldb
  5. Server: localhost
  6. Port: 3306 (verified this is correct in MySQL Workbench; there is an active connection on this port)
  7. User name: root
  8. Tick the “password required” box
  9. Input my root password I set up originally with MySQL.
  10. Click the Test Connection box.

I get the following error message, “A driver is not registered for the URL sdbc:mysql:mysqlc:localhost:3306:myfirstsqldb"

What did I do wrong?

2018-08-30 03:44:35 +0200 질문에 댓글을 달았습니다 calc save as to excel rejected passsword for excel sheet

FYI, password protection for some of the Excel save-as options doesn't really work. LO will allow you to set passwords,

2018-08-30 03:27:50 +0200 질문에 댓글을 달았습니다 Background Image

@Regina OK and thank you. I did run into some issues with the background image in my version of LO.

2018-08-22 02:28:30 +0200 질문에 답변하였습니다 Writer: shortcut key for delete current line

I don't know that there is such a thing, but you can select the entire current line and then hit Delete: https://www.go

2018-08-21 19:23:05 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

I think I will go with the Firebird 3 Server then. That's perfect. Having many options is great, but it sure can make yo

2018-08-21 17:36:21 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

OK. I am now thinking either Firebird 3 Server or Firebird embedded. Why might someone choose one of these over the othe

2018-08-21 17:24:33 +0200 코멘트달린 답변 Can you place a Chart on its own Tab in Calc, as you can in Excel?

"I can copy and past a Chart onto a new Tab but not in the way you can in Excel, i.e. not so that the Tab only shows the

2018-08-21 17:21:14 +0200 질문에 댓글을 달았습니다 Background Image

@Regina -- How do you add a background image to text frames in the Frame > Area dialog? In the past, this worked, but

2018-08-21 17:11:03 +0200 질문에 댓글을 달았습니다 Background Image

@Regina -- I create business cards in Writer through File > New > Business Cards. These, by definition, are always

2018-08-21 17:09:13 +0200 질문에 댓글을 달았습니다 Background Image

@Regina -- I create business cards in Writer through File > New > Business Cards. What other way is there?

2018-08-21 17:04:22 +0200 코멘트달린 답변 Can you place a Chart on its own Tab in Calc, as you can in Excel?

"I can copy and past a Chart onto a new Tab but not in the way you can in Excel, i.e. not so that the Tab only shows the

2018-08-21 02:53:08 +0200 질문에 댓글을 달았습니다 Background Image

I've been trying to do this. I know how to add a background image to a Writer doc, set the transparency to 50%, and make

2018-08-21 01:07:32 +0200 코멘트달린 답변 How to make exact copies of cells?

I guess I thought it was obvious that you would be selecting rows instead of cells, since that's what you were asking ab

2018-08-21 00:03:37 +0200 질문에 답변하였습니다 Can you place a Chart on its own Tab in Calc, as you can in Excel?

It would be really helpful if you gave your operating system and version of LibreOffice when asking questions. On my M

2018-08-20 23:53:32 +0200 질문에 답변하였습니다 calc: Format of email address

To change the color of the hyperlink text, go into LibreOffice Preferences. In the first section, LibreOffice, you will

2018-08-20 23:25:58 +0200 질문에 답변하였습니다 How to make exact copies of cells?

You don't say what computer, operating system, or version of LO you are using. On my Mac with version 6.0.6.2 of LO, cop

2018-08-20 23:05:54 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

Ratslinger, thank you so much for all your help. I know it's my decision, it's just a bit overwhelming for a novice in t

2018-08-18 22:09:32 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

As far as using the Firebird 3 embedded database, right now I am using the latest stable version of LO, which I don't th

2018-08-18 22:03:33 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

I am using Base for a number of things: uploading financial and online sales channel spreadsheets so that I can more eas

2018-08-17 18:37:22 +0200 코멘트달린 답변 Created a database in MySQL, unable to connect via SBDC to LO Base

Thanks again. So maybe it's worthwhile for me to switch to PostgreSQL instead of MySQL?